Unanswered

Automated Data Export to Excel or CSV Question

(0) Share

Report

Posted on by IT346

I have a simple canvas power app that I would like to be able to have power automate automatically pull the data from dataverse and place the export file in sharepoint or one drive. Has anyone had success with this?

I've been able to get the list rows and a simple one column exported but not much else so far.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ArchitectMadhan 1,584 on at

Like (1)

Report

Hi @IT346 ,

In your case you need to get the data from dataverse using the get records (Dataverse) action, Create excel file action should be used to fill in the data and upload the excel file to SharePoint.

Ref: https://www.youtube.com/watch?v=D2_WCvelCHo

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Create-Excel-Workbook-in-SharePoint-from-Power-Automate-Flow/ba-p/1219394

Was this reply helpful? Yes No
IT346 5 on at

Like (0)

Report

Thank you. I went a minor different approach and created a CSV table to get to the data.

Was this reply helpful? Yes No