Feed combobox/peopl with UPNs/email to display names

(0) Share

Report

Posted on by Sifu

834

Hello,

i have a column in a sharepoint list where are upns separated by semicolon and space... (abd@company.com; bcd@company.com, etc...).

I want to feed this column to a combobox but cant figure out how to split this... something like:

Office365Users.UserProfileV2( Split(ThisItem.IdeaAuthors,";").Result ).displayName

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sifu ,

Could you tell me:
Do you have a record similar to the picture below?
// 'Test' is a 'Single line of text' column.

Do you want to fill the combo box control with these three emails?
If so, you could use this formula on Items property of combo box control:
ForAll(Split(First(LIST112).Test,";"),TrimEnds(Result))

If you want to get all UserProfiles and fill the combo box control, you could tyr this formula on Items property of combo box control:
ForAll(ForAll(Split(First(LIST112).Test,";"),TrimEnds(Result)),Office365Users.UserProfileV2(Value))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

almost working, i had to adapt it to reflect the current item:
ForAll(ForAll(Split(ThisItem.IdeaAuthors,";"),TrimEnds(Result)),Office365Users.UserProfileV2(Value).displayName)
but i also get an error, any idea why?
oddly it works (with an error..)

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

the source column had an ";" after last name... this was the problem

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sifu ,

You could use filter() function to solve it.
Please try this formua:
ForAll(Filter(ForAll(Split(First(LIST112).Test,";"),TrimEnds(Result)),!IsBlank(Value)),Office365Users.UserProfileV2(Value))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(1)

Report
Copy link

Link copied!

thanks but i already resolved it at the source... so it wont pout the ";" after last user upn

Was this reply helpful? Yes No