cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
msedlock
Regular Visitor

multiple CSV to Dataverse table

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

 

0 REPLIES 0

Helpful resources

Announcements
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)