Unanswered

Show office locations for all users

(0) Share

Report

Posted on by syasmin25

Hello,

I have a form with the person picker dropdown (using the SharePoint person column to retrieve data) and I have another textbox that pulls in the office location of the person that is picked using office 365.
I do it by using the following formula in the data default section for the textbox
First(Office365Users.SearchUser({searchTerm:DataCardValue2.Selected.Email})).OfficeLocation

I was wondering if there is any way I can allow users to select multiple people from the person picker dropdown and have the textbox show the office locations for the persons selected.

Any ideas or suggestions would be highly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

SBax 1,348 on at

Like (0)

Report

For this sort of thing, I would suggest writing the selected people to a collection, then populate a gallery with the collection in the items property.

You could then add a field to look for the office location of "this item" in your gallery rows

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report
Hi @syasmin25 ,

Is this what you are looking for:

Concat( AddColumns( DataCardValue2.SelectedItems As _Users, "_Locations", First(Office365Users.SearchUser({searchTerm: _Users.Email})).OfficeLocation ), _Locations, "; " )

It takes all the basic information about the selected users in DataCardValue2 (_Users), adds a column with office location information (_Location) and then concatenates the values of that column, separated by a semicolon so it can be used for a text field.

Was this reply helpful? Yes No
syasmin25 51 on at

Like (1)

Report

Thank you, this helped a lot!

Was this reply helpful? Yes No