![]() ![]() One way we can do some styling is to add a CSS stylesheet to our HTML. The output from this action looks like this:Īs you can see, it works but the styling leaves a bit to be desired so let’s see if we can pretty it up a bit. The Send an Email action looks like this: Now that we have a HTML table generated, we can insert it into an email, or a Teams message, or create a PDF with it, or any other approriate action you can think of.įor the purposes of this demo I’m going to send it in an email, and I’ll include some of the details from the parent Quote record. As we’ve specified the Columns in the Select action above, we set the Columns to automatic. Create HTML Table – the final step to create the HTML table is to use the Create HTML Table action. The easiest way to think about this is that the first column is the “Headers” for the table, whilst the dynamic values in the second column are the “rows” for the tableģ. Select – we use the Select action to specify matching key:value pairs from the returned records from the List CDS records step above. Similarly, you could retrieve records from SharePoint (or any other data source).Ģ. List CDS records – we use the List Records action to retrieve a list of records from CDS. In the extract from my Flow below I’ve covered the key steps to create a table from a list of CDS records:ġ. There is an action in Power Automate called “Create HTML Table” and it will probably suffice for most usage scenarios. The Situationįor the purposes of demonstrating this Flow I’m going to use the scenario where I’ve created a Quote for my customer and I want to email it to them using a Power Automate flow. This is a regular occurence in my organisation, and I’ve run into some limitations with the standard “Create HTML Table” action so in this blog I’ll explore them and demonstrate how I’ve managed to work around them. ![]() If you’ve been using Power Automate flows to send notification emails to people in your organisation then there’s a fair chance you’ve run into a requirement to send a table of results in the email. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |