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.

View solution in original post

@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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (19,090)