The logic seems straight forward - Due Date = Today, then send email reminder. But I can't seem to find the right steps to create it.
Hi @farinadeng,
Could you please share more details about where are the tasks created in?
I would offer you the workaround when the tasks are created in the outlook tasks, the screenshot of the flow as below:
The expression in the Condition as below:
@equals(formatDateTime(items('Apply_to_each')?['DueDateTime']?['DateTime'], 'yyyy/MM/dd'), formatDateTime(utcNow(), 'yyyy/MM/dd'))
The flow would run successfully as below:
Best regrads,
Alice
I agree with @v-yuazh-msft but would like to add that there is a limit of 5000 iterations for an Apply to Each loop unless you have one of the premium Flow plans. It is conceivable that a user might have more than 5000 saved tasks. I don'tt see a way to filter the items returned from List All Tasks.
@MarkStokes: I was unaware that list all tasks had a filter option. Can you point to where I can find that?
Hi Alice,
Thank you for your reply. The tasks are actually created in a SharePoint list, sorry I missed adding that part.
Hi Mark,
You are correct, it is a SharePoint list. Sorry I missed adding that part to the question!
Thanks Mark. What would the flow look like?
Sure.
First up is my simple Task List in SharePoint
Here is the full flow.
The Trigger is a Recurrance trigger to run at 3pm each day.
First thing we need to do is get a string representation of the current day in a UTC format. Use a Compose action with the following expression.
utcNow('yyyy-MM-dd')
Then you perform your SharePoint Get Items action. In this case you can pass in a Filter Query as shown below. The Output is the value generated from your Compose action. My first reply had an error. It needs to be wraped in '' (single quotes) not "" (double quotes) otherwise it will fail.
When we have ONLY the items with a due date of today then we can iterate over them and create a friendly HTML email to the Assigned To user and giving them a link directly to the SharePoint list item.
I hope this helps.
Thanks for laying it out for me Mark! I keep getting a an error at the Get Items stage:
Hey, @farinadeng!
Thank you for posting on the Flow Community Forum! It appears as though @v-yuazh-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!
Thank you for being an active member of the Flow Community!
-Gabriel
Flow Community Manager
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
33 | |
16 | |
15 | |
12 | |
9 |
User | Count |
---|---|
39 | |
21 | |
19 | |
10 | |
9 |