Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Merging into only one email state of differents sharepoint lines

    Silver Contributor
    Posted Mar 14, 2022 11:20 AM
    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
    ------------------------------


  • 2.  RE: Merging into only one email state of differents sharepoint lines

    Posted Mar 15, 2022 08:01 AM
    Edited by Kimberly Piper Mar 15, 2022 10:25 AM
    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
    ------------------------------



  • 3.  RE: Merging into only one email state of differents sharepoint lines

    Silver Contributor
    Posted Mar 15, 2022 12:18 PM
    THank you for the info Kimberly I will search in this direction.

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

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



  • 4.  RE: Merging into only one email state of differents sharepoint lines

    Posted Mar 15, 2022 12:40 PM
    Edited by Kimberly Piper Mar 15, 2022 01:26 PM
    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

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



  • 5.  RE: Merging into only one email state of differents sharepoint lines

    Silver Contributor
    Posted Mar 17, 2022 02:21 AM
    Sooooo Thank Youuuuuuuuuuuuuuuuuu
    You made my day sincerily !

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