Answered

How can I export data from a model to a CSV

(0) Share

Report

Posted on by shadiya

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:

AI Builder

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

JoeF-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

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.

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:

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

Was this reply helpful? Yes No
shadiya 45 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
shadiya 45 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No