Office365Users.UserProfileV2 Not Working

(0) Share

Report

Posted on by Sam70

273

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Sam70,

Modfiy your formula as below:

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

Was this reply helpful? Yes No