Office365Users.UserProfileV2 Not Working

Like (0) Share

Report

Posted on 19 Feb 2024 16:24:04 by Sam70

260

Hi,

I have populated multiple person type data in a gallery by using the below formula -

Concat(ThisItem.'Auditor Name',Email,Char(10)).

I need to get the office location from the output of the above formula. I tried using Office365Users.UserProfileV2(x).officeLocation but not getting the desired result. What formula i need to put in place of x?

Regards

Categories:

Using Apps Using Formulas

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 20 Feb 2024 at 03:10:07

Like (0)

Report
Re: Office365Users.UserProfileV2 Not Working

Hi @Sam70,

Modfiy your formula as below:

Concat(ForAll(ThisItem.'Auditor Name',Office365Users.UserProfileV2(Email).officeLocation),Value,",")

Was this reply helpful? Yes No
mmbr1606 13,535 Super User 2025 Season 2 on 19 Feb 2024 at 16:25:58

Like (0)

Report
Re: Office365Users.UserProfileV2 Not Working

hey @Sam70

can you please try this:

Office365Users.UserProfileV2(ThisItem.Email).officeLocation

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No