Unanswered

Patching Outlook NickName to an Excel File

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

We have a PowerApp where we are collecting the usage. Right now it collection UserEmail, LoginDate, and LoginTime. We wanted to add the UserID which is stored in the Outlook as the Alias (Nickname).

The patch formula works on everything except the "MailNickname". Does anyone have a work around or suggestion?

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Try Office365Users.MyProfileV2().mailNickname

Although your formula should work...IF there is a mailNickname in their Office 365 profile.

You mentioned Outlook - this formula gets the mailNickname from the Office365 profile. If you are referring to Outlook contacts, that would be something different.

I hope this is helpful.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the issue within your app?

Do you mean that the myAliasVariable value could not be saved into your Excel table?

Firstly, please check if the myAliasVariable is populated with proper value within your app. In other words, please check if you have configured a value for the MailNickname property in your Office 365 profile.

In addition, please consider modify your formula as below:

Patch( 'YourExcelTable', Defaults('YourExcelTable'), { UserName: Office365Users.MyProfile().MailNickname, UserEmail: User().Email, LoginDate: Today(), LoginTime: Now() } )

Or

Patch( 'YourExcelTable', Defaults('YourExcelTable'), { UserName: Office365Users.MyProfileV2().mailNickname, UserEmail: User().Email, LoginDate: Today(), LoginTime: Now() } )

Please take a try with above formula, then check if the issue is solved.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft ,

I have tried both solutions and neither worked for me. We tried using the variable because when first trying the "Office365Users.MyProfile().MailNickname" formula it didn't work. I've tested both the variable & the formula to the left in a label in a random spot on the app and they do show the Nickname data.

Thanks!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

You're not going to need a variable to test this...

Simply put a Label control on your screen to test and set the Text property to:

Office365Users.MyProfileV2().mailNickname

What does that show? It should show the mailNickname. If not, then there is some other factor (outside of PowerApps) that is a fault.

Try that first and make sure you get results.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Yes, it works, for use the Nickname/alias = Our userIds. We would like to use in an analytics file.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
We were able to get it to work by using the value stored in the label.

Patch( 'YourExcelTable', { UserName: Lbl_Nickname.Text, UserEmail: User().Email, LoginDate: Today(), LoginTime: Now() } )
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Anonymous ,

Have you solved your problem?

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,