This was a great episode. How would you add a rich text field to the body using this approach? I have a SharePoint multi-line rich text field that I want to populate the body of the email, and I've had no luck adding it in the body.
I haven't tried this before but you need to properly format the HTML content in the email body. SharePoint's multi-line rich text fields may include HTML tags to preserve formatting, so you'll need to handle this appropriately when populating the email body. Start by creating a new step in your Power Automate flow after retrieving the SharePoint list item containing the multi-line rich text field. Add the "Send an email" action to send an email. In the "Body" field of the "Send an email" action, you'll need to use an expression to extract the HTML content from the SharePoint multi-line rich text field and set it as the email body. To do this, use the htmlToText function to convert the HTML content to plain text. Here's how you can do it: htmlToText(triggerBody()?['YourRichTextField']) Replace 'YourRichTextField' with the name of your SharePoint multi-line rich text field. Additionally, in the "Body" field of the "Send an email" action, set the "Is HTML" option to "Yes." This informs Power Automate that the content of the email body contains HTML. Configure the other required properties of the "Send an email" action, such as recipients, subject, etc., according to your requirements. Save and test your Power Automate flow. See if this works. I may have to create a video on this. Good idea. Thanks!
My use case I am using the PDF function that was released as experimental last year. I set it as a variable and then pass that variable to flow to use in the SharePoint API call you demo in the video.
Update: I tried to send an email with an attachment and it didn't work sadly 😕. Maybe I did something wrong in the body, but I couldn't get it to work.
Hi, I did exactly the same and flow ran successfully but the email was not received.. i checked the spam and junk, it's not there. I am really clueless, can someone please advise me?
Apologies this took so long. _api/web/sitegroups(21)/users The 21 is the SharePoint group ID. Just make sure you replace it with yours. Hope that helps.
This was a great episode. How would you add a rich text field to the body using this approach? I have a SharePoint multi-line rich text field that I want to populate the body of the email, and I've had no luck adding it in the body.
I haven't tried this before but you need to properly format the HTML content in the email body. SharePoint's multi-line rich text fields may include HTML tags to preserve formatting, so you'll need to handle this appropriately when populating the email body.
Start by creating a new step in your Power Automate flow after retrieving the SharePoint list item containing the multi-line rich text field.
Add the "Send an email" action to send an email.
In the "Body" field of the "Send an email" action, you'll need to use an expression to extract the HTML content from the SharePoint multi-line rich text field and set it as the email body. To do this, use the htmlToText function to convert the HTML content to plain text. Here's how you can do it:
htmlToText(triggerBody()?['YourRichTextField'])
Replace 'YourRichTextField' with the name of your SharePoint multi-line rich text field.
Additionally, in the "Body" field of the "Send an email" action, set the "Is HTML" option to "Yes." This informs Power Automate that the content of the email body contains HTML.
Configure the other required properties of the "Send an email" action, such as recipients, subject, etc., according to your requirements.
Save and test your Power Automate flow.
See if this works.
I may have to create a video on this. Good idea. Thanks!
Thank you. I have one question: if I want to add an attachment, what should I do?
The video was very helpful. Thank you.
Great breakdown of how to do this! Do you know if you can add attachments too?
Thanks! I don't know but let me find out and get back to you. Good question.
My use case I am using the PDF function that was released as experimental last year. I set it as a variable and then pass that variable to flow to use in the SharePoint API call you demo in the video.
@@dankirchner4460 Thanks for the use case. I'll see what I can find
I'll give it a shot on my end as well and see what I get
Update: I tried to send an email with an attachment and it didn't work sadly 😕. Maybe I did something wrong in the body, but I couldn't get it to work.
I want the FROM email id from the different action where it takes email id based the response received.can you pls suggest?
Hi, I did exactly the same and flow ran successfully but the email was not received.. i checked the spam and junk, it's not there. I am really clueless, can someone please advise me?
@@NandagopalB Did you go to the workflow history and click on the date and time and debug from there?
Hi guy, where is the Uri "_api/..." code? Hope u reply. Thank you
I'll get it to you shortly
Apologies this took so long.
_api/web/sitegroups(21)/users
The 21 is the SharePoint group ID. Just make sure you replace it with yours. Hope that helps.
Hi, I wander how do I send to more recipients.
I don't have a video showing how to do that yet but this might help. th-cam.com/video/574R1VrE57E/w-d-xo.html
Here's my video of how to send to a SP group, if you haven't figured it out yet. th-cam.com/video/w79Un0on6P8/w-d-xo.html
Hi, thanks for this Video. It was highly helpful.
How do I get to attach a file from sharepoint to an email. Appreciate.
Try this vblogs.in/send-email-with-attachments-in-power-automatems-flow/
@@OptimalTrainingGroup thank you.
Thank you.
Hello, how to send e mail with attachment Send Email with HTTP-Request so from is 'no-reply