Help in creating reminder

[Amrmac]

Hi ,

I have a flow for reminder but I was asking if I want to get 2 reminder, one fixed reminder before the due date with one day " Already done " . The other reminder i want it to be based on the notifcation period column as the screen shoot .

Any help please ?

[GeorgiosG]

Hi @Amrmac 

I assume you have a scheduled Flow. In that case you can use a condition in a parallel branch which checks if Today is greater than the DueDate.

This can be achieved with the expression ticks():

ticks(utcNow()) 

ticks(triggerOutputs()?['body/DueDate']) 

What exactly do you mean with Notification Period ? Is it something like 3 days before due date or something ?

[Amrmac]

I mean I will create a new item and there is a notification period column its says how many days before the due date I should get reminder notification email  . every item had its notification period .

[GeorgiosG]

OK understood, you can use addDays in order to subtract the Period Days from your DueDate. 

For subtracting you need to use addDays: https://powerusers.microsoft.com/t5/Building-Flows/Need-to-subtract-days-from-one-date-field-with-re...

try to insert the 'minus' manually. 

addDays(triggerOutputs()?['body/DueDate'],-triggerOutputs()?['body/Period'])

Is the period column a numeric column or a text column? If it is a string column don't forget to convert.

addDays(triggerOutputs()?['body/DueDate'],-int(triggerOutputs()?['body/Period']))

[Amrmac]

I need to to have 2 reminders : 

1-  before the due date by one day ( Already created this flow )

2- In a costume days for each item " from notification period column " . 
Do you thing its better to have 2 flows or keep both in one flow . I prefer to make it separate flows .
Can you please help me with the full steps . Sorry for bothering you .

[GeorgiosG]

I would go for one Flow and work with a parallel branch.

The left one ist your first flow / before due date and the right one is x days before (you can achieve this with addDays()) 

Booth Branches will have these different conditions.

[Amrmac]

THis is my current flow :

[GeorgiosG]

Right after get items you can add a parallel branch. 

From here try to create in each branch a condition like in the previous image posted by me.

You can delete your apply to each loop, it will automatically come and wrap around your mail action.

[Amrmac]

Sorry Georgios . I'm new in Power Automate . Here is what i did as you mentioned . Can you write for me the expression i should use .

[GeorgiosG]

I will try 😉 

left branch 

ticks(addDays(outputs('Get_items')?['body/Due%20Date'],-1)) 

is equal

ticks(utcNow())

right branch

ticks(addDays(outputs('Get_items')?['body/Due%20Date'],-outputs('Get_items')?['body/Notification%20Period'])) 

is equal

ticks(utcNow())

maybe you need to remove the “%20” depending how your internal field name of the SharePoint column is.

[Amrmac]

Not working . This part :

right branch

ticks(addDays(outputs('Get_items')?['body/Due%20Date'],-outputs('Get_items')?['body/Notification%20Period'])) 

gives error even if removed 20% to be like the field name .

[GeorgiosG]

Is the Notification column a single line of text ? 

if so : ticks(addDays(outputs('Get_items')?['body/Due%20Date'],-int(outputs('Get_items')?['body/Notification%20Period'])))

can you provide the error message 

[Amrmac]

he Notification column is a numbers type .

[GeorgiosG]

Tray storing the output of the Notification in an earlier step into a  integer Variable with the Initialize Variable.

replace the output with the variable 

ticks(addDays(outputs('Get_items')?['body/Due%20Date'],-variables(‘YourVariableName’)))