SharePoint List as HTML table

[Anonymous]

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?

[v-micsh-msft]

Hi @Anonymous,

Yes, that is possible.

Please check and see if the following blog would help:

Build flows with HTML Tables, CSVs, and other new features like OCR and image content detection

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.

Regards

Michael

[Anonymous]

Thank you, but I the email was received in this weird format.

[v-micsh-msft]

Hi @Anonymous,

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.

Regards,

Michael

[WiggityZwiggity]

Did you ever figure out how to format these results at all or limit the number of columns that come back?

[Anonymous]

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?

[efialtes]

@Anonymous

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

"@odata.etag"

"ItemInternalId"

"__PowerAppsId__"

I tried "Join" action as a workaround, but the internal columns listed above are still displayed.

BR

[efialtes]

I found this thread in the forum

https://powerusers.microsoft.com/t5/Building-Flows/Sharepoint-List-to-Html-Table-in-Send-email/m-p/3...

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

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-can-I-set-quot-Maps-quot-parameter-o...

[Anonymous]

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?

[sergeluca]

the create HTML table output works well in the send email notification; I've just tried it...What do you get ?

[Anonymous]

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.

[sergeluca]

I did but some formatting when using the Create HTML table.

Here is one of my tweet :

https://twitter.com/sergeluca/status/1031256281334603776

you can use flow/logic apps expressions in the column mapping definitions

Kind regards

Serge Luca

aka Doctor Flow

[Anonymous]

Looks great! Would you have the HTML you used to format the table?

[efialttes]

Here you are an example with borders

https://flow.microsoft.com/en-us/blog/intermediate-flow-of-the-week-using-try-catch-to-build-robust-...

Hope this helps

[RamBhajan]

Great!!...i faced the same issue then i used Select action then it worked like a magic...Thank You..