Answered

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

(0) Share

Report

Posted on by 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/td-p/45498 , 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
arunsaraswat123 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
tddttran 62 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No