cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Erannon
Level: Powered On

Mail to multiple users

Hi all,

 

I'm trying to build an app for our crisis support team. One of the features is that you should be able to send a message, via mail or sms, to all the members of the team at once.

 

Does anybody know how to do that?

I've tried with the Launch command with no success. Any suggestions is most welcome.

The data is stored in a table in an excel sheet on OneDrive.

 

/Erannon

1 ACCEPTED SOLUTION

Accepted Solutions
Erannon
Level: Powered On

Re: Mail to multiple users

Hi, 

 

I think I solved it!! 😄

 

I've got some (a lot) help from a friend and combined the Launch, Concate and the Collect functions on a button.

Collect(Samling1; Krisstodjare);;Launch("mailto:" & Concat(Samling1; Epost & ";"))

 

And it worked like a charm. Thought you guys wanted to know.

 

/Erannon

View solution in original post

7 REPLIES 7
SPDevelKMT
Level 8

Re: Mail to multiple users

If you are storing the data from your app in SharePoint, you can create a Flow that triggers when a new Item(for a list) or a new file(for a library) is added to SharePoint.  Flow has a Send an Email action that you can configure to send an email to as many users as required.  You can also set the body and subject of the email within the flow.  

Super User
Super User

Re: Mail to multiple users

In this video I show you how to Send an email with PowerApps. Is that what you are looking for?

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Erannon
Level: Powered On

Re: Mail to multiple users

Thanks for your answer

That would probably work. Never used flow before but i can give it a try.

Unfortunately (spelling?) I can not use a Sharepoint list. Can you use flow with an excel sheet?

 

/Erannon

 

 

Erannon
Level: Powered On

Re: Mail to multiple users

@Shanescows

I've watched your video, great work btw.

 

One of the benefits of the app would be that the members can manage their own contact info themselfs, so hard coding the adresses wouldn't work.

 

I've tried to use the Launch function.

Launch("mailto:"&Epost)

But I only get the first post in the table in the adress field.

 

Any thoughts?

 

(Pardon my spelling. English isn't my first language)

Super User
Super User

Re: Mail to multiple users

You could give them a text field in the PowerApps app to enter email address and then use that for the To: line when they press send. 

 

I haven't done it before but that seems to work in my head. 

 

Sorry, I have never tried to use Launch. Hold that. I was curious so I played and this works for me:

 

Launch("MailTo:shane@powerApps911.com&Subject=This is my subject text&Body=This is my email body")

 

 

Shane

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Erannon
Level: Powered On

Re: Mail to multiple users

Hi, 

 

I think I solved it!! 😄

 

I've got some (a lot) help from a friend and combined the Launch, Concate and the Collect functions on a button.

Collect(Samling1; Krisstodjare);;Launch("mailto:" & Concat(Samling1; Epost & ";"))

 

And it worked like a charm. Thought you guys wanted to know.

 

/Erannon

View solution in original post

9dj89
Level: Powered On

Re: Mail to multiple users

You can mail to different users by storing all user emails in one text variable separated by semicolon and defining it in the email portion of the send email function.  

 

For example: Office365Outlook.SendEmail(_emailName,"Testing","EmailBody")

 

where _emailName is emails seperated by semicolons. 

Thanks, 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,214)