cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

2 REPLIES 2
Highlighted
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 🙂 

Highlighted
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

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

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

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

secondImage

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)