Unanswered

Sending an email to user picked in field.

(1) Share

Report

Posted on by VxChemical

I was pretty confident that I did this right, however its not working, no email is sent, the data is submitted to the List.

Property for my DataValueCard2 is Choices([@'User Account Form'].Supervisor)

The OnSuccess on my form is set like this

Office365Outlook.SendEmailV2(Concat(DataCardValue2.SelectedItems, Mail,";"),"Testing HTML Link","To upload your document open the app: <a href='https://apps.powerapps.us/play/e9c2d077-4fa2-4988-9123-491a156a4594?tenantId=66cf5074-5afe-48d1-a691-a12b2121f44b&ItemID=" & Form1.LastSubmit.ID &"'>Link to App</a>");Navigate(Screen2);
ResetForm(Form1)

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Try something like that:

ForAll(DataCardValue2.SelectedItems, Office365Outlook.SendEmailV2( Mail, "Testing HTML Link", "To upload your document open the app: <a href='https://apps.powerapps.us/play/e9c2d077-4fa2-4988-9123- 491a156a4594?tenantId=66cf5074-5afe-48d1-a691-a12b2121f44b&ItemID=" & Form1.LastSubmit.ID &"'>Link to App</a>" ) ); Navigate(Screen2); ResetForm(Form1)

Plus, instead of "Mail" you might have to use "Result" of ForAll.

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!
VxChemical 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Thanks for helping out.

No email is sent. Hardcoding the email address in works so it can send email.

I dont know if its because its a form from a Sharepoint list and the field is a Select AD user field
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Why dont you use a Flow?

Trigger -> Power Apps

Add a step that is a compose and ask in Power Apps.

Then, send the email

In power apps, when you press that button you run the flow and send the emails

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!
VxChemical 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Doesnt seem like its easier to get it to understand the field type in the Flow menu's.

Shouldn't the commands I wrote work, or the ones you did? 🙂

Thanks
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

It should but since I am only seeing the code, I am not even testing in my tenant, I was just giving suggestions.
VxChemical 48 on at

Like
a
(0)

Report
Copy link

Link copied!

and I am thankful for that 🙂

Could I post anything from my solution that would be helpful? 🙂
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@VxChemical ,

You do not need a Flow as Power Apps does a very capable job of sending emails - I assume firstly that the output of DataCardValue2.Selected.Mail contains valid email addresses (this is the primary reason emails fail to send). Your HTML body link seems correct (although this would not stop the mail sending). Try this

Office365Outlook.SendEmailV2( Concat( DataCardValue2.SelectedItems, Mail & ";" ), "Testing HTML Link", "To upload your document open the app: <a href='https://apps.powerapps.us/play/e9c2d077-4fa2-4988-9123-491a156a4594?tenantId=66cf5074-5afe-48d1-a691-a12b2121f44b&ItemID=" & Form1.LastSubmit.ID &"'>Link to App</a>" ); Navigate(Screen2); ResetForm(Form1)

but if it fails, put this on a Label

Concat( DataCardValue2.SelectedItems, Mail & ";" )

and see if you have valid mail addresses separated by ";"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VxChemical ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps