Search

Power Apps and Power Automate: Send emails from anyone

It's time to start learning!


Do you need Power Apps and Power Automate to send emails from someone other than the person who pressed the button? Learn how sending emails out via SharePoint gives you more control to set the email To's title and have replies go to that person automatically. Just takes a small call to the SharePoint Rest API to do it.


Click above to go straight to this video and follow along with the following summary.

Link to Shane's YouTube channel: https://www.youtube.com/c/ShaneYoungCloud/videos



 

Key Timestamps:

0:00 Power Apps and Power Automate Send a no-reply email from SharePoint

  • Shane explains what will be happening in this video and what all will be covered. Let's get started!

  • In this video, Shane will be explaining how to send a no reply email from either SharePoint or Power Automate Flow by using SharePoint Rest API.

  • Why would you want to perform this action using this method? Maybe you do not like the fact when a user sends an email from Power Apps it either comes from that user or seems to come from nowhere. When using this method when sending an email from the SharePoint site, the email comes in as a no reply email and has the capability to have a specific From user. Also, if the receiver replies to the email, the reply can go directly to the From user that was designated.

  • In conclusion, the emails sent using this method will not technically come from a specific user but replies can be sent back to the user performing this function.

2:00 Demo of the functionality

  • Shane shows the demo of his Power App and how he performs this method.

  • See how Shane utilizes this method by sending a no reply email from a PowerApps911 employee email to Chewy and himself directly from his demo app.

  • Do you want quick access to all downloadable apps and code snippets Shane uses in his videos? Save time building on your own and check out Shane's YouTube Video Resource Library!

3:53 Build a Power Automate Flow with a Send an HTTP request to SharePoint to Post to the Rest API

  • Follow along with Shane as he explains how to build a Power Automate Flow.

  • Open Power Automate Flow > Create > Instant Cloud Flow > Manually Trigger a Flow > Create > New Step > Search SharePoint > Send an HTTP Request To SharePoint (This does not require special licensing, only permissions. YAY!)

  • Once Send an HTTP Request To SharePoint opens, follow along with Shane to learn how to fill in the blank fields with the needed information.

4:56 A listing of the little caveats of using this method

  • Important points about using this method:

  • It can not send emails to external users.

  • It can not send attachments.

  • It can do to BBC, and CC.

  • It only works when sending to users the SharePoint site is familiar with - people within the user table / users who have used (or are associated with) the SharePoint site.

  • To, CC, and BCC are all formatted the same in the Body field.

  • Use square brackets [.] around one or more email addresses, each address within single quotes '.' and a comma between each address.

  • Example: 'To': ['Shane@powerapps911.com','Chewy@powerapps911.com']

  • Shane shows the difference of using this method to send from a "fake" email address compared to a existing email address.

10:57 Changing the SharePoint Site Title to affect the From Title of the email

  • Go to SharePoint site > Site Information > View All Site Settings > Title, Description, and Logo

  • Under the Title field will be what is shown on the no reply email if you send from a non existing email address when using this method.

  • Changing this field will give you the ability to change what users see when receiving no reply emails that you send.

11:36 Integrating the flow with a Power Apps app for dynamic content

  • Shane explains how to perform this flow within an app in Power Apps inputting dynamic content.

  • Refresh and add the Flow to your Power App.

16:12 Create the email string you need

  • Follow Shane as he shows how to use Combobox and Concat.

  • Run your flow.

  • You did it!


 

Additional Learning:


Do you want in-depth and self-paced Power Platform training? Are you looking to advance in your current role with the use of Power Platform? Take a look at our On Demand Training content and get learning today!



153 views