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 III
Super User III

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,926)