Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Flow Does Not Send Emails, But Indicates "Success"

(0) ShareShare
ReportReport
Posted on by 379

My flow runs smoothly but does not send the notification to all who apply as it is supposed to. I'm going to share my flow step by step and the list where the information is. I really appreciate any suggestions, examples, or comments to help me find the error.  

1. 

lcdelgado_0-1712239266029.png

2. 

lcdelgado_1-1712239348596.png

3. 

lcdelgado_2-1712239491643.png

4.

lcdelgado_3-1712239601189.png

Today + x days = 

addDays(utcnow(), int(outputs('Days_to_remind_me_in')), 'yyyy-MM-dd')
 
x Days + 30 = 
addDays(outputs('Today_+_x_days'),30,'yyyy-MM-dd')
 
5.
 lcdelgado_4-1712239841266.png

6. 

lcdelgado_5-1712239966025.png

Filter Query = 

concat(concat('ExpirationDate',' ge ''''',outputs('Today_+_x_days')),'''',' and ', concat('ExpirationDate',' lt ','''', outputs('x_Days_+_30'),''''))
 
7.
 lcdelgado_6-1712240067296.png

8. 

lcdelgado_7-1712240152018.png

9. 

lcdelgado_8-1712240226523.png

10. 

lcdelgado_9-1712240297873.png

11. 

lcdelgado_10-1712240393287.png

The List: 

lcdelgado_11-1712240582376.png

 

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Hi @lcdelgado 

     

    The steps which i have displayed here after you extracted the items from sharepoint by applying filter query. So steps before that remains same. I have used initialized variable TableRows for demo flow design just to make sure it is there.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Nived, question... are you moving the initialized variable into the Scope?

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Ok! I will let you know how it goes, Thank You 😊

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Hi @lcdelgado 

     

    Try like this 

     

    Nived_Nambiar_0-1712690389093.png

     

    Nived_Nambiar_1-1712690416351.png

     

    Nived_Nambiar_2-1712690449100.png

     

    Nived_Nambiar_3-1712690477623.png

     

    Nived_Nambiar_4-1712690520408.png

     

    Nived_Nambiar_5-1712690531594.png

     

     

    So overall logic is 

     

    we get list of all asisgnee emails from get items and then loop through distinct values of it and after that we filter the list items based on asisgnee email and then we will append email body and send email.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Yes!

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Hi @lcdelgado 

     

    so every assignee you have to group the details and sent it right ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Hi Nived! yes, I can resolve it, what I can't resolve is the email is sending all documents to everyone on the list instead of the documents that belong to the assignee.

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Hi @lcdelgado 

     

    sorry for late response !

    did the issue resolved?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Well I was validated by part and I found the second apply to each wasn't including all the persons, just the last one, so I just moved the send email inside the apply to each 2 loop, and now it includes everyone. I think I moved the send email outside to send individually instead by group.

    lcdelgado_0-1712605852399.png

     

     

  • lcdelgado Profile Picture
    lcdelgado 379 on at
    Re: Flow Does Not Send Emails, But Indicates "Success"

    Thank you very much, that's what I'm doing now step by step, but I can't understand why. 🙁 because it was working well for months and today is not as supposed 

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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard