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

Community site session details

Session Id : 97yZnUFyJyeBbpAXAWjUli
Power Platform Community / Forums / Power Automate - Building Flows / Delay Until - Add 7 da...
Power Automate - Building Flows
Unanswered

Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

Like (0) ShareShare
ReportReport
Posted on 27 Jan 2020 11:52:18 by TomAshcroft 16

Hi,

I'm looking to delay an email notification for 7 & 28 days.

 

I had this working using:-

addDays(triggerBody()?['Created'],7)

 

But this just delays the email for 7 days after the item has been created in the list, I'd like it to delay 7 or 28 days according to the 'Date Sent' column.

I.e. NEW job added to sharepoint list as below:-

JobNo      :  001 

Job Created: 29/12/2019

Date Sent :  01/01/2020

 

Flow:

Sends a follow up email on: 08/01/2020

 

Would anyone be able to assist with this? I'm not sure but I may have possibly posted this in the incorrect forum

 

 

 

I have the same question (0)
  • TomAshcroft Profile Picture
    TomAshcroft 16 on 17 Feb 2020 at 12:32:02
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

    Ok this looks like its working!

     

    Multiple failed flows (with nothing in date sent field) and multiple flows running (with date sent filled in)

     

    If possible I'll keep this open for  a little while longer to make sure!

     

    Thanks for all your help.

  • v-bacao-msft Profile Picture
    v-bacao-msft on 17 Feb 2020 at 07:12:37
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

     

    Hi @TomAshcroft ,

     

    You can configure Flow according to the screenshot I provided earlier. First use Compose to output the value of the Date Sent field, and check whether the output of Compose in the Flow run history is empty.

     

    I speculate that the Data Sent field in the newly created item is empty, so this problem occurs. Please check it and try again.

     

    Best Regards,

  • TomAshcroft Profile Picture
    TomAshcroft 16 on 29 Jan 2020 at 14:27:02
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

    Hi

     

    I have tried this but I'm experiencing an issue on the 'Delay Until' expression

     

    The error I get is as follows:-

     

    InvalidTemplate. Unable to process template language expressions in action 'Delay_until' inputs at line '1' and column '2762': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.
     
    Could you perhaps assist? Thankyou.
  • TomAshcroft Profile Picture
    TomAshcroft 16 on 28 Jan 2020 at 12:00:31
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

    Thankyou for this.

    Will try it and keep you posted.

     

    Aside from this, rather than making a new post perhaps you can help with my next condition issue on a separate flow.

     

    For this one, I have a Yes/No checkbox in a sharepoint list, If Yes - Please send an email, If no - do nothing.

     

    flow if yes.png

     

    Problem is, I do not get an email and also get the following error from 'Send an email notification'

     

    "ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_notification_(V3)' skipped: the branching condition for this action is not satisfied."
     
    So I'm assuming me entering 'True' in the above condition is incorrect. I've also tried Yes/No whilst changing the condition

     

     

     

     

  • v-bacao-msft Profile Picture
    v-bacao-msft on 28 Jan 2020 at 07:10:11
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

     

    Hi @TomAshcroft ,

     

    Please refer to the following method to configure Flow:

    72.PNG

    Expression reference:

    addDays(outputs('Compose'),7,'yyyy-MM-ddTHH:mm:ssZ')

     

    Best Regards,

  • TomAshcroft Profile Picture
    TomAshcroft 16 on 27 Jan 2020 at 13:58:14
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

    Hi Clarlon,

    Thankyou for your prompt response.

    In this instance there are no'IF' statements, as its not an either or its a simple:-

     

    -  Delay email for 'DateSent (01/01/2020)' + 7 days

     

    The 7 day and 28 follow ups are for two different reasons, and therefore I planned to make these separate flows, so I figured If I can get one working (7 day) I can replicate for 28 days.

     

     

     
     

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 27 Jan 2020 at 13:31:38
    Re: Delay Until - Add 7 days to 'Date Sent' column from a sharepoint list

    @TomAshcroft But how do you know from where to switch whats the if condition?

     

    what I will suggest is long but suitable, make a list if which date you want to be the condition and make an if else, for example.

     

    using the Or if "01-01" = var1 else "02-02" else "03-03" and so on, if one of the case accept do the 7 days delay if none match do the 28 days.

    image.png

     

    it actually depends on what is your condition, but I hope it helps.

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans