Change Excelfile with Flow

[EliasGrabh]

Hey There - I have a Question. 
I create an Powerapp, to safe data to an excel file. I need to safe it in 10 different places, but the Excel table always looks the same, but is in different folders, with unique information each. 
The user needs to make a decision in the beginning, where he can choose between the 10 places to safe. 
My question now is, if there is any chance to just make one edit screen, one browse screen, and one detail screen?
and the data gets saved, depending on the decision made before?
Or do I really need to do a screen for each place and in the end I have like 30 screens?
Thanks alot.

[WarrenBelz]

Hi @EliasGrabh ,

Firstly you would need to connect all (10) data sources.

You could the use a conditional Patch command to send the data to whatever list you need to or a conditional DataSource property on a form and use SubmitForm.

A bit of logic involved, but in answer to your question, yes it is possible.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[EliasGrabh]

Thanks @WarrenBelz,
for the quick answer.

Yeah I work with the SubmitForm and autoCreated form if I press "start from Excel Data"

Do you got anything where you can referr me to? So I can try that?
Thanks alot!

[EliasGrabh]

Or is there any way to get the 3 screens, that get created if i press "start from excel data" more then once? then I could repeat that for like 10 times  and i would have it too... 
Thanks alot

[WarrenBelz · Accepted solution]

@EliasGrabh ,

You should need to decide the data source before the form is presented  (Screen OnVisible is good) - Basic logic -

If(
   ConditionA,
   TableA,
   ConditionB,
   TableB,
   ConditionC,
   TableC,
)

They have to be the same field names and types, but if displayed, SubmitForm() will work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[EliasGrabh]

thanks alot!