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,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

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,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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