cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
leizhaoyn
Level: Powered On

Multiple value Choice column delegation workarounds?

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.

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Level 10

Re: Multiple value Choice column delegation workarounds?

Hi @leizhaoyn 

 

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

4 REPLIES 4
RezaDorrani
Level 10

Re: Multiple value Choice column delegation workarounds?

Hi @leizhaoyn 

 

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

 

 

 

 

 

 

 

 

leizhaoyn
Level: Powered On

Re: Multiple value Choice column delegation workarounds?

@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.

RezaDorrani
Level 10

Re: Multiple value Choice column delegation workarounds?

Hi @leizhaoyn 

 

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
Level 10

Re: Multiple value Choice column delegation workarounds?

Hi @leizhaoyn 

 

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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 83 members 4,606 guests
Please welcome our newest community members: