Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Create a Form using data from 2 excel tables


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

Super User
Super User

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

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?

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

Also read this post if it can help:

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

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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