xpr365Financials

Use Power Automate to automatically import CODA files

You can use Coded Statement of Account (CODA) to automatically process electronic bank statements. In standard Business Central you can manually import CODA statements. xpr365 Finance makes it possible to automate the import of CODA statements using Power Automate. With Power Automate you can create cloud flows that performs one or more tasks automatically after it's triggered by an event. With this flow, files are retrieved from a SharePoint folder, are imported into Business Central and are moved to an archive in SharePoint.

To be able to automatically import CODA files, some settings need to be made in Power Automate.
Setting up this flow requires some basic knowledge of Power Automate. The flow is set up through the Power Automate Platform.

Specify an event to start the flow

First, select what event, or trigger starts your flow.

  1. Sign in to Power Automate.
  2. Create a new flow.
  3. Select Automated Cloud Flow to start the Power Automate Flow. PA1
  4. Enter the flow name and select When a file is created (properties only) as flow trigger. PA2
  5. Define the correct parameters.
    It is important to define the correct folder under Advanced parameters. This is the SharePoint folder where the CODA files are located that need to be imported in Business Central. PA3
  6. Select the Split on checkbox and select @triggerOutput()?['body/value'] in the Array field. PA4

Specify the action to get the file content

Create an action to get the file content.

  1. Insert a new step.
  2. In the box that shows, search for the Sharepoint action Get file content.
  3. Define the correct parameters.
    Enter / in the File Identifier field, select Insert Dynamic Content and search for ID.
    PA5

Specify the action to import the CODA file

Create an action to establish the connection with Business Central and specify what needs to be done with the file.

  1. Insert a new step.
  2. In the box that shows, search for the Dynamics 365 Business Central Run action (V3).
  3. In the Environment and the Company field, select in which environment and company you want to import the CODA files.
  4. In the API Category field, select the API xpr365/coda/v1.0 from xpr365 Financials.
  5. In the Action name field, select the action codaStatement-importCODAFileContent from xpr365 Financials. PA6

Specify the action to move the file

The last step to be done in this flow is to create an action to move the CODA file to an archive.

  1. Insert a new step.
  2. In the box that shows, search for the Sharepoint action Move file.
  3. Define the correct parameters.
    Take special care here that the destination folder does not refer to the same folder as the one where the file is retrieved in the first step. It is recommended to use an achive folder. PA7

Test your flow

Put a file in the SharePoint folder, check if it is imported in Business Central en moved to the archive folder.

See also