Answered

Variable/Office365Users Connector Issue?

(0) Share

Report

Posted on by Del1

I have an issue in an app where employee information is not being retrieved. I have a formula to set a variable varEmpID, which is used to display employee name and email in text labels and to collect a list item to generate a report. For some users of the app, this employee info is not displayed.

varEmpID is set OnStart using a parameter passed in the URL and a lookup on a SP list. Fx: Set(varEmpID,(LookUp('SPLIST', ID = Value(Param("ID")),Title ))) It's in the format of username@companyemail.com

The formulas in the text labels are: Office365Users.UserProfile(varEmpID).Mail and Office365Users.UserProfile(varEmpID).DisplayName

It only happens with some people, not everyone. I've moved the "Set" formula to different screens to see if worked, but it didn't. There are loading spinners on the pages and we have changed the properties of those with no impact either. Does anyone have any ideas? I'm willing to try anything. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Del1 ,

Have you verified if:

1. A valid value was passed in the ID parameter?

2. The users have access to the referred item in SPLIST?

Was this reply helpful? Yes No
Del1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer
thanks for the reply!

yes, the ID is passing correctly, I screen shared with the user and verified. I even tried the url myself and the employee info displayed correctly for me.

All users have the same permission level to the SP list. So it’s the same for those who can and can’t see employee info.,

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Del1 ,

Have you specifically verified access for the users that have issues? Also, have you tried adding a label to show the value of varEmpID for the impacted users to see if it populates correctly?

Was this reply helpful? Yes No
Del1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer

Oh my goodness, I dont know why I didn’t think of that, lol. I did add a text box and it looks like varEmpID is not setting for these users. Now I’m at a complete loss as to why it wouldn’t for some users and work fine for others?

Also, I did verify individual permissions and they all checked out.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Del1 ,

At least we rule out the connector (for now) as the cause. When checking the individual permissions, did you check them at list or item level? They may be different, so it's worth checking if these users have access to the item which' ID is passed in the parameter.

Was this reply helpful? Yes No
Del1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer
I checked both item and list level and verified access.
Just to go a step further, on my test user, I took them out of the “app user” permission group I have set up and gave them direct edit access and had had them test again with no success.

Was this reply helpful? Yes No
Del1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer
I accepted as solution the permission issue. I overlooked item level permissions in the advanced settings of the list. I went back through after my last response and suddenly remembered that setting. I turned that off and it is now working as expected. Thank you so much for your assistance today!

Was this reply helpful? Yes No