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
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 🙂
Thank you for showing your solution, it helped me, I have been trying to solve this for some time.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
171 | |
61 | |
32 | |
32 |
User | Count |
---|---|
336 | |
270 | |
104 | |
71 | |
56 |