Answered

Help with adddays

(0) Share

Report

Posted on by SanchezITM

153

Hi guys I have a little problem, I need to create a periodic work that creates a Sharepoint list element the 24 of every month, and then send the first reminder 5 days later and the second reminder 5 days later again.

I try with addays(utcnow(), 5 'yyyy-MM-dd') with adddays (Creado(), 5 'yyyy-MM-dd') but didnt work.

Here is my config,

any advice?

Thank you !

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!
Hi @SanchezCSG,

What didn't work exactly? Looking at your screenshots, your Recurrence (Periodicidad) is set to start every day. If you want to start only on the 24th of every month, you should change the Frequency (Frecuencia) to Month (Mes); your Time zone and Start time are fine.
As for the Delay until (Retraso hasta), you are using AddHours() instead of AddDays(). Also, when you build the expression with the AddDays() function, it's better to use the Expression tab in the Dynamoc content area to build the expression.

In my examples below, I used 2 Delay until (Retraso hasta) steps: one for the first 5 days and for the other 5 days. Please let me know if you have any questions.

addDays(body('Create_item')?['Created'],5)
addDays(body('Create_item')?['Created'],10)

Regards,
Fausto Capellan, Jr

Was this reply helpful? Yes No
SanchezITM 153 on at

Like (0)

Report
Copy link

Link copied!

Hi @faustocapellanj, thank you, im gonna try your configuratión, in my screenshot use days and hours/minutes for testing, the real Flow use month/days

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @SanchezCSG,

Could you please share a bit more about your error message?

Do you want to write the WDL expression within your "Delay Until" aciton?

I think there is something wrong with the formula within your "Delay Until" action. If you want to write the WDL expression within "Delay Until" action, please take a try with the following steps:

Select Timestamp input box within your "Delay Until" action.

Within the right panel, select Expression tab.

Type your expression within formula box.

Click "OK" button.

Image reference:

I have made a test on my side and the "Delay Until" action works well. My flow's configuration as below:

Within "Delay Until" action, type the following formula:

addDays(body('Create_item')?['Created'],5,'yyyy-MM-ddT00:00:00Z')

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
shaboo 65 on at

Like (0)

Report
Copy link

Link copied!

Next Day
use this expression

@{addDays(utcNow(),1,'dd-MMMM-yyyy')}

Return in - 11-June-2021

@{addDays(utcNow(),1,'dd-MM-yyyy')}

Return in - 11-06-2021

Was this reply helpful? Yes No