Users unable to access sharepoint list items through vlookup

[Alois]

Hi All,

I'm having this issue where my users are unable to access dropdown items defined in sharepoint list through lookup function. It works perfectly fine for me as the app owner. I have also ascertained the code is correct and the shared users have edit permission levels.

One thing I did which I suspect is the cause of this issue was to break inheritance of the sharepoint list access from the parent site. I have since removed the unique permission of the list and restored the inheritance. However, it doesn't seem to function normally anymore. Shared users are able to access the sharepoint list on sharepoint online but the vlookup in powerapps doesn't work (i.e. no errors but the items are not populated).

Can anyone help me out on this?

Regards,
Alois

[Alois]

Ok I just done some testing.

I attempted to authenticate if the lookup returns a true or false value.

My app has a variable varUser set OnStart with Set(varUser,User())
My list named User Roles has a column of person type named User

In my Lookup function, I defined it as:
If(Not(IsBlank(LookUp('User Roles',User.Email=varUser.Email))),Concatenate("Glad to have you here. You are seeing data for the following site(s): ", LookUp('User Roles',User.Email = varUser.Email, 'Site 1'.Value)),"No site assigned. Please contact me to onboard the application.")

What I'm trying to achieve is to match current user's email with an existing email in the list and populate their assigned sites. Interestingly, even with the person item created in the list, the test returns false value. 

Does anyone know the reason why and perhaps offer a solution to fix this?

Regards,
Alois

[v-jefferni]

Hi @Alois ,

Perhaps below thread will help:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-SharePoint-lists-as-a-datasource/td-p/...

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.