Get email address from multiselect people picker column separated by semicolon

(1) Share

Report

Posted on by Poweruser32490

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 188 on at

Like (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 446 on at

Like (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 939 on at

Like (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