web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / CSV Email Attachment D...
Power Automate
Unanswered

CSV Email Attachment Data Extraction to import into Dataverse Table

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    takolota1 Profile Picture
    4,974 Moderator on at

    @gfeldhake 

     

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

    https://youtu.be/8IvHxRnwJ7Q

  • GF-02121351-0 Profile Picture
    239 on at

    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? 

     

    Screenshot 2023-05-12 110815.pngScreenshot 2023-05-12 113317.png

  • GF-02121351-0 Profile Picture
    239 on at

    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. 

  • takolota1 Profile Picture
    4,974 Moderator on at

    @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

  • GF-02121351-0 Profile Picture
    239 on at

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard