Answered

Dropdowns & Lookups Don't Show for a Certain User

(1) Share

Report

Posted on by Matt_Hong

Has anyone seen any cases where PowerApps dropdowns and people lookups work for most users, but not a certain user or a small subset of users? If so, what was the solution?

I have 1 user who is trying to use PowerApps forms, but the dropdowns and people lookups don't populate. I performed the following troubleshooting steps:

Had her try multiple browsers - IE11 and Chrome. Same issue between them
Had her try my browser with her login. The dropdowns don't work for her yet they work for my login
Checked to be sure that the user had access to the data source (SharePoint list). The dropdowns work within the list itself (via Quick Edit). I even gave her Full Control of the site for testing and that didn't resolve it
Turned off Explicit Column Selection for testing and that didn't solve the issue

The dropdowns and lookup fields aren't Collections and has the basic use the SharePoint integration (Customize Forms). As of now, she's the only one I know of with this issue and we've had successful submissions from others.

Based on this, I would say that it's tied to her account, but not necessarily her permissions since I gave her full access and she also can see dropdowns in the SharePoint lists themselves.

Any thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

a-ovbord on at

Like (0)

Report

Hi @Matt_Hong,

It looks like a permissions issue for that user since it's only happening to them and no one else and I believe it's a permissions issue on the data source (SharePoint).

May I suggest to open this thread on the SharePoint Community and hopefully someone there can spot the culprit:

https://techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint

Thank you,

Ovidiu

Was this reply helpful? Yes No
Matt_Hong 43 on at

Like (0)

Report

Hi @a-ovbord ,

I initially thought it was a permission issue, but she see the dropdowns and edit the list on the SharePoint side. I even gave her Full Control for testing. The PowerApp is the issue itself. Is there something that's required on the O365 user account level for PowerApps?

Matt

Was this reply helpful? Yes No
a-ovbord on at

Like (0)

Report

Hi @Matt_Hong,

But if you create a brand new SP list with a drop down and lookup column, then create a simple app and have the user access it from within this app, can she access them?

Thank you,

Ovidiu

Was this reply helpful? Yes No
Matt_Hong 43 on at

Like (0)

Report

Hi @a-ovbord,

Unfortunately, that doesn't work either. I'm guessing this is a strange and rare case since others aren't seeing this. We will open a Microsoft Support ticket for this.

Thank you.

Matt

Was this reply helpful? Yes No
Verified answer

Matt_Hong 43 on at

Like (1)

Report

Thanks to the Microsoft Support staff, we were able to get to the root cause of the issue. We have 2 separate logins to 2 different O365 tenants.

This user created a SharePoint connection with the other tenant account to the SharePoint list in PowerApps. Once the connection was created, PowerApps kept the connection, even when she logged out of that other account in O365. Since the other account didn't have access to the SharePoint list, none of the dropdowns worked.

We had to go make.powerapps.com -> Data -> Connections and then deleted that SharePoint connection. We then reconnected with the correct account and it worked.

Was this reply helpful? Yes No