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:
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.
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
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.
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?
You may want to check out Dataflows for parsing CSVs to Dataverse