Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

  • GF-02121351-0 Profile Picture
    GF-02121351-0 239 on at
    Re: CSV Email Attachment Data Extraction to import into Dataverse Table

    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. 

  • takolota1 Profile Picture
    takolota1 4,779 on at
    Re: CSV Email Attachment Data Extraction to import into Dataverse Table

    @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
    GF-02121351-0 239 on at
    Re: CSV Email Attachment Data Extraction to import into Dataverse Table

    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. 

  • GF-02121351-0 Profile Picture
    GF-02121351-0 239 on at
    Re: CSV Email Attachment Data Extraction to import into Dataverse Table

    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

  • Verified answer
    takolota1 Profile Picture
    takolota1 4,779 on at
    Re: CSV Email Attachment Data Extraction to import into Dataverse Table

    @gfeldhake 

     

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

    https://youtu.be/8IvHxRnwJ7Q

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard