Announcements
Using a SharePoint multiselect, if I don't filter it the Update works using the default DropDownList.SelectedItems. When I filter the list, the update doesn't work. Why doesn't the update just work using DropDownList.SelectedItems?
Pls elaborate with codes used
I have a Courses table with 2 dropdowns - Audience and Program (multi value)
The Program dropdown items is dependent on the Audience so I filtered it.
Filter(LibPrograms, Audience.Value = ddlAudience.Selected.Value).ProgramName
This filter works but the update should go to the Courses table but doesn't.
Please share the columns name and code how you are updating?.
And are you facing any error?
lookup table: LibPrograms
- field: Audience
- field: Program
data should update in this table
table: Courses
field: Audience
field: ProgramName - dropdown: ddlPrograms
Update = ddlPrograms.SelectedItems
There are no errors but the datasource should be the Courses table right?
thank you for any assistance.
I got it to work. Sorry I'm a newbie to Powerapps. I used Filter and Choices like this:
Filter(Choices([@Courses].Program),
Value in Filter(LibPrograms, Audience.Value = ddlAudience.Selected. Value).ProgramName)
Thank you for assisting!
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 474
WarrenBelz 375 Most Valuable Professional