LookUp and filter to two database

(0) Share

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 (1)

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