Is it possible, when a new item is created in a sharepoint list, that an email could be generated and sent contain an HTML view of the sharepoint list?
Yes, that is possible.
Please check and see if the following blog would help:
The flow should be in the following format:
Use the Get items value dynamic content as the Create HTML table Input.
Then add the Send an Email action, make sure the Is HTML have been selected to Yes:
If you have any further questions, please post back.
That should be related with the lookup fields.
Those fields would show in record type(which contains multiple elements) when connecting with microsoft Flow.
If the HTML format in Email action not looks in a friendly way, then please consider switch to Notifications->Send Email notification:
Using the Notification Action should have the Title shown in a proper way.
I've tried this too and I got a similar format.
Is there an example somewhere that displays a successful HTML table? What does one look like? Is this possible?
I have reproduced the formatting problems you got no matter I invoke "Send me an email notification" or "Send an email". The only difference in my case is that HTML Table source comes from "Excel Get Rows".
Workarounds to remove the following internal columns are welcome
I tried "Join" action as a workaround, but the internal columns listed above are still displayed.
I found this thread in the forum
The recommendation is to use Select action under "data operations"
I also managed to figure out how to use Select action after an Excel "Get Rows". Select usage discussion can be found here
Same situation, just different flow. Is there HTML code that I can add within the Send me an email notification action that will create a nice table in the Body?
What I would like to have is a nice table with borders for each row of data. And it would be nice not having any of the columns word wrapping like my Semester field is doing.
I did but some formatting when using the Create HTML table.
Here is one of my tweet :
you can use flow/logic apps expressions in the column mapping definitions
aka Doctor Flow
Here you are an example with borders
Hope this helps
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.