Power Platform Community Forum Thread Details

Hi All,

I am going to receive CSV files daily on my mailbox i need to process them in to existing dataverse tables. How do i achieve this using dataflows ? I have read through this https://powerusers.microsoft.com/t5/Building-Flows/CSV-to-update-Dataverse-table-daily/m-p/1223116#M140636 post but i need a solution were the email attchment can be saved to SP library and dataflow to pick up files from here and process them to Dataverse table . Is this possible ?

Categories:

General topics

You should be able to do this with Power Automate. Your trigger would be to watch for incoming emails with the attachment you want to process. Then your actions would be to:

Save file to Sharepoint library
Parse data from CSV file
Save data to Dataverse table

The tricky part is parsing the CSV file data. There isn't anything built in to PA to handle CSV files by default, but there are a couple of options. There are several 3rd party connectors that can process CSV files, but all the ones I am aware of (such as Encodian) require a separate subscription with their service.

But there is a way to do it with the built in functions. You'll have to use several Compose action steps to:

Import contents of CSV file
Break apart rows into an array
Iterate each row to convert it to JSON
Parse the JSON using a defined schema, which will allow you to easily export the data into Dataverse

This depends on the format of the CSV file not changing. It also can be tricky if you have content which is comma separated, but also has commas in the text data fields. If that's the format of your data, you're pretty much limited to a third party solution.