cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Newbie2019
Resolver I
Resolver I

Separate emails when creating a HTML Table from SharePoint list with 2 conditions

Hi All,

I am trying to send an email with a summary HTML table within it.

 

When items are retrieved from my SharePoint list, I have 2 conditions which they must have:

 

1 - Attendance column is equal to false

2 - House is equal to McCormack

 

I currently have:

 

email 1.JPG

 

For the create HTML table I have:

 

email 2.JPG

 

On triggering the flow, I get multiple emails with multiple duplicates in the table rather than a single table / email.

 

Email 3.JPGEmail 4.JPG

 

I don't understand why there are multiple tables and why I am getting duplicates.

 

The number of duplicates, 5 , happens to be the number of total entries in the SharePoint list before applying the condition.

 

I am guessing that it may have something to do with the apply to each, but I'm not sure how to get around this.

 

Any suggestions or advice would be appreciated.

 

Cheers

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi,

 

Try this

 

Attendance eq 0 and House eq 'McCormack'

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
Super User
Super User

Hi @Newbie2019 

 

Extend your query under the Get items Filter Query. You don't need a loop to extract all the details if you using Create HTML table. Also you can do the expression replace under the HTML table element.

 

Try the following steps.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @abm 

Thanks for the reply.

I am a little confused as to what to do.

 

I am not sure about the filter query...

 

 

abm
Super User
Super User

Hi,

 

Try this

 

Attendance eq 0 and House eq 'McCormack'

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Thank you @abm 

 

You solved the problem. Thank you so much for your initial replay and prompt response.

 

I really appreciate it.

 

Cheers

 

Newbie2019

Hallo @abm ,

 

I kind of have a similar problem. I have 3 sharepoint list :

- List 1 Make a offer (list collects how many offers)

- List 2 Offer accepted or not (How many accepeted and rejected)

- List 3 If offer accepted then send confimation email (Bascially completed offers list)

 

Have made flows for all these 3 list to update automatically

 

What i want is , to make a condition 

Condition 1 : Custumor ID number of List 1 =List 2 (NOT SharePoint ID, customer ID is seperate)

Condition 2 : Customer Accepted offer

 

When these condition satisfies then send email with all data of the particular customer from List 1 and List 2.

 

But when i tried it does not work. PLease let me knwo if there is a better solution as soon as possible.

 

Please have a look and let me know.

image.png

 

Thanks In advance,

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.

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (4,059)