cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Create a Form using data from 2 excel tables

Hello

How can I edit a single form, pulling data from 2 excel tables as its datasources  and then saving the new data to a 3rd Excel Table?

Can anyone point me in the right direction,  possibly using collections?

Thanks in advance

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: Create a Form using data from 2 excel tables

If the objective is to join the data and send to another table the use two forms. Am wondering why you want to use a single form for two tables

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution
Highlighted
Post Patron
Post Patron

Re: Create a Form using data from 2 excel tables

Hi @ eka24
Thanks for your reply. I want to use a single gallery to reference a form ( with editable fields from a different data source). I saw a video where a dropdown control was replaced by one from a different data source , but I would like to replace text input controls in the form. What is the easiest way to do this? Is it possible to split the form in 2 parts on the same screen?
Thanks
Highlighted
Super User III
Super User III

Re: Create a Form using data from 2 excel tables

You can have two forms on a screen. Using a Toggle control make visible at any point in time.
If you want to use two tables for one gallery, it can be done with switch or if functions. But the same fields should be in both tables otherwise you have to work extra
Highlighted
Super User III
Super User III

Re: Create a Form using data from 2 excel tables

Also read this post if it can help:
https://powerusers.microsoft.com/t5/Building-Power-Apps/1-form-for-multiple-datasources/m-p/320072

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,699)