cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Change Excelfile with Flow

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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.

 

  

View solution in original post

5 REPLIES 5
Super User III
Super User III

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.

 

 

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!

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

@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.

 

  

View solution in original post

thanks alot!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (64,555)