Announcements
Is it possible to filter one Combobox based upon the item selected in another combobox? I have had no luck with this. Cascade dropodowns are no problem... Can't get cascade comboboxes to work at all.
Using choice items in a list in SharePoint behind the comboboxes
Thx
Since you mentioned "Selected Item", I assume you have ComboBox controls in "Single Select" mode and your SharePoint "Choices" column is not set to allow multiple selections. If so then you can try the following:
ComboBox1.Items=Choices(SPList.ChoicesColumn)
ComboBox2.Items=Filter(Choices(SPList.ChoicesColumn), Value=ComboBox2.Selected.Value)
Hope this helps.
Do you mean this?
ComboBox2.Items=Filter(Choices(SPList.ChoicesColumn), Value=ComboBox1.Selected.Value)
Note I changed Value=ComboBox2.Selected.Value to Value=ComboBox1.Selected.Value
Will study more in the morning...
Yes. That is correct.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 477
WarrenBelz 341 Most Valuable Professional
11manish 317