Create an email list from a people picker field powerapps

(0) Share

Report

Posted on by Misa

248

Hello.

I have a SP column that is a people picker. In the PowerApps form i am using a combobox that pulls that list into the form. The value is chosen by a column we can call Dropdown1. When chooses an option in Dropdown1 it autopopulates a person in the combobox.

What i am trying to do, unsuccessfully, is send an email by clicking a button that uses the value in the combobox. The value in the combobox shows as an email addy but i keep getting an error saying, "The Run function has invalid arguments in the Sendto field.

I am using 'DisasterCRL-Sendanemailtoapprover'.Run(ComboBox1.SelectedItems.Email,"Your review has been requested",EmailtoRequestor.HtmlText) in the OnSelect property of the button.

I have also tried using the concat and the text(email) in the formula and am given the same error.

I can't figure out what where to go from here. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

kbilakanti 315 on at

Like (0)

Report

@Misa you this formula :
Concat(ComboBox1.SelectedItems.Email,Email,";")

Attached screenshot for the same.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

@kbilakanti

Hi and thank you. I did try that concat function and both "SendanEmail" and Flow did not recognize the email address. I tried with both a Combobox and a Dropdown and used the Filter function.

I do appreciate your suggestion.

Was this reply helpful? Yes No
kbilakanti 315 on at

Like (0)

Report

@Misa Can you please output the concat function in label and check if those email id's are valid and are being separated by ";", Please check the flow Run once.

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

@kbilakanti

Yes. The email address shows up in the label. I ran the flow and it failed again.

Was this reply helpful? Yes No
kbilakanti 315 on at

Like (0)

Report

@Misa Can you please paste the error message or screenshot of you flow ran status to further investigate on this.

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

@kbilakanti. Please see attached and thank you again for your help.

Was this reply helpful? Yes No
kbilakanti 315 on at

Like (0)

Report

@Misa Can you please remove the flow binding and add it again once in power apps. I tried it and it worked successfully.

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

@kbilakanti

When you say Flow binding, do you mean the flow.run piece?

Before i did that, i hardcoded an email address in the formula and it worked. I am not sure what you mean for the binding 😕

Was this reply helpful? Yes No
kbilakanti 315 on at

Like (0)

Report

I suspect it's because of data type issue. As you said you are hard coding it you mean to say you are passing it in double quotes ?"test@gmail.com"

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

Curious, so what happens is that the user picks an option from a dropdown. Based on that dropdown it populates an email address. The email address is a People picker column. Is it treated differently?

I have tried having a flow update a single line of text column (in the Sharepoint list) with the email address. i have tried creating a label that shows the Combobox value and tried sending an email (both via flow and from Powerapps) without success. All the research i have done on the internet has not helped 😞

I would like to think that im not a newbie to Powerapps but it's starting to feel that way.

Thanks for your help.

Was this reply helpful? Yes No