Reminder Flow 2 days before due Date.

[SchednNedn]

Hello,

I want to build a Flow wich reminds my Co-Workers 2 days before the Due date. 

The way it works is that it first gets a Data from a Connector.
This Data will be created into a Excel File in my Sharepoint Document Library. 

In the Excel File there is a Row called 'Date', and i want that my Flow sends an Email 2 days before the Due Date .

This is what i did so far  

Conditions : 

formatDateTime(item()['Datum'],'dd-MM-yyyy')

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

This is my Excel Table : 

Containing alot of Rows and Tables, with specific Users and all. 

I tried to run the Flow but it keeps on running on forever. 

any Idea what i can do to make the Reminder working propely. 

It should run everyday at morning to remind all my Co Workers. 

Thanks alot in advance ! 🙂

[mobashee]

Dear partner,

The reason could be you have not converted the string.

when flow is reading the date from excel cell, it takeas a value as string like 

44381 which is 16-06-2021

To solve this i will initialize 3 variables like below

addDays('1899-12-31',int(variables('Strng2Int')),'yyyy-MM-dd')

Did I answer your question? Please consider to mark my post as a solution to help others.

Regards,

Mohamed Sanuj Basheer

[SchednNedn]

Hi @mobashee 

Thanks alot for the Reply. 

I tried your solution as follows my flow is looking like this right now : 

So first off in my Flow in need to Filter the Date Row because it contains Fields wich have Dates in it and Fields wich are empty. 

and I cant really Filter them in my Excel because the Excel will be created everyday from the Connector

So the first step i did Initialize the Variables as you said so. 
Then i List the Rows and Filter the Excel Row wich contains the Dates

But always getting this Error : 

So my Flow is lookin pretty Wild and im sure that i messed up something with the Flow, trying to do the reminder thing 2 days before the due date. 

Sorry im really a flow beginner in this regard .

Thanks alot for taking your time and reading my mess 

Bg

Scherwin