Unanswered

My Flow Is Sending an Email for Each Row in HTML Table

(0) Share

Report

Posted on by DavidShaw84

Hi All,

First post and a fairly novice PA user (first time using it to be honest). I want to create a flow where i can extract data from a sharepoint list and send it on an email at the end of each day, only where data has been added to the list.

I created a flow that does this and that also updates the list afterwards however i seem to be mis understanding where to place the condition. this is meaning that my flow is sending an email per for each row within the html table, when i just want 1 email.

Here is my flow architecture.

I have the same question (0)

All responses (4)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (1)

Report

Re: My Flow Is Sending an Email for Each Row in HTML Table

Hi there,

Yes, right now, since you are pointing at the "Get Items" for the condition, it is going to do it for each instance of the "NOT" it finds. Since it's a Get Items, it assumes there is always more than one.

This isn't necessarily incorrect for your purpose, but, you will want to drag your email outside of your Apply to Each 2 - that way, after all the items have been looped through, it will send an email.

Something to think about, though: Do you only want to collect the instances where NOT = No? It seems like yes. If so, you can build a string or array variable to keep the information you need. You'd initialize that at the top of your flow, and then use the "Append to String (or array) variable" inside of each loop.

At the end, you'd use that variable - which would now contain information from all valid entries - in your email at the bottom.

Was this reply helpful? Yes No
DavidShaw84 5 on at

Like (0)

Report

Re: My Flow Is Sending an Email for Each Row in HTML Table

Thank you! I think I solved it by removing the condition completely as i already had a filter applied in the Get Items.

Was this reply helpful? Yes No
DavidShaw84 5 on at

Like (0)

Report

Re: My Flow Is Sending an Email for Each Row in HTML Table

I was wrong, by removing the condition it meant that an email was being sent when no data had been collected and showing in the email as blank. So in short, I only want it to send an email where NOT=No.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

Re: My Flow Is Sending an Email for Each Row in HTML Table

All good, there's an even better way to do this that'll make it easier for you.

In your "Get Items" action, expand the advanced options so you can see filter query, and add the following:

NOT eq 'No'

(I think that says NOT in your values .. maybe its NJIT? NUIT? Hard to tell...whatever that word is, it goes where "NOT" is)

Now it won't pull back anything unless that's equal to "No". Now, you still need a condition, but it's only to say if length(GetItems) is greater than 0 - if it is, then, great. You've got some items and you need to email about them. If not, then it can go down the "No" path and terminate the flow.

Let me know if that helps...

Was this reply helpful? Yes No