CSV Email Attachment Data Extraction to import into Dataverse Table

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

Our phone system emails us csvs of our call history nightly (there are 6 reports) and we would like to take the csvs and populate a Dataverse Table.

Since is an export from their server it has a lot of unnecessary rows that I was trying to use the Create Table action to bypass but I keep getting a "RequestUriTooLong" Error.

Flow:

Screenshot 2023-05-11 135558.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

takolota1 4,974 Moderator on at

Like (1)

Report

@gfeldhake

You may want to check out Dataflows for parsing CSVs to Dataverse

https://youtu.be/8IvHxRnwJ7Q

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report

Thanks @takolota,

I have been working through their steps and for some reason my csv rows are being deleted so nothing is getting populated to the Dataverse Table.
Is there something I am missing?

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report

I think it has to do with the way I have the flow getting the content of the attachment. In this last run I realized that it is putting the body of the email into the csv file, deleting the data.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@gfeldhake

I actually have yet to use the Dataflows method myself as it only goes to Dataverse.

But if you end up running into too many challenges with that method, I have an alternate, more general purpose template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (1)

Report

Thank you! I was able to figure out the error with the https://youtu.be/8IvHxRnwJ7Q steps; one of my columns was a percentage and wasn't being read correctly.

Was this reply helpful? Yes No