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 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 blogPower Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
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 blogPower 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 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 blogPower Automate Video Tutorials

View solution in original post

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (48,513)