Answered

Exporting data from multiple tables to Excel

(0) Share

Report

Posted on by jacob_brennan

I have a Power App that fills data into multiple Data verse tables. A requirement of the user of the app is to have an excel spreadsheet that shows all of this data.

Being fairly new to Data verse, the only method I can think of to provide this is to store all of this data in a SharePoint site, which would let me generate an excel file that has a connection to the site.

Is there a better method that wouldn't require me to store the data in a different site (possibly using Power Automate)?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Hi @jacob_brennan ,

I could say, that depends. Could you please share more details? How many tables are there and what fields do they have? What's the structure of the excel table the user would like to have?

One easy way I think could be update an excel table in SP library with the data filled into Dataverse tables in a meantime. The excel table would be treated just like another Dataverse table that includes all data in other tables.

You could use Power Automate as well:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#add-a-row-into-a-table

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
jacob_brennan 6 on at

Like (0)

Report

Thanks for your help, I tried this and it worked

Was this reply helpful? Yes No