cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Concat on "Create HTML Table"

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.PNGCreate html tableResult.pngResultGoal.PNGGoal

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Concat on "Create HTML Table"

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.

init variable.PNG

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

Apply to each for the variable.PNG

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.

Set variable.PNG

Hope this gives you more insights.

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





7 REPLIES 7
Super User
Super User

Re: Concat on "Create HTML Table"

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>

<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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Concat on "Create HTML Table"

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.
 
Super User
Super User

Re: Concat on "Create HTML Table"

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




Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Highlighted
Super User
Super User

Re: Concat on "Create HTML Table"

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.

init variable.PNG

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

Apply to each for the variable.PNG

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.

Set variable.PNG

Hope this gives you more insights.

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Concat on "Create HTML Table"

@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

Super User
Super User

Re: Concat on "Create HTML Table"

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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Concat on "Create HTML Table"

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.Flow MyResult.PNGOutlook 2016 Online

 

Flow Friend.pngOutlook 2016 App

 

 

>