Hi All,
I have a SharePoint list that I need to share with a lot of people in my organization and they are only supposed to interact with it through Power Apps (hence the need to share). The app contains all of the business logic and should therefore not be bypassed. I have already blocked the SharePoint UI as much as possible so that can't be used, but I have observed that people are still able to create items outside of the app. I suspect they are using Power Automate to do this.
My question is therefore: Is it possible to prevent users from using Power Automate to making changes in a SharePoint list that has been shared with them whilst they can still access it through Power Apps?
I agree that you'll need to do that. But I would still recommend doing something proactive instead of just reactive. Don't assume that users won't comply if the situation is explained to them. All that really needs to be said is to explain that only going through the Power App will apply the business rules required. That should drastically cut down on the number of times you need to apply the reactive fix.
Hi @Pstork1,
I think in that case I'll have to take the responsive approach, identify non-compliant items, notify the user and then automatically delete them.
Thanks for the swift response.
Since they use the same connector, no there is no way to do that. If they are in different environments you could block the SharePoint connector from being used in the environment with the flow. But if they are both in the default environment or the same environment there is no way to block it. Your only real choice is to do it through a governance policy and educate the users on not making changes to the list without going through the app.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492