web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Load Specific List Rec...

Power Apps

Unanswered

Load Specific List Record on Form Load using separate List as a lookup

(0) Share

Report

Report

Posted on by doctorscience

15

So I have a list populating a form within a canvas power app, and looking to load a specific record based on a lookup from a separate list.

I have the primary table in this format

Title | Text Input 1 | Text Input 1 | Text Input x ....

Org1 | [BLANK] | [BLANK] | [BLANK] | ...

Org2 | [BLANK] | [BLANK] | [BLANK] | ...

Org3 | [BLANK] | [BLANK] | [BLANK] | ...

I also have a second lookup table with a list of users matched to Org

Title | Email

Org1 | email1@email.com

Org2 | email2@email.com

Org3 | email3@email.com

What I'm looking to do, is use the email of the user accessing the form, and lookup the org they match with from the second lookup table, and use that to pull the matching record from the primary table. The primary table is set to only have one entry per org.

How is best to do this, have tried using set and lookup for the item property of the form but can't seem to get it working.

Any advice would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @doctorscience ,

The record should be

With( { _Org: LookUp( Table2, Email = User().Email ) }, LookUp( Table1, Title = _Org.Title ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation