Answered

Filter by comparing a Lookup field to a text field in two different Dataverse tables

(0) Share

Report

Posted on by Lsmits

Hello, I am trying to create a nested gallery, where the first gallery displays the Categories and depending on the category selected it should go to a gallery that contains the Awards that fall within that category. for the filter on the second gallery (Awards gallery), I am trying to compare two different fields in two different tables in Dataverse. Table 1 is called Kudos Category, Table 2 is called Kudos Award. Kudos Award table has a lookup field called 'Kudos Category' that gets the category from the Kudos Category table, field name: 'Kudos Category Name' (which is a text input).

I have tried:

Filter('Kudos Category'= galKudosCategories.Selected.'Kudos Category Name')

Filter('Kudos Category'.Value = galKudosCategories.Selected.'Kudos Category Name'.Value)

and neither of them work

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Vikas_Sharma 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Lsmits
Please check the syntax of the filter function because It should contain the database name first and then the condition.
In your filter syntax you have not used the database name please add that and then check.
Hope this will work.

Thanks, Regards

Was this reply helpful? Yes No
Lsmits 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Vikas,

yes apologies, it does and it still doesn't work:

Filter('Kudos Awards', 'Kudos Category'= galKudosCategories.Selected.'Kudos Category Name')
Filter('Kudos Awards', 'Kudos Category'.Value = galKudosCategories.Selected.'Kudos Category Name'.Value)

any suggestions?

Was this reply helpful? Yes No
Verified answer

Lsmits 9 on at

Like (0)

Report
Copy link

Link copied!

I figured it out!

Because the 'Kudos Category' is a lookup column from Dataverse you need to reference the lookupcolumn.columnameitislookingupfrom eg.

Filter('Kudos Awards', 'Kudos Category'.'Kudos Category Name' = galKudosCategories.Selected.'Kudos Category Name')

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Lsmits

Thanks for your posting here and sharing the solution in the forum as it would be helpful to anyone who encounters similar issues. Please accept your reply as an solution to mark the post as solved so that this thread will be marked for other users to easily identify!

Best Regards.

Was this reply helpful? Yes No