You’re offline. This is a read only version of the page.
90
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))
Yes, something like that.
Isn't what you have working? Is the Variable myEmail set to the correct/expected value?
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!
Why don't you try the Office365Users connection?
Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn
#1
WarrenBelz
146,603
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
