Unanswered

Lookup columns don't work for all users

(1) Share

Report

Posted on by knorthon

I built a PowerApp connected to several SharePoint lists. The lists are all on a single team SPO (collaboration) site. A form in the app has several lookup columns. The team/site owners have no problems with the form, but for the team members (edit access to the site), the lookup column dropdowns on the form are not populating with choices. I've triple-checked permissions and don't see any issues. Any thoughts as to what may be going on?

UPDATE - SharePoint site members (edit access) cannot see contents of any lists!!! No broken permissions. All lists inherit permissions from site. What the actual f...?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

abc 123 789 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

When the user interacts with the lists directly, can they see the data in the Lookup?

What are the Item properties of these dropdowns?
knorthon 17 on at

Like
a
(0)

Report
Copy link

Link copied!

abc 123 -

I had one of the users go to the SharePoint site (of which they are a member) and try going directly to two lists on this site (which do not have unique permissions), and they got a "This list is empty."
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @knorthon

Did you check that all the relevant users have permissions on the other list being looked up ?
knorthon 17 on at

Like
a
(0)

Report
Copy link

Link copied!

WarrenBelz - I did. but, I ended up adding all team members to an AD DL/security group and adding that DL to the SPO Site Members group. That did the trick, but it should not have been necessary.