Answered

Filtering combo box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Please help. I am struggling with the formula for several hours. I have very little experience.

I have a Sharepoint list by the name "Workplace Certification Program Pathways' with several columns but i am currently interested in only 2: Title(Single Line Text column) and Exam Path.

I have a combo box with all Exam Paths populated. My requirement is to populate those titles (in another combo box) where Exam Path matches with the selected one in the first combo box.

I am able to bind all titles with the below formula.

Distinct('Workplace Certification Program Pathways','Title')

But, when I change the items property to below filter it always gives me an error, "Invalid argument type". Please let me know what am i missing here.

Filter('Workplace Certification Program Pathways','Exam Path'=ComboBox1.Selected.Value)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Filter('Workplace Certification Program Pathways','Exam Path'=ComboBox1.Selected.Result)

Distinct() produces a single column table with the column name "Result"

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
Sorry, I did not understand what has to be fixed. My 'Exam Path' column is of type Choice on the list. I need combo box 2 to show only the titles for the exam path selected.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to populate the Combo Box based on another Combo Box selected 'Exam Path'?

Could you please share a bit more about the scenario?

I think the key is the argument type, for the Choice column, you should refer to the Column.Value.

Please modify your formula as below:

Filter('Workplace Certification Program Pathways','Exam Path'.Value=ComboBox1.Selected.Value)

Or

Filter('Workplace Certification Program Pathways','Exam Path'.Value=ComboBox1.Selected.Value).Title

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No