Answered

Concat on "Create HTML Table"

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a function "Get Items" and other function to create html table with the data from "Get Items" and I send an email with the table. The results from that is not what we was expected. I've tried insert html tags inside "Create HTML table" and is not working. I also tried to a concat function like:

concat('<!DOCTYPE html>
<html>
<body>
<ul>
<li>Title</li>
</ul>
</body>
</html>')

I send a print to help you to understand the goal. Can someone help me?

Thank you.

Create html table Result Result Goal Goal

Categories:

General topics

All responses (7)

Answers (1)

Sort by

Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

You could make a table yourself using by defining a variable of type string and then sets its value to be something like

<html>

<body>

<table>

<tr><td></td></tr>

</body>

</html>

Something like that. And then use its output in your email you want to send.

Hope this helps

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Tom_Slosse

I tried what you said and is not working. When I "initialize variable" with type "string" and "value
<html>
<body>
<table>
<tr><td></td></tr>
</body>
</html>"

Flow automatically apply to each cause inside "<td>" Im using a dynamic item "Title" from sharepoint and when I try to run the flow shows me a message "
The variable action 'Initialize_variable' of type 'InitializeVariable' cannot be nested in an action of type 'Apply_to_each'."
Thank you.
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous Apparently the reply is totally broken because I can't upload pictures anymore. I already made this work with the use of a variable. I first initialize a blank variable. Then i loop through the sharepoint items with an apply to each and i use compose actions to have some content for my table. Then after the apply to each I set my blank variable to a table like I mentioned before en I join the outputs in my set variable. Kind regards Tom
Verified answer

Tom_Slosse 1,430 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @Tea_Programmer

Apparently it is broken in Chrome so Im making this post again.

I already made this work with the use of a variable.

I first initialize a blank variable.

Then i loop through the sharepoint items with an apply to each and I use compose actions to have some content for my table.

Then after the apply to each (so your set variable is not in a loop) I set my blank variable to a table like I mentioned before en I join the outputs in my set variable.

Hope this gives you more insights.

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@Tom_Slosse

It's working fine. Thank you!!!
One more thing, I dont know with you can help me, when I send an email with an image from sharepoint on body It doesn't load when I receive the email. What can I do to solve this?

Regards,
Ruben Silva
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

You should sent the picture as an attachment rather then put it in the body.

I never put something inline an email, one for readablity and it doesn't always work either.

Let me know if this works

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Tom_Slosse,

What I want is send an image in the body. I made some tests and when I send an email with custom css on the body, in Outlook 2016 (Online) the css code is working fine but Is not showing the image when I send to another user. In Outlook 2016 (App) my css is totally broken. I sent some screenshots to help you to understand what I'm trying to do.
Any ideias what can I do?

Best Regards.Outlook 2016 Online

Outlook 2016 App