web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sharepoint forms item-...
Power Apps
Unanswered

Sharepoint forms item-level permission with PowerApps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, guys!

 

TLDR: Using Sharepoint PowerApps forms to display list items, also setting item-level permission through a power automate flow. By design I do not want users to have Sharepoint-site access to the lists itself and only item-level. When they navigate to the specific item (which is granted by item-level permission through Power Automate), they get an error when the forms app is loaded: "This app isn’t opening correctly It looks like you don’t have access to this app. Ask its owner to share it with you".

 

 

Background (details below of what we want to achieve):

 

I've created a Sharepoint list ('Oppgaver') forms where we are mimicking a to-do list for a group of people.

 

The idea behind this is that the manager(delegator) simply has full access to the whole list where this is his view (the only person that is a member of the specific site):

GakinImara_1-1620291368463.png

 

And the rest of the users (task-handlers) will only be able to see their items (item-level permission) as long as they have been assigned to the person-column "Ansvarlig".

This means that whenever a task-handler tries to open the link and navigates out of the item and to the manager-restricted list itself, they will only see their own assigned/permitted items only:

GakinImara_2-1620292171515.png

GakinImara_4-1620294509072.png

 

 

So far so good, but as soon as we activate the PowerApps forms it seems that the app's permission settings are inherited by the list/site-permission rather than item-level permission set by the Power Automate delegation-flow; they get this error during PowerApps load:

GakinImara_1-1620300914385.png

 

 

Are there any workaround to make the PowerApps forms not inheriting the permissions based on the Sharepoint list, but instead be based off the list-item permission set by the existing Power Automate flow trigger? 

 

Suggestions, links and articles are greatly appreciated to guide me!

 

Br, Ga Kin

 

Edit: Changed title to reflect the specific issue with Sharepoint forms item-level permissions including a Power App.

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    (Update) as a temporary workaround:

     

    I've made the list available (edit-access) to members in a specific group and created a custom default filter for the list, to filter the list-items only displaying [Me]. This way, the PowerApps forms will be available for the users to edit the items, and when trying to navigate back to the list - the view will be filtered (but unfortunately not restricted if they happen to change the filter view).

  • Caryn Profile Picture
    6 on at

    Hi @Anonymous 

     

    Did you ever find a solution here? I am having the same issue.

     

    Thank you

    Caryn

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi, @Caryn !

    Unfortunately, no... Instead I made a default list-view in my Sharepoint List for users in general, which only showed items that was tagging themselves from a specific column.

    A temporary solution involving changing the SharePoint list filter. But they will still be able to see the other items not assigned to them if they are changing the list filter view in the future:

    GakinImara_0-1642593760888.png

    I cannot remember the syntax for the filtering since this was done on a customers tenant, but you might be able to find the right syntax if you search for it online. it was something with "[@me]"...

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello again @Caryn. I noticed that @RezaDorrani have shared a new tutorial that might be touching abit on the subject to resolve this (I've only been scrambling through the video) - the next best thing is that  you have an additional Power Automate flow that tracks any list item changes, with an action that just updates the permission right to the specific item to the assigned users:

     

    Power Apps SharePoint List Security | Item Level Permissions & Folder Security with Power Automate - YouTube

  • Caryn Profile Picture
    6 on at

    Wonderful thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard