cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tea_Programmer
Advocate I
Advocate I

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 tableCreate html tableResultResultGoalGoal

1 ACCEPTED SOLUTION

Accepted Solutions

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



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

7 REPLIES 7
Tom_Slosse
Memorable Member
Memorable Member

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



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.

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.
 

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.

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



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

 

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

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.

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 OnlineOutlook 2016 Online

 

Outlook 2016 AppOutlook 2016 App

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,383)