Get email address from multiselect people picker column separated by semicolon

(1) Share

Report

Posted on by Poweruser32490

126

I need to get email address from multiselect people picker column separated by semicolon. Used below code but it gets only 1 email address. May i know hot get multiple email address?

LookUp(
                    'TOOLS Details',
                    'Tool Name' = ComboBox2.Selected.Result,
                    'Tool Owner'
                )

Categories:

Building Power Apps

AI Builder

Connector development

Error handling

GCC, GCCH, DoD - Federal App Makers (FAM)

Microsoft Dataverse with Power Apps

Experimental features

Governance & administering

Power Apps Pro Dev & ISV

Power Query

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

frago 226 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490

You’re using LookUp, which returns only one record, so you’ll only ever get one email.

For a multi-select people picker, you need to handle it as a table, not a single value.

Solution

Use Concat instead:

Concat( LookUp( 'TOOLS Details', 'Tool Name' = ComboBox2.Selected.Result ).'Tool Owner', Email, ";" )

Why this works

'Tool Owner' (multi-select people column) = table of users

Concat() loops through all users

Email gets each address

";" joins them into one string

------------------------------------------------------------

If this solved your issue, please mark it as ✅ Accepted Answer.
If it helped, feel free to give it a 🩷 Like!

Best regards,
Piotr

Was this reply helpful? Yes No
Suggested answer

PowerDeveloperTP 453 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Poweruser32490

LookUp() returns a single record. Even if 'Tool Owner' is multi-select, Power Apps treats it as a table inside that record

You can try below formula for getting all email address from multiselect control.

Concat(
LookUp(
'TOOLS Details',
'Tool Name' = ComboBox2.Selected.Result
).'Tool Owner',
Email & ";"
)

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

you can also try below :

With(
{
varOwners: LookUp(
'TOOLS Details',
'Tool Name' = ComboBox2.Selected.Result
).'Tool Owner'
},
Concat(
varOwners,
Coalesce(Email, Mail),
";"
)
)

Was this reply helpful? Yes No