cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerExplorer
Helper I
Helper I

Custom Sharepoint List item not working for users who don't have acces to the list. Unable to open item link in powerapps form

Please help, I don't want to grant permission to the whole list for some users, We only want to share with them only list items when needed. Only to get some info on a given item. however, the users can't access the list item in power apps form like they would do for the plain SharePoint list item row... . they get this error,

 

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.

 

Again, I don't want to give these users any permission to the whole list , I want them to view/edit the items that's shared with them in the power-apps form just like plain list item. The problem is powerapps form is not opening the list item link . The list is customized in powerapps.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @PowerExplorer,

Firstly as noted before, you cannot access data in SharePoint from PowerApps without having permission in SharePoint to access the data. it is the same with any data source connected to Power Apps.

You can however set a custom permission level in SharePoint and disable “View Application Pages” and the user cannot navigate to a SharePoint view.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

8 REPLIES 8
WarrenBelz
Super User
Super User

Hi@PowerExplorer ,

There is no "item level" authentication in SharePoint other than restricting users to items they created, so unless this is what you want to do, you need to share the list with the user for them to be able to open the Power App.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

@WarrenBelz Thank you for the speedy response, 

 

I think it's not authentication issue , As you can see on the screenshots in both cases UserB can access an item if he clicks the list "Emoplyee1" , the only problem is why he can't open/access the customized PowerApps form for a given item link? (PicG) And only be able to open the plain SP list form(PicB)

Note: 1. UserB has no permission to the Site/List. We don't want to give permission to the list/site . 

          2. The Item link shared via email " Copy link" or " share" on the list tab. 

Need: We want users to be able to open a SP list item link in PowerApps form regardless they've permission to the list or not. 

PowerExplorer
Helper I
Helper I

Ideally this is what I am looking for in the screenshot without granting permission a user to the whole list, but in this case user has access to the list 

Hi @PowerExplorer ,

I am a little lost here in what exactly you are wanting the user to be able to open. It looks like a SharePoint link (as distinct from something in Power Apps)?

Also if a user needs to open a Power Apps integrated form, generally they need access to all lists connected to the app - is this what you are asking?

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

PowerExplorer
Helper I
Helper I

Thanks @WarrenBelz 

 

Also if a user needs to open a Power Apps integrated form, generally they need access to all lists connected to the app - is this what you are asking? 

 

Yes, this is the answer in red , except I don't want to grant them access to the list. But I want them to be able to open list item in Powerapps form , upon receiving a direct link to the item . 

 

The link is "SP list Item "

Hi @PowerExplorer,

Firstly as noted before, you cannot access data in SharePoint from PowerApps without having permission in SharePoint to access the data. it is the same with any data source connected to Power Apps.

You can however set a custom permission level in SharePoint and disable “View Application Pages” and the user cannot navigate to a SharePoint view.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Hello Warren,

When you say "it is the same with any data source connected to Power Apps", does it mean that if PowerApps is writing to a SQL database every user will need to have a login to that database?
Or will it use the login defined in the datasource connection in PowerApps?

Thank you

Hi @PabloD ,

I am not an SQL user, but I would certainly imagine that the connector (which Power Apps creates based on the user's credentials) would require them to be able to access the data source. Also with SQL as it is a Premium Connector requires the user to have a per-user licence.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,886)