Answered

Export data from Dataverse Power App to Excel

(1) Share

Report

Posted on by AndreaPRJ

Hello everyone.

I was trying to follow this beautiful video by Reza (https://www.youtube.com/watch?v=xurF9SY68qg) for the export to excel of data contained in a gallery of a power apps.

I implemented everything, with the only difference that the data in my case is in DATAVERSE and NOT in sharepoint.

Practically the file in excel is generated, but:

- Only the first row with column titles is generated; However, I don't see any data
- the excel file does NOT open automatically but remains created in OneDrive and that's it

- No errors in flow: I have always Success result

NB: in Dataverse cannot pass empty query when launch the flow and my query is:

     Set(varURL,ExportExpenseReportstoExcel.Run("statecode eq 0").url)

Has anyone who tried with Dataverse experienced the same issues?

ps: I have already "fixed" this part as Reza always said here (https://www.youtube.com/post/UgkxvQfTWNyuJWokAHCvM-NBazBXVnUtLJER)

Thanks in advance for your help

Regards

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @AndreaPRJ

Please share what you have, as the link to their stuff won't help.

Need to see your Expression, but more importantly need to see your Flow

1) the full flow, with inputs being used in each expression

2) a flow run, where it didn't generate what you want, so we can see the actions, what each one did, the incoming data, the output of each expression.

Please make sure to open the actions especially ont he run.

Since you said no data was created and I have no idea how the headers are, I can only assume

1) you query retrieved no data

2) you have a bug and didn't output the data correctly.

Please share yours. Heck feel free to create a Video and walk us through yours, again the most important part being the flow Run, so we can see the input and outputs of each action.

Was this reply helpful? Yes No
AndreaPRJ 64 on at

Like (0)

Report
Copy link

Link copied!

I try to describe, step by step, each step:

- Power app code:

Set(varURL,ExportExpenseReportstoExcel.Run("statecode eq 0").url)

PS: I use "statecode eq 0" because the "Reza empty string" "" does not works!

- "ExportExpenseReportstoExcel" Flow:

As I said, the flow runs regularly, without giving any error. The excel file is created in OneDrive, the first row with the column titles for the 4 fields I decided works, but the data never comes out!

Excel file:

Flow Log:

Details for "Create Table" action:

File string is for example :

"b!ioYzMCfMtESOL5UCt9Dc1PRdfAV8pihIqffTyQiFemIKXi-AT1DsSobY5TUaWIEU.01R4X2HGR4PPZJAZ47SZAL5LNBP7DUN77E"

Details for "Select" action: (all ok)

Details for final "Send HTTP Request" action:

URI String is:

"https://graph.microsoft.com/v1.0/me/drive/items/01R4X2HGR4PPZJAZ47SZAL5LNBP7DUN77E/workbook/tables/WorkProgressTable"

Thank you very much

Was this reply helpful? Yes No
Verified answer

AndreaPRJ 64 on at

Like (0)

Report
Copy link

Link copied!

I realized that I had forgotten the string "/rows" in the action below ....

Now it works!

Thanks anyway for the answer

Was this reply helpful? Yes No