Unanswered

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)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

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,394 Most Valuable Professional on at

Like (0)

Report

Was this reply helpful? Yes No
jojos_iq 90 on at

Like (0)

Report

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,394 Most Valuable Professional on at

Like (0)

Report

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 (1)

Report

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