How to Filter lookup field CDS

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I think this is not that difficult but I am having trouble filtering my gallery.

My data all is CDS.

I would like to filter my gallery like the following.

I’ve tried this but not working.

Filter(tabelname, TextSearchBox1.Text in fieldname(lookup).'name')
Filter(tabelname, TextSearchBox1.Text in table_b.'name')

'name' is a field in Related table(tabelname: table_b)

Any help is appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,

Try doing something like
Filter(tabelname,IsMatch(fieldname(lookup).'name',TextSearchBox1.Text))

Regards,
------------------------------------------------------------------------------
If this helped you, please consider giving it kudos and accept it as a solution. Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

thank you for your help!
I am still having errors.
Would you please check this?
I've tried two way.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Actually my bad, Please forgive me.
You can't filter a field from a related table, what you need to do and to minimize the lookup calls is :
Collect your table1 in a collection like so (ClearCollect, varTable1, table1);
Collect table2 (related table) : ClearClollect(varTable2,table2);
ClearCollect(varFinalTable,AddColumns(varTable1,"Name", LookUp(varTable2,name = varTable1[@fieldname(lookup)]).Name));
For the gallery Items you use (Filter(varFinalTable,IsMatch(Name,TextSearchBox1.Text))
You need to understand delegation, and work your way to update your rows or create elements in database (using Patch etc ).

Regards,
------------------------------------------------------------------------------
If this helped you, please consider giving it kudos and accept it as a solution. Thanks

Was this reply helpful? Yes No