Hello
I am developing a Site Diary system
Site Diary Entries are linked to a specific site my Site sharepoint list
Security is defined at the site level
When a user adds a site diary entry attached to the London site for example, how can I ensure that this entry is linked to London, i.e. its not visible to anyone who doesnt have access to the London site?
There is an implied link, but it is not secure enough because although I can restrict visibility of Site Diary Entries in the app to only those associated with sites the user has access to, it wont prevent a user from seeing diary entries they are not allowed to see, just by looking at the Site Diary Entries list directly in Sharepoint
Would this involve using Flow/Power Automate?
Paul
I had a similar use case, and yes - Power Automate can be used. Use the "PowerApps v2" trigger with some kind of service account/superuser. Once you finish the flow, click on the "Run only" section to ensure the connectors are used by the service account. This way, a regular user could trigger the flow in a button (or OnSuccess in PowerApps), and the flow can update the list item security, including looking into other lists that the user cannot access. This method allows "Guest" users to use flows, as well.
HTH!
Steve in Spain
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2