App with Multiple tables that connect to one display/edit form

[zdieter]

Hello,

I am creating an app that multiple managers will use so they can edit there employees information (Ex: name, office, email, etc). I had made a collections like so 

Set(CurrentUser,User());
ClearCollect(TableCollection,
         Table({ManagerEmail:"ManagerAEmail@company.com",Table0:Table1},
                {ManagerEmail:"ManagerB@company.com",Table0:Table2}))

 I then set a gallery (Gallery1) to lookup the manager with

Lookup(TableCollection, ManagerEmail=CurrentUser.Email, Table0)

The problem is this cannot be connected to an edit/display form as I have now been informed. However, there is a work around https://powerusers.microsoft.com/t5/General-Discussion/Binding-Collection-to-EditForm-is-not-working... , but I do not know how to use in my situation because I have multiple tables connected. Can someone help me us this work around or have another approach to this app? 

[v-xida-msft · Accepted solution]

Hi @zdieter,

Do you want to connect multiple tables to single one Edit/Display form within your app?

If you want to connect multiple tables to single one Edit/Display form within your app, I afraid that there is no way to achieve your needs in PowerApps currently. One Edit/Display form could only be connected to one data source.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Kris

[arunsaraswat123]

HI,

I want to create one power app. Using multiple table to save data on basis of some condition. If condition 1 gets true then data save in table 1 and if condition false then data save in table 2.

and also need to send mail on successful save.

Please help and suggest is this possible or not.

[tddttran]

If it was me I would not make a condition to put them in separate tables, I could add a column to indicate which set of data it is.