Announcements
Short story is my app has a combo box that references a Dataverse table in Items
I want to filter the Items based on another combo box selected items that matches to a choice list column on this table. How Do I write the syntax for the choice column? This below can't compare Table to Text. The choice column also includes multiple values
Thanks in Advance!!
I got this far to get rid of the error message but I still can't get any results.
Additionally - Platform is the choice column I'm searching on but the column I want to return in Specification is Materials
Hi @ctedesco3307 ,
You could set the OnChange property of cmbplatform to
ClearCollect(coll,cmbplatform.SelectedItems)
Then use coll as the data source of combo box2.
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
Agree with the approach
@v-zhoqian-msft Thank you for the info, however - I don't want the platform values to be in ComboBox2. I want Materials to be in ComboBox2. The Materials I want to show, are filtered by the Platform values selected in cmbplatform
@ShaheerAhmad Please see my reply to @v-zhoqian-msft
Filter(WIRS_PMaterials,cmbplatform.Selected.Platform in Concat(Platform,Value))
cmbplatform.Selected.Platform is the combobox I am filtering from
Concat(Platform,Value) is Platform is the GlobalChoice column in WIRS_PMaterial
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1
