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

(0) Share

Report

Posted on by ctedesco3307

690

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

ctedesco3307 690 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report

Agree with the approach

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

@ShaheerAhmad Please see my reply to @v-zhoqian-msft

Was this reply helpful? Yes No
Verified answer

ctedesco3307 690 on at

Like (1)

Report

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

Was this reply helpful? Yes No