Power Automate Exchange

Hello I have a scheduled flow checking the state of a column into a sharepoint list.
I have more than 100 entries.
Only 15 (for example) have the state trigering an email.
So I receveing 15 emails indicating the state that I wanted to be informed.
But is that possible and how to do it, to receive only one email with the 15 lines ?

Thank you

------------------------------
Cyril B
------------------------------

Hi,
It sounds like you are looping through the SharePoint list items and are sending the emails from within that loop. Instead you will want to add those items with the matching state to an array. Then, once outside of the loop, you will want to create an HTML table with your array items and then add that HTML table to an email. This will allow you to send a single email with all 15 items.

Good luck,
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services
Atlanta
------------------------------

Original Message:
Sent: Mar 14, 2022 11:19 AM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

Hello I have a scheduled flow checking the state of a column into a sharepoint list.
I have more than 100 entries.
Only 15 (for example) have the state trigering an email.
So I receveing 15 emails indicating the state that I wanted to be informed.
But is that possible and how to do it, to receive only one email with the 15 lines ?

Thank you

------------------------------
Cyril B
------------------------------

THank you for the info Kimberly I will search in this direction.

If anyone have some example ..... :)

------------------------------
Cyril B
------------------------------

Original Message:
Sent: Mar 15, 2022 08:01 AM
From: Kimberly Piper
Subject: Merging into only one email state of differents sharepoint lines

Hi,
It sounds like you are looping through the SharePoint list items and are sending the emails from within that loop. Instead you will want to add those items with the matching state to an array. Then, once outside of the loop, you will want to create an HTML table with your array items and then add that HTML table to an email. This will allow you to send a single email with all 15 items.

Good luck,
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services
Atlanta

Original Message:
Sent: Mar 14, 2022 11:19 AM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

Hello I have a scheduled flow checking the state of a column into a sharepoint list.
I have more than 100 entries.
Only 15 (for example) have the state trigering an email.
So I receveing 15 emails indicating the state that I wanted to be informed.
But is that possible and how to do it, to receive only one email with the 15 lines ?

Thank you

------------------------------
Cyril B
------------------------------

You're welcome. Try this link to a video by Reza Dorrani: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/How-to-send-Formatted-HTML-Tables-in-Email-using-Power-Automate/td-p/1136887
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services

------------------------------

Original Message:
Sent: Mar 15, 2022 12:17 PM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

THank you for the info Kimberly I will search in this direction.

If anyone have some example ..... :)

------------------------------
Cyril B

Original Message:
Sent: Mar 15, 2022 08:01 AM
From: Kimberly Piper
Subject: Merging into only one email state of differents sharepoint lines

Hi,
It sounds like you are looping through the SharePoint list items and are sending the emails from within that loop. Instead you will want to add those items with the matching state to an array. Then, once outside of the loop, you will want to create an HTML table with your array items and then add that HTML table to an email. This will allow you to send a single email with all 15 items.

Good luck,
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services
Atlanta

Original Message:
Sent: Mar 14, 2022 11:19 AM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

Hello I have a scheduled flow checking the state of a column into a sharepoint list.
I have more than 100 entries.
Only 15 (for example) have the state trigering an email.
So I receveing 15 emails indicating the state that I wanted to be informed.
But is that possible and how to do it, to receive only one email with the 15 lines ?

Thank you

------------------------------
Cyril B
------------------------------

Sooooo Thank Youuuuuuuuuuuuuuuuuu
You made my day sincerily !

------------------------------
Cyril B
------------------------------

Original Message:
Sent: Mar 15, 2022 12:39 PM
From: Kimberly Piper
Subject: Merging into only one email state of differents sharepoint lines

You're welcome. Try this link to a video by Reza Dorrani: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/How-to-send-Formatted-HTML-Tables-in-Email-using-Power-Automate/td-p/1136887
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services


Original Message:
Sent: Mar 15, 2022 12:17 PM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

THank you for the info Kimberly I will search in this direction.

If anyone have some example ..... :)

------------------------------
Cyril B

Original Message:
Sent: Mar 15, 2022 08:01 AM
From: Kimberly Piper
Subject: Merging into only one email state of differents sharepoint lines

Hi,
It sounds like you are looping through the SharePoint list items and are sending the emails from within that loop. Instead you will want to add those items with the matching state to an array. Then, once outside of the loop, you will want to create an HTML table with your array items and then add that HTML table to an email. This will allow you to send a single email with all 15 items.

Good luck,
Kim

------------------------------
Kimberly Piper
Manager, BI, Data & Information Services
Atlanta

Original Message:
Sent: Mar 14, 2022 11:19 AM
From: Cyril B
Subject: Merging into only one email state of differents sharepoint lines

Hello I have a scheduled flow checking the state of a column into a sharepoint list.
I have more than 100 entries.
Only 15 (for example) have the state trigering an email.
So I receveing 15 emails indicating the state that I wanted to be informed.
But is that possible and how to do it, to receive only one email with the 15 lines ?

Thank you

------------------------------
Cyril B
------------------------------