cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

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
Highlighted
Super User III
Super User III

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
Highlighted

Hi @abm 

Thanks for the reply.

I am a little confused as to what to do.

 

I am not sure about the filter query...

 

 

Highlighted
Super User III
Super User III

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

Highlighted

Thank you @abm 

 

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

 

I really appreciate it.

 

Cheers

 

Newbie2019

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,614)