When list Item is created email item in HTML table

[irbandit]

Here is my scenario.  I have a SharePoint list for tracking orders.  When a someone enters a new item in this list, I run a flow to email the pertinent fields in that item to the ordering team.  What I would like to do is have that one item in an HTML table for readability and formatting.  Is there a way to do this when a new item is created?

Thank you in advance.

[P_Molitor]

I haven't used SharePoint lists, but I believe you would set up a new Cloud Flow with the trigger being [When a new Item is created](SharePoint), then add the action [Get item](SharePoint). from there you should be able to use a [Create HTML table](Data Operation) then enter the dynamic data from your [Get item] in to the HTML table and finally add the table output to a [Send email] action. 

I hope that offers some help. someone else that has used SharePoint more could probably give more information.

[irbandit]

Thank you very much @P_Molitor .  I will give it a try again.  Wasn't successful when I tried it because it said it was getting an integer.  

[P_Molitor]

If you are getting errors for data type, you may need to throw in a [Compose](Data Operation) action to convert your integer to string. I'm not sure why an HTML table wouldn't take an integer, but that could be your fix. I'm no help on the formula for the data conversion somebody with more knowledge than me will have to help with that one, but looking at an instance where I converted data to an integer, your formula may look something like this: 

string(outputs('Get_item')?['NameOfYourDynamicDataHere'])

[irbandit]

 am still unable to get this to work.  Can someone provide screenshots of how to get the existing item when created in SharePoint list into an HTML table for sending in email.  I already have a flow that when an item is created that I gather all the attachments and send an email but I also want to send the details of the record in an HTML table embedded in the email.  Any help would be apprecaited.

[v-JessicaG-msft · Accepted solution]

Hi @irbandit ,

Do you want to create an HTML table to send an email with the dynamic content of the new item in the "When an item is created" trigger?

You could add HTML code in the "Send an email (V2) 2" action code view to create an HTML table. Please refer to screenshot :

Best Regards,

Jessica Gu

[irbandit]

Thank you very much. This helped.