Hi
I have 2 tables in dataverse that i am currently working to implement a cascading lookup
'Work categories' and 'Work'
Table 'Work' has a lookup column from table 'Work categories' named Category.
Then i have a gallery.
In gallery i have 2 comboboxes. one is Work category another is Work. I want to make so when user selects a Work category so the combobox lists only these work items that are asociated with this work category.
What i did is in the Work categories combobox in Items property i put formula:
Distinct('Work categories','Category'). I selected field Result and it shows me correct result
on combobox work in Items property i put formula:
Distinct(
Filter(
Work,
'Category'=ComboBoxDarbuGrupe.Selected.Result
),
'Work name'
)
This formula gives me an error"Incopatable types of comparison.These types can't be compared: Record,Text.
I guess this is due to Category being a lookup column. How do i write this formula correctly?
