Create a Form using data from 2 excel tables

[Englishweb]

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

[eka24]

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

[Englishweb]

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

[eka24]

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

[eka24]

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