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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email the owner of a S...
Power Automate
Unanswered

Email the owner of a SharePoint List item when the item completion date is 7 days from today

(0) ShareShare
ReportReport
Posted on by 6

Hi all,

 

I'm trying to build a flow that will trigger an email through Outlook to the Owner of an item based on the following criteria:

1. Status DOES NOT EQUAL Completed

2. Completion Date EQUALS Today+7 days

Screenshot of the flow is shown below.

Mattbotting13_0-1702894840582.png

Below are the relevant columns from the SharePoint list I'm trying to use. I want to email the "Owner", based on the Completion Date and the Status:

Mattbotting13_0-1702895352998.png

 

 

When I test the flow, I cannot get beyond "Foreach". Any suggestions for why this isn't working and how I can fix the flow?

 

Thanks,

Matt

Categories:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    Hi Matt,

     

    Could you pls share the screenshot of the condition action? You could directly use filter query in Get items to filter the required data.

     

    Thanks

  • MB-07051533-0 Profile Picture
    6 on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    Yes, here is the condition action:

     

    Mattbotting13_0-1702895448314.png

    Thanks,

    Matt

  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    I could not figure out the expressions, but you could double check.

     

    For first part of the condition, pls check if both operands are compatible & are compared with same format for e.g. yyyy-MM-dd:

    Left operand:

    formatDateTime(items('Foreach')?['fieldName'],'yyyy-MM-dd')

    Pls replace fieldname with actual column name in SharePoint list.

     

    Right operand:

    addDays(utcNow(),7,'yyyy-MM-dd')

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • MB-07051533-0 Profile Picture
    6 on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    Hi Manish,

     

    No luck on this front still, I've done as you requested and changed the conditions as follows:

     

    Left - 

    formatDateTime(items('Foreach')?['CompletionDate'],'dd-MM-yyyy')
     
    Right - 
    addDays(utcNow(),7,'dd-MM-yyyy')
     
    This matches the format in the SharePoint list I'm trying to use.
     
    Thanks,
    Matt
  • grantjenkins Profile Picture
    11,063 Moderator on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    I would use the following expression directly in the Filter Query in your Get Items action. That way you don't need the Condition within the Apply to each as it will only return the items you want to send an email for. You can just copy/paste the below expression directly into the Filter Query.

    Status ne 'Completed' and CompletionDate ge '@{addDays(utcNow(), 7, 'yyyy-MM-dd')}' and CompletionDate lt '@{addDays(utcNow(), 8, 'yyyy-MM-dd')}'

    grantjenkins_0-1702899872018.png

  • MB-07051533-0 Profile Picture
    6 on at
    Re: Email the owner of a SharePoint List item when the item completion date is 7 days from today

    Thanks for this Grant. Wat is the value in the Apply to each action? I can't replicate Value as it appears in your screenshot?

     

    Mattbotting13_0-1702903895715.png

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard