Filter combobox based on Choice column Value(s) in dataverse table

(0) Share

Report

Posted on by ctedesco3307

621

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!!

Categories:

Connecting to Data

All responses (6)

Answers (1)

Verified answer

ctedesco3307 621 on at

Like (1)

Report

Re: Filter combobox based on Choice column Value(s) in dataverse table

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
ctedesco3307 621 on at

Like (0)

Report

Re: Filter combobox based on Choice column Value(s) in dataverse table

@ShaheerAhmad Please see my reply to @v-zhoqian-msft
ctedesco3307 621 on at

Like (0)

Report

Re: Filter combobox based on Choice column Value(s) in dataverse table

@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
Shaheer Ahmad 2,194 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter combobox based on Choice column Value(s) in dataverse table

Agree with the approach
v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Re: Filter combobox based on Choice column Value(s) in dataverse table

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.
ctedesco3307 621 on at

Like (0)

Report

Re: Filter combobox based on Choice column Value(s) in dataverse table

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