Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Multiple Items selection Cascading drop-down - Not working

I have two issues 

Issues 1: I have cascading drop down with name Project code and project name. I have used combox for both so that i can select multiple items. problem here is, if i select one items in project code, project name combo box shows the items but when i select multiple items in project code. Project name combo does not shows items for both multiple selecected items.


Issues Two: It is not updating multiple items in sharepoint. only one last selected items get updated in the SP list.

formula i have used are: project code

Items: Code.Activeprojectcode
update: ComboProjectCode.Selected.Activeprojectcode

Project Name

Items: Distinct(Filter(Code,Title=ComboProjectCode.Selected.Activeprojectcode),Projectname)
update: ComboProjectName.Selected.Result 

Any suggestion would be great

Helper II
Helper II

Re: Multiple Items selection Cascading drop-down - Not working

Regarding Update: I solved it using concat

for other who too facing same:

Concat(ComboBox3.SelectedItems,Projectname&"; ")

but for multi selected cascading i am still struggling. I tried to use collection but not getting result as expected.

I do able to add the selected value to the collection using clearcollect but if i deselect any value i could not get the logic to update collection..  seems like this kind of request solution is tough for all 🙂 

Frequent Visitor

Re: Multiple Items selection Cascading drop-down - Not working

Thank you for showing your solution, it helped me, I have been trying to solve this for some time.

Helpful resources

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Super Users Coming in August

We are excited for the next Super User season.


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,252)