Solved: Multiple value Choice column delegation workaround...

leizhaoyn · ‎08-16-2019

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.

RezaDorrani · ‎08-19-2019

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

View solution in original post

RezaDorrani · ‎08-16-2019

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 · ‎08-19-2019

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