Answered

How to split the claims field from a People Picker Field in PowerApps to get the UPN Address

(0) Share

Report

Posted on by jojos_iq

Hi all.

I have a gallery that I need to only show the items assigned to the user currently logged into the app. The issue is is that the quite a lot of our user accounts (for reasons) have email aliases that are mismatched to their UPN.

I would like to take the claims field from a people picker item and split the UPN attribute from it, but I do not know the syntax 😞

Could someone help with this please? If additional information is required, please ask away and I would be more than happy to answer.

Guessing it is something like: Split(Second(ThisItem.'Column name', "|")) but I couldn't work it out from the documentation that I could find, and I wasn't too sure how the Power Automate version of it translated to PowerApps (Solved: UPN from people picker - Power Platform Community (microsoft.com))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Why don't you try the Office365Users connection?
Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
jojos_iq 90 on at

Like
a
(0)

Report
Copy link

Link copied!

It didn't even cross my mind to try that, thank you 🙂

What I am trying to achieve with this value is create a filter on the Gallery so the items shown are only those where the current user UPN is equal to the UPN of a column called 'Manager assigned to'. Are you able to help with this please?

Current formula on the Gallery at the moment:
Items > Filter('SharePoint List DataSource', Lower(myEmail) = Lower('Manager Assigned To'.Email));

Where the variable myEmail = Set(myEmail, Office365Users.UserProfile(User().Email).Mail);

If you need additional info, please let me know!

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, something like that.
Isn't what you have working? Is the Variable myEmail set to the correct/expected value?

Was this reply helpful? Yes No
jojos_iq 90 on at

Like
a
(1)

Report
Copy link

Link copied!

Ahh sorry it now works properly - caching issues with my browser. Using an Incog tab in Chrome has now fixed the issue.

Thank you for your help 🙂

Was this reply helpful? Yes No