Combo Box in Gallery thats Items are Distinct

[cmalm]

I have a gallery thats items are grouped using the distinct function for values of a lookup field in a sharepoint list. 

I have a combo box that I'd like to display a text field from the parent table of the above lookup field.

I need to know what to enter into the properties (Items, DisplayFields, & DefaultSelectedItems) of the combo box to display the above mentioned text field.

I'm lost. Please help!!!

[cmalm]

The solution is:

Filter(parent_table, child_table_pk = ThisItem.Result)

Can anyone tell me the code for a label's text field as the above doesn't work?

[cmalm · Accepted solution]

Oops. It is

Filter(parent_table, parent_table_pk = ThisItem.Result)

[alrez]

Hi,

It looks like you were able to figure out the issue that you were having. I wanted to add a little more information if you would like to learn more, please take a look.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.