How to read csv data from SFTP location through Microsoft Flow and Import into Dynamics 365 Finance and Operations

File based integration with Dynamics 365 Finance and Operation using Power Automate

Step 1: Login to Power Automate

Step 2: Create New Flow Connector

Step 3: Add Trigger Point SFTP Folder 'When a file is added or modified'

(This operation triggers a flow when a file is added or modified in a folder. The trigger will fetch both the file metadata as well as the content of the file. The trigger relies on the last modified time of a file. If a file is being created by a third-party client, the preservation of the last modified time should be disabled in the client. Files larger than 50 megabytes are skipped by the trigger)

Step 4: Create SFTP connection and select the folder.

Step 5: Add new Action step 'Get file content'

Step 6: Add new Action step 'Dynamics 365 FO' with in 'Apply to each' action.