Collate the output of my html table to create summary message

(0) Share

Report

Posted on by craigmk1987

Hello,

I have been searching to try and find a solution to my issue.

I am trying to summarise the output of my data before it sends a message to teams/email etc.

My flow looks like:

Step 1.jpg Step 2.jpg Step 3.png Step 4.jpg

Once the html table is created, flow is sending an individual message for each condition that is true. I'd like to collate the information into one summary post.

Any help is much appreciated,

Craig

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@craigmk1987
Are you adding the HTML table step inside or outside the apply to each?

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report
Copy link

Link copied!

Flow is automatically inserting it into an "apply for each". I couldn't find a way to retrieve it from outside 🙂

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@craigmk1987

Because you are adding the display name inside the Create HTML and this is generated through the Loop
I am suggesting that you create an array inside your apply_to_each and set it with the values you like by constructing a Compose data operation in Json format:
{
"DisplayName": "Display Name Value",
"Property1": "Property 2 Value"
}
Append the output from the compose data operation to the array and then outside of the loop pass the array to the HTML table.

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report
Copy link

Link copied!

Thanks Mira,

I'll give it a go - I'm learning and teaching myself as I go 🐵

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report
Copy link

Link copied!

Mira,

When you say

"Append the output from the compose data operation to the array and then outside of the loop pass the array to the HTML table"

I'm not entirely sure I understand what you mean. I've tried the following:

What I don't understand is that when composing a operation I'm not sure how to retrieve the output which is why I've tried to replicate the "select" variable I had used previously.

When I add the table outside of the loop there is nothing that I can see that references something I can use (unless it's the current item?). If I try and use any of the "shift" connectors it creates a new apply to loop which will probably deliver the same result

Thank you in advance

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @craigmk1987
This is what i mean
Initialize array variable inside the loop, Construct JSON object and append to the array variable

Then construct the HTML table as below
If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mira,

This resolved the issue and delivered exactly what I wanted.

Thank you !

Was this reply helpful? Yes No