Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Powerapps Filter on Sharepoint Choice Column (Multiselect)

Posted on by 408

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:
  • vandam2 Profile Picture
    vandam2 408 on at
    Re: Powerapps Filter on Sharepoint Choice Column (Multiselect)

    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 

  • vandam2 Profile Picture
    vandam2 408 on at
    Re: Powerapps Filter on Sharepoint Choice Column (Multiselect)

    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 

  • TheRobRush Profile Picture
    TheRobRush 11,148 on at
    Re: Powerapps Filter on Sharepoint Choice Column (Multiselect)

    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

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.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,685

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard