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:
For the create HTML table I have:
On triggering the flow, I get multiple emails with multiple duplicates in the table rather than a single table / email.
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
Solved! Go to Solution.
Hi,
Try this
Attendance eq 0 and House eq 'McCormack'
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @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.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @abm
Thanks for the reply.
I am a little confused as to what to do.
I am not sure about the filter query...
Hi,
Try this
Attendance eq 0 and House eq 'McCormack'
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThank 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.
Thanks In advance,
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
54 | |
47 | |
36 | |
25 |