Skip to main content

Notifications

Power Apps - AI Builder
Answered

How can I export data from a model to a CSV

(0) ShareShare
ReportReport
Posted on by 45

Hi

 

I have created a model which reads data from an invoice (pdf) and I would like to export those data to a CSV file. Can I get some guidance on how this can be achieved?

 

Thank you

 

Shadiya

Categories:
  • shadiya Profile Picture
    shadiya 45 on at
    Re: How can I export data from a model to a CSV

    Thanks @JoeF-MSFT - I have tried the solution and it worked successfully. Thanks again for your help.

  • shadiya Profile Picture
    shadiya 45 on at
    Re: How can I export data from a model to a CSV

    Thank you so much @JoeF-MSFT , I am going to try this and let you know soon.

  • Verified answer
    JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: How can I export data from a model to a CSV

    Hi @shadiya,

     

    Thanks for posting this question.

    For this example I have trained a Form Processing model that can extract three fields: Invoice id, Invoice date and Total.

    JoeF-MSFT_0-1616803133337.png

     

    Now I use it in a cloud flow in Power Automate and I have two options:

     

    • The first option is to use the Excel connector and save the extracted data in an Excel file like this:
      Note that you will need to create an Excel file with a table with columns that you define. 

      JoeF-MSFT_1-1616803493287.png


      I can also use Power Automate to convert that Excel file into CSV if needed as explained in this video: Microsoft Power Automate: How to convert Excel (.xlsx) to .csv files - Full Tutorial - YouTube

    • The second option is to directly create a .CSV file on a cloud flow like this. In this example I save the csv file in a folder in OneDrive:

      JoeF-MSFT_2-1616803588124.png

       

    Hope this is useful. Let us know if we can further help! 

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard