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.
Solved! Go to Solution.
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
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
@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.
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
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
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
265 | |
209 | |
77 | |
41 | |
33 |
User | Count |
---|---|
344 | |
217 | |
117 | |
71 | |
54 |