Forum Discussion
Preventing users from seeing list items worldwide context
If users have access to the list, then they have access to the whole list. There are ways to use views on pages to make it difficult for people to see the rest of the list, but it cannot be prevented.
Even if you use Power Apps to control what they see in the form, that's still just fancy smoke and mirrors. It won't prevent users from going to the list to see what they want.
If you must have TRUE access control where you can guarantee that people do not see content from other countries, the only way to do that is to use separate lists with separate permissions.
But the list maintenance shouldn't be that hard if you use site columns and a content type. This will allow you to manage the columns and values from a central location. Add a new value to the site column and it will populate all the lists using that column. Add a new column to the content type and it will populate all the lists using that content type.
Analytics are easy if you use Power BI. Add the site as a data source and select all the lists that apply. Since they should have all the same columns and values, it should be pretty easy to set up a dashboard. You can then use row level security in PBI to control who sees which info in the dashboard.