Unanswered

LookUp function Access Right Issues and How to test access rights in a PowerApps form

Like (0) Share

Report

Posted on 29 Jul 2020 17:25:35 by Community Power Pla...

Hello Community,

I have created a customized form for a SharePoint list which uses a text label with a LookUp() function to display current entries from the SharePoint list. For me and colleagues with "full control" access rights this feature works perfectly fine.

However, I gave some colleagues "reading" and "add items" access to the connected Sharepoint site. The list inherits these access rights. These colleagues can see the items in the list but when they open the form they don't see the content of this LookUp function. Even when I gave them editing access to the whole site (and thus also the list) the label did not work for them. Does anyone have an idea why this happens?

These are the current access rights:

The text label within the form contains the following code (modified):

LookUp('List Name'; Title = Project_Name_Dropdown.SelectedText.'Projects' ; ColumnName))

I also have a second question: Is there maybe any way to test permissions without having to ask my colleagues all the time if the form works for them (I know there is a "check permissions"-feature in SharePoint. However, this does not apply to the PowerApps form)?

Thank you in advance for helping me out! 🙂

Best regards,

kk4

Categories:

General Questions

Using Apps Using Formulas

Connecting to Data

I have the same question (0)

All responses (6)

Answers (0)

Rbart 2 on 11 Aug 2022 at 09:36:46

Like (0)

Report

Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

I had the same issue. Solved it. Under avanced settings from the sharepointlist I had set permisions to users only to read and write their own registrations. After I changed this to read an write all items, it solved the issue with the Rights.

Was this reply helpful? Yes No
WarrenBelz 150,013 Most Valuable Professional on 02 Aug 2020 at 02:53:53

Like (0)

Report

Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

Hi @Anonymous ,
I suggest you lodge a Support Ticket with Microsoft

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.

Was this reply helpful? Yes No
Community Power Pla... on 31 Jul 2020 at 10:33:56

Like (0)

Report

Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

Hi @WarrenBelz ,

thanks again. However, this unfortunately did not solve the issue. Also, for people with full access rights the function works, while for others with the provided screenshot of the initial post it does not. I think its a permission problem. Do you know if there is any way to contact Microsoft directly?

Thanks!

Best regards,
kk4

Was this reply helpful? Yes No
WarrenBelz 150,013 Most Valuable Professional on 30 Jul 2020 at 11:50:22

Like (0)

Report
Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

Hi @Anonymous ,
I spotted something else - your code produces a potential table (list) rather than a definite single record - try this
First( LookUp( 'List Name'; Title = Project_Name_Dropdown.Selected.'Projects' ) );ColumnName

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.

Was this reply helpful? Yes No
Community Power Pla... on 30 Jul 2020 at 11:03:46

Like (0)

Report

Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

Hi @WarrenBelz ,

thank you for your message. Sad to hear that the testing does not work as I desire it, but thanks anyways 🙂

I already gave my colleagues editing access, which did not work. However, in my use case people should not be able to edit items anyways. Could there be another reason for the LookUp() not to work?

Thanks!

Best regards,
kk4

Was this reply helpful? Yes No
WarrenBelz 150,013 Most Valuable Professional on 29 Jul 2020 at 21:18:56

Like (0)

Report

Re: LookUp function Access Right Issues and How to test access rights in a PowerApps form

Hi @Anonymous ,
Add "Edit Items" and see if this makes a difference and no - unfortunately there is no way other than accessing and seeing the result that I know of.

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.

Was this reply helpful? Yes No