Forum Discussion
KatieRoxanne
Mar 04, 2023Copper Contributor
Setting Multiple Item Level Permissions /Dynamically choosing different Sharepoint Lists - PowerApps
Dear all - I really hope someone may be able to help me. I have a list of values (>80,000) in a Sharepoint lsit and each value relates to a city (100 cities total). How can I quickly given ac...
Mar 04, 2023
So it might be easier to you to split this to several lists, as querying large list and filtering large list isn't the PoweAapps. Limit is about 2000 items and then you need to start looping through etc.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview#changing-the-limit
So the easiest way might be to load the list using the Data from their AD or that user chooses data source to load when selecting the dropdown.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview#changing-the-limit
So the easiest way might be to load the list using the Data from their AD or that user chooses data source to load when selecting the dropdown.
- KatieRoxanneMar 05, 2023Copper ContributorOh wow - I had no idea about this limit. This has certainly made me rethink the way I structure my data. Thanks for the reply.
- Mar 05, 2023No worries!
My approch would be that I would load data source based on users location from the AD. So onstart or onclick on the start page , it would load everything for brisbane or whole of Aussie land for example- KatieRoxanneMar 05, 2023Copper ContributorThanks for the response.
Do you use PowerApps at all? I ask as I can't think of a way for the user to update data in PowerApps and patch the data back to the right list.