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

[TomAshcroft]

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

[TomAshcroft]

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

[Anonymous]

@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.

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

[TomAshcroft]

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.

[v-bacao-msft]

Hi @TomAshcroft ,

Please refer to the following method to configure Flow:

Expression reference:

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

Best Regards,

[TomAshcroft]

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.

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

[TomAshcroft]

Hi v-bacao-msft

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.

[v-bacao-msft]

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]

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.