web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / send an email notifica...
Power Automate
Unanswered

send an email notification

(0) ShareShare
ReportReport
Posted on by 10

Below is a list of columns I have created for contracts expiring within 3 days. Whenever I try to add the Owner column to the DL for the "Send an email" option, I get an error. Owners who have contracts with due dates within 3 business days should be notified by email

sahmed786_0-1710019951095.png

sahmed786_1-1710020027407.png

 

This is how my flow looks: 

sahmed786_2-1710020309615.png

 

OwnerContract NameVendorAmountExpiration Date
     
     
Categories:
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @sahmed786 

     

    One thing to not here is your Loop Name is For Each 1 not For Each. So check whether any dynamic content/expression are referenced by For_Each , if yes then replace with For_Each_1

     

    If i explain with example- let's say json structure behind the ReviewerName column is shown as items('Apply_to_Each_2')?['ReviewerName']

    Nived_Nambiar_0-1710044908107.png

     

    So here the name of loop is Apply to each 2. 

     

    So check in the send email whether anything has been referenced simmilarly if yes > just change accordingly.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

  • sahmed786 Profile Picture
    10 on at

    Can you please explain with an example. I am not able to follow

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @sahmed786 

     

    to give you detailed answer. let's take the same example used in above response.

     

    Consider i am using get items to get list of all items used in a list.

    Now i am iterating through list items using an apply to each loop with loop name as Apply to each 2  like below

    Nived_Nambiar_0-1710080580051.png

     

    Now if you take any dynamic content for column value under that  items list like Reviewer Name column. If you hover over that just like i did above- you will see a json structure like items('Apply_to_each_2')?['ReviewerName'] , here it means items('Apply_to_each_2') represent the current iterating item. and we are getting ReviewerName property value from it.

    so the part of expression items('Apply_to_each_2') have the loop name in which it is present but spaces are replaced with underscores (spaces should be consider as _ while writing action names). So if the expression was something like this in same loop - items('Apply_to_each')?['ReviewerName'] , Then it mean loop name should be Apply to each instead of Apply to each 2, But it is not , so for such cases we would get the error like as you got.

    Nived_Nambiar_1-1710080912474.png

     

    So check the same for your case in send email actions- check the expression behind the dynamic content and expression written and see whether there is any expression which have For each instead of For each 1 as your loop name is For each 1.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard