Showing results for 
Search instead for 
Did you mean: 
Responsive Resident
Responsive Resident

Cant display values via service user from SPO List

Hi All,

have a little SharePoint online list that I customized with powerapps. One of the features is that its showing into 2 other lists and displays it on the screen within the form. The odd thing is that although i am using an account (service account) that has full access to list Y, its not showing me the value, unless i give the user (the real user who is logged in) at least read access to that particular item that he should get.

In other words, Jack is watching the form "X" a service user is getting values to this form from list "Y". This should display it because service user has full control over list Y. but strangly it works only if Jack gets at least "read"... why is this?


the value is displayed with: Filter('MYLISTNAME', Title = (value2look4)).'MyDesiredColumn'

-where the mylistname si displayed as an connection, in my app, with the service user




Super User
Super User

The SharePoint connector uses the logged in user's access, so if the user doesn't have access to a list or an item in the list it will not be return in the connector.

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Responsive Resident
Responsive Resident

hi@Jeff_Thorpe , thanks for response, wonder why do i have the possibility in powerapps to choose the user that will open the list, ...(via connector)?

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,962)