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

[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

[Vikas_Sharma]

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

[Lsmits]

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?

[Lsmits · Accepted solution]

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')

[v-LilyW-msft]

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.