Lookup values from a variable table column

(0) Share

Report

Posted on by drossi90

188

Hello,

I have a variable (varFPB) and a table (Quotes).

I want to lookup Quotes for ids from the varFPB var.

So for example, if I have ids LH123, LH124, LH125 in the varFPB table, I want to then lookup the Quotes table with those ids to check if they're there.

I've tried a few things but can't seem to get it to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @drossi90,

Could you please tell me that how you generate this variable? Show me your formula.

I assume that the variable is a table including a id column, then if you want to check if the Quotes table inclused the ids from the variable, please add a Gallery and set Items property as below:

Filter(Quotes,ID_in_Quotes in ID_in_varFPB.varFPB)

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @v-qiaqi-msft

the variable is populated through
UpdateContext({varFPBJobs: Filter(dan.SearchJobsProd("218","QUOTE_ACCEPTED","application/json","XXX","XXX"),TradeId = 6, "fixed-price" in quoteDescription)});

Correct, the variable is then populated with a load if information, id being one of the columns.

I tried your formula but it says it isn't recognised.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @drossi90,

The error suggests that you have referred to a invalid column name maybe, show me how you write the formula.

You should replace the field name with the real one in your data source.

Eg, I have ID in Quotes table, and I have id in column in variable varFPB

Filter(Quotes,ID in varFBP.id)

Was this reply helpful? Yes No