
Announcements
Hello
Need some assistance with a dataflow.
Task:
we receive a daily download of CSV files via sFTP (via a Flow). They are stored in SharePoint (could be OneDrive). Each CSV file name is unique. I would like to load the data from each CSV into a Dataverse Table. I will then run a Flow using that table to process the data into my ERP. Once the data is processed into ERP, update a Flag on the records as Processed. Then move the files to a processed folder.
Problem: how do build a Dataflow to read all the files in the folder (files in folder change daily) and load into the table?
any help greatly appreciated.
Thank you for reading