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 ! 🙂
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
Did I answer your question? Please consider to mark my post as a solution to help others.
Regards,
Mohamed Sanuj Basheer
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
26 | |
23 | |
14 | |
10 |
User | Count |
---|---|
64 | |
55 | |
29 | |
28 | |
24 |