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

 

 

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 55 members 4,333 guests
Please welcome our newest community members: