web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple value Choice ...
Power Apps
Answered

Multiple value Choice column delegation workarounds?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a PA that pulls from a document library in Sharepoint which has 3700 records and is growing. The entry point to this app is a selector that allows the user to choose a "Distribution Center" to pull relevant records for. This is a Choice type column that allows multiple options. Converting this to text and then doing a string comparison vs. the user input results in delegation warnings. From what I can tell, you also can't create a calculated column on the list itself that would convert the value in this column to a single line of text because it's a Choice column that allows multiple options.

 

I've seen possible solutions using Sharepoint REST API with a Flow, which seems like a lot of effort, or trying to pull in batches of records to get the entire contents of the document library but I understand the latter is not best practice. I've also considered splitting the document library up into separate lists for each "Distribution Center" since you're still not able to base a Powerapps view on a Sharepoint List View as another option. I'm actually leaning towards this solution, but wanted to check in here before I did so. Happy to follow up with code, screenshots, etc. if anyone thinks they can help out.

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @Anonymous 

     

    There is a trick way to achieve this

     

    First create a flexible height gallery (this will be a must) since we will hide all elements within gallery template when a condition is met

     

    Once you design the gallery template, group all elements

     

    Next lets assue you want to filter your gallery elements by the mutli choice field

     

    The gallery items property will be your data source - no filtering here

    why because - the moment you add filtering on muli choice field - it will throw delegation warning

     

    Next in your gallery elements, make sure you have 1 field showcasing the multi choice fields selected

    example :- this can be a text field - and you can set its text property to

    Concat(ThisItem.MultiChoiceField,Value &";")

    Lets say this is added to a label called LabelMultiChoice

    This will show all values semi colon seperated

     

    Next set the visibility on the grouped elements of the gallery

     

    Visible set to

    "filter value" in LabelMultiChoice.Text

    where filter value can be replaced by what you want to search

     

    So basically gallery will continue to function as is, but will hide the multie line choice rows when the criteria does not match

     

    Let me know what you think

    You might have just given me my next blog idea

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

     

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @RezaDorrani , do you have a demo version of this working? When I try to follow your steps, I still can only load 100 records from my document library at a time. I also don't think I'm setting the Visible property correctly.

  • Verified answer
    RezaDorrani Profile Picture
    12,145 on at

    Hi @Anonymous 

     

    I plan to add this to my video blogs this weekend

    https://www.youtube.com/channel/UCvBYTqRx-n_8KzFO0MJlUVw?view_as=subscriber

    Subscribe to my channel

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • RezaDorrani Profile Picture
    12,145 on at

    Hi @Anonymous 

     

    As promised, here it is

    https://www.youtube.com/watch?v=44j2VRbdWjk

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 528

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard