Answered

PowerApps write to multiple excel spreadsheets

(0) Share

Report

Posted on by Toby_GS

Hi everyone,

This is my first time using PowerApps so very unfamiliar with it. I wanted to know if it was possible to write to multiple excel spreadsheets from a singular App. I know you can connect to different data sources, but can you re-write back to them?

So this is the flow that i would like to happen, when i select a name and add comments in the app, i want it to write back to the correspnding excel spread sheet.

Does this make sense?

Regards

Toby

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

LanceDelano on at

Like (0)

Report
Copy link

Link copied!

PowerApps can write to multiple data sources. Just add the second data source and then connect up your controls to the data source, in particular, that you want to update.

Was this reply helpful? Yes No
Toby_GS 4 on at

Like (0)

Report
Copy link

Link copied!

is there a video tutorial that i can use to help me understand that better?

Thanks
Toby

Was this reply helpful? Yes No
LanceDelano on at

Like (0)

Report
Copy link

Link copied!

There are a several youtube videos out there on working with multiple data sources. So, it depends on what you want to emphasize. Use this search string "working with multiple datasources in powerapps". Then, take a look for what might help you best.

Was this reply helpful? Yes No
Toby_GS 4 on at

Like (0)

Report
Copy link

Link copied!

the videos i watched showed how to draw data from multiple lists and then push data back to a masta form, but i couldn't find a video or tutorial which would write back to individual data sources.

So the ideal flow i am trying to create is this situation:
- 1 powerapp
- multiple excel files each with different names
- In powerapps select name (these names are based on the individual excel files)
- write a comment and then powerapps writes it back to the invididual excel file based on my name selection.

So as an example, i have an excel file named 'Peter', In the PowerApps, i have a drop down named 'Peter' and when i write a comment and submit, it writes into the excel file named 'Peter'. I have another excel file named 'Julie' and in the same PowerApps, i have can now select 'Julie' add a comment and it writes back to the 'Julie' excel file.

Thanks for the help.

regards
Toby

Was this reply helpful? Yes No
Verified answer

LanceDelano on at

Like (0)

Report
Copy link

Link copied!

So, in the place where you do an update of the data you can include more than one patch statement by separating them with semi-colons. So,

Patch(...) ; // here is the first patch statement to your first data source

Patch (...) // here is the second patch statement to your second data source.

You can also wrap the statements to check that the first patch was successful before you allow the second patch statment to proceed by checking the return value. This article may help with more details.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms#browse-records

Was this reply helpful? Yes No