Solved: Concat on "Create HTML Table"

Tea_Programmer · ‎12-05-2018

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 tableResultGoal

Tom_Slosse · ‎12-07-2018

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

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

View solution in original post

Tom_Slosse · ‎12-05-2018

Hey @Tea_Programmer

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>

</body>

</html>

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

Hope this helps

Kind regards

Tom

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Tea_Programmer · ‎12-05-2018

Hello @Tom_Slosse

I tried what you said and is not working. When I "initialize variable" with type "string" and "value

<html>

<body>

<table>

</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 · ‎12-07-2018

Hey @Tea_Programmer 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

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Tom_Slosse · ‎12-07-2018

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

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Tea_Programmer · ‎12-07-2018

@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 · ‎12-07-2018

Hey @Tea_Programmer

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

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Tea_Programmer · ‎12-11-2018

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