cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

@Anonymous ,

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
WarrenBelz
Super User
Super User

Hi @Anonymous ,

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.

 

 

Anonymous
Not applicable

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!

Anonymous
Not applicable

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

@Anonymous ,

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.

 

  

Anonymous
Not applicable

thanks alot!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,756)