Answered

Export An Excel file using PowerApps and Flow ingesting data from SharePoint List (updating the Excel File)

(0) Share

Report

Posted on by Keyner Microsoft Employee

Hello team.

I am developing an app in PowerApps, to manage different trackers on my organization to manage inputs from my end users in all the trackers, all my data source is from SharePoint Lists, If I send some inputs to the SharePoint Lists, everything is working fine, I can´t configure that, ingest all these data to an Excel file and this Excel file needs to be updated every time an end user sends a new input to the SharePoint List:

These are all my SharePoint List.

This is my app:

Is a simple app to navigate between different screens pressing every button on the main screen and sending inputs just pressing the button send action.

I haven´t achieved that all my inputs to the SharePoint lists be exported to an Excel File and this excel in OneDrive be updated every time an user sends an input.

This is my code on every Sends Button,

SubmitForm(IntakeForm); Notify("Enviado con éxito", NotificationType.Success); ResetForm(IntakeForm); Notify("Ingrese Nuevo Dato", NotificationType.Information) I am submitting a new Form showing up a notification and resetting the data source to input a new input.

Every Tracker has different number of columns and different columns name.

All the buttons are working fine just have the problem generating the Excel file with every input that my end users make.

These are the results.

I appreciate your help on that.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Keyner ,

You mention you have a problem generating the Excel file, but how is it supposed to be generating? Nothing of what you shared shows anything that may be supporting such a functionality.

Was this reply helpful? Yes No
Keyner Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer Hello Sir.

Thanks for your comments, sorry for the misunderstanding, I want to generate the excel once the user press on the button send in Power apps, connect the power apps with power automate, right now I have a flow but with a manual trigger the excel is being generated but the data is something weird.
And I check the Excel file and the table generated the data is being saved but is copying the same values in the table is not adding the new inputs.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Keyner ,

Try removing the Select action and the Apply to each loop:

Before you remove the "Apply to each" loop, make sure to move the "Apply to each 2" loop out of it.

Quick tip: Instead of using the "Agent" dynamic content to populate the Excel table row, use something like "Agent Email" to get a more readable output. The same goes for "Team" and "Team Value".

Was this reply helpful? Yes No
Keyner Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I did it sir.
The data was sent to the Excel table, perfectly, but every time I run the flow the data is not being updated and the same data is being sent to the table every time I run the flow, can we do that just the new values be sent to the table?
Is possible to do this action scheduled with a automatic flow or using the app designed in Power apps every time I press the Send Button?

Thanks in advanced.

Was this reply helpful? Yes No
Keyner Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I found a solution about it.
Is sending the new items, because I created a new column in the SPO list named Status with 1 option "New" I want that if this value is found, the Flow does not send it again to the Excel table.
I need a kind of validator to prevent that the same inputs be sent to the Excel table if the entry exist.

I need a help on that.
I made a test.
I sent 1 input and the same input was sent to Excel 3 times.

Was this reply helpful? Yes No