Skip to main content

Notifications

Power Automate - General Discussion
Answered

Send an email with list of pending items

(0) ShareShare
ReportReport
Posted on by 74

Hi Experts,

 

Good day to you, I'm having below flow, which to get the Status equal to Pending of each Items and combine them then send an email. What i'm trying to achieve is if Status not equal to Pending then don't send anything.

 

The problem i have are:

  • if i put Send an email inside a loop, it will return like below screenshot

Email.png

  • If i put Send an email outside the loop then it will send a blank email when Status is not equal to pending.

Any help would be so much appreciated. Thank you !

 

1.jpg

  • Verified answer
    powercorner Profile Picture
    powercorner 477 on at
    Re: Send an email with list of pending items

    Hello @AnPhamEFL ,

     

    you should do it differently. Set the "pendingList" variable to an Array.

     

    In the loop add each pending ID to this array (use the "append to array variable" action)

     

    Then after the loop use a condition to check the length of your array with the expression Len(pendingList)

    If the length is bigger then 0 then send the mail. In order to translate the array to a string you can use another expression "join" -> eg. join(pendingList,' <br>') inside the mail body. 

     

    Et voila!

     

    Tell me if it worked for you 🙂

    With regards
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard