Filter a Dataverse Lookup column using a combo box and display its related values from another lookup column in the same table.

(0) Share

Report

Posted on by MarkBaker

I have a dataverse table named Site Items with 2 columns, Item and Material Site.

Item is a lookup and points to Name column in the table named Items .

Material Site is also a lookup that points to Name in the table named Material Sites .

I have a combo box named cmbItem who's data source is Items with primary text set to Name that when selected I want another combobox named cmbSite to display every Material Site Name from Site Items when the records value in the Item column is equal to what is selected in cmbItem.

Screenshot 2023-02-28 170556.png

I played around with Filter(Choices( but im lost. I also see i might need to use something like [@'Site Items'].'Material Site' ?

thanks for the help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

SolTeferi on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MarkBaker ,

Please try the following:
Filter('Site Items',Item.Item=cmbItem.Selected.Item)
You may want to set the display value of your cmbsite combobox to the desired column.

Was this reply helpful? Yes No
MarkBaker 45 on at

Like
a
(0)

Report
Copy link

Link copied!
I got that far before using:
Filter('Site Items',Item.Name=cmbItem.Selected.Name)
But I can't choose the lookup column Material Site for the other combo box's primary text field. its missing from the dropdown list.

thanks

Was this reply helpful? Yes No
Verified answer

SolTeferi on at

Like
a
(2)

Report
Copy link

Link copied!
You are right @MarkBaker .

It looks like you want to change it a little bit. Please try this one below:
ForAll(Filter('Site Items',Item.Item=cmbItem.Selected.Item), 'Material Site'.Name)
Please make sure you use the right 'Material Site' if you select from intel sense. Hope this one will help.

Was this reply helpful? Yes No
MarkBaker 45 on at

Like
a
(0)

Report
Copy link

Link copied!
That worked. I just had to change to this:
ForAll(Filter('Site Items',Item.Name=cmbItem.Selected.Name), 'Material Site'.Name)

Thanks

Was this reply helpful? Yes No
SolTeferi on at

Like
a
(1)

Report
Copy link

Link copied!

Awesome! Thank you much, @MarkBaker , for confirming.

Was this reply helpful? Yes No