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.
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.
