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...
KatieRoxanne
Mar 05, 2023Copper Contributor
Oh 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, 2023
No 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
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.- Mar 05, 2023Yes I do all the time!
What you do it check what city User is from, so User().City (or something), then you load the data based on this, so User City = "Brisbane", Load this list with these list items. Then they get a list with items and they can update those or create new ones.- KatieRoxanneMar 05, 2023Copper Contributor
I’m currently using a patch to update the data. How do I tell the patch which list to patch the data back to?