Unanswered

SharePoint List as HTML table

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (0)

v-micsh-msft on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-micsh-msft on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WiggityZwiggity 358 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
efialtes 350 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
efialtes 350 on at

Like (1)

Report
Copy link

Link copied!

I found this thread in the forum
https://powerusers.microsoft.com/t5/Building-Flows/Sharepoint-List-to-Html-Table-in-Send-email/m-p/35294/highlight/true#M3261
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-of-quot-Compose-Select/m-p/30893/highlight/false#M6922

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
sergeluca 500 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No