web

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

News and Announcements icon

Power Platform CommunityForums Power Apps LookUp and filter to t...

Power Apps

Answered

LookUp and filter to two database

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hey, I have a problem because I want to look up data from two tables in a database. For now, I search for data in one using the item number, here is an example:

LookUp(Filter(TABLE,DATAAREAID="abb"),ITEMID = DataCardValue3.Text ,NAME)

Now I would like to get data from another table called VTABLE and after the id in that table, find in TABLE the id referring to the ID in the VTABLE table and extract the data from the PERSON column

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I solved my problem in such a way that first I download some data to the label, and then in another window I look for data based on this label.
Now i have problem with label.text , when i try to reference inside label i get an error:
Or another question, can I combine these two formulas into one?

LookUp(Filter(TABLE,DATAAREAID="aab"),ITEM = DataCardValue3.Text ,VID) // this is in Label2 , DataCardValue3 = item number and LookUp(Filter(VTABLE,DATAAREAID="aab"),ACCOUNTN = Label2.Text ,NAME)

Solution:
LookUp(Filter(VTABLE, DATAAREAID="aab"), NUM = LookUp(Filter(TABLE,DATAAREAID="aab"),ID = DataCardValue3.Text ,VID), NAME)

Was this reply helpful? Yes No

Join the conversation