cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gaborszollosy
Helper I
Helper I

CSV to update Dataverse table daily

Hi!

 

I would like to create a flow that would pull a CSV file from an email address and use that to update and overwrite a Dataverse table.

 

I have all the column names exactly as in the CSV in the Dataverse table. The data is company names, addresses, and such from our CRM, and what I'm trying to do is keep the Dataverse table fresh so PowerApps can work with current data.

 

Can you please help in setting this up?

Thanks in advance!!

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

You can parse the CSV in Power Automate, I did a video on it here: https://www.youtube.com/watch?v=sXdeg_6Lr3o

and a blog post here: https://www.tachytelic.net/2021/02/power-automate-parse-csv/

 

But I also think a dataflow is easier, I tried it out last week and it works great. 

View solution in original post

3 REPLIES 3
Expiscornovus
Super User
Super User

Hi @gaborszollosy,

 

Instead creating a Power Automate flow it might be worth checking out the dataflow feature set.

 

As far as I am aware CSV is one of the supported sources in there:

https://docs.microsoft.com/en-us/power-query/dataflows/create-use

 

Paulie78
Super User
Super User

You can parse the CSV in Power Automate, I did a video on it here: https://www.youtube.com/watch?v=sXdeg_6Lr3o

and a blog post here: https://www.tachytelic.net/2021/02/power-automate-parse-csv/

 

But I also think a dataflow is easier, I tried it out last week and it works great. 

View solution in original post

Thank you for your solution, @Expiscornovus 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Users online (3,586)