Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

multiple CSV to Dataverse table


Need some assistance with a dataflow.



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



Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,925)