Powerapps Filter on Sharepoint Choice Column (Multiselect)

(0) Share

Report

Posted on by vandam2

Trying to filter gallery with multiple Choice Columns, but cant get any to work

Sharepoint Group

Name: Group
Type: Choice Column
Display choices: Allow Multiple selections

PowerApps Dropdown

Choice column (hardcoded values because when i try to use the Choices() function, it cannot find the column
Filter - when i try to filter based on the group field, inellisense will not show any options, everywhere i look online it says for the choice column the filter for Group.SelectedItems, but Selected items doenst come up as option (i dont get any options)

added screenshots for reference, ideally i would like the dropdown items to use the Choices () function on the sharepoint Group choice field, and then use that to filter.

thanks in advance

Categories:

Building Power Apps

Choice Column ima...

I have the same question (0)

All responses (3)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Just to show you how it works, did one on one of my splists. I never filter by this column though really as I do not think it is delegable.

Sort(Filter(WorkOrders, "Booth 1" in Area.Value),RequestDate,Descending)

in this example the gallery shows me only work orders that have Booth 1 as a selected option in their Area column (this is a choice column)

Reza came up with a workaround if you need delegable version I haven't tested it but linked video for you

1 people found this reply helpful.

Was this reply helpful? Yes No
vandam2 on at

Like (0)

Report

thanks, but the one issue i think i have is that for some reason powerapps isnt recognizing (intellesense) the value or the selectedvalue option of that field...like why cant i do a Choices() formula on the choice column (multiselect), it works on a single select choice column, i will check out this video

Was this reply helpful? Yes No
vandam2 on at

Like (1)

Report

thanks for that Video link, it did help alot, got the filter working

Filter(
'IAS Project Tracker',
IsBlank(cbZone.Selected.Value) || IsEmpty(cbZone.Selected.Value) ||cbZone.Selected.Value in Zones.Value

Thank you for your help

Was this reply helpful? Yes No