Apply to Each - Select, Create HTML Table, Compose Help

(0) Share

Report

Posted on by WC-KSTILL

117

So I have a SharePoint List that has a column with ID's to a sub list.

That column contains ID's to the items.

I am trying to get each of those items from the sub list, select specific columns, and create an html table. To then send an email.

I got everything working but I am wondering if I am doing this right and if its possible for me to get the multiple table names removed somehow.

Here is the entire flow and the email. As you can see the method I am using creates two tables on top of each other instead of 1 single table. I thought about using replace function to remove some of the HTML but that would also replace the first part since its the exact same.

This is how the email arrives:

I want it to look like this instead: (if possible)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

WC-KSTILL 117 on at

Like (0)

Report

I was up all night thinking of a way to achieve this... going to test a few more things. If anybody has any idea's please let me know

Was this reply helpful? Yes No
Verified answer

WC-KSTILL 117 on at

Like (1)

Report

I ended up finding a way.

In select I changed the column names to A B C D E.

Then I created two variables.

Used replace function to replace
</table><table><thead><tr><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody>
from The Compose

Then used replace to remove
<table><thead><tr><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody>
from the First Variable

Was this reply helpful? Yes No
askondo on at

Like (0)

Report

@WC-KSTILL Thanks for the feedback on the solution.

Was this reply helpful? Yes No