Slect the Planner task that is due the soonest in a specific bucket and then update the progress status

[philalethes]

Hello,

 

I am trying to build a flow that will select the Planner task that is due the soonest in a specific bucket and then update the progress status to in progress.

 

An added bonus would be the ability to email the person the task is assigned to so they know the status changed.

 

I am new to Flow, so I am at a loss where to even start.

 

Thank you in advance for your help!

[ChristianAbata]

hi @philalethes  you can follow my example

as you see you can get all tasks from planner and then you can compare to send and email if the date is some due date

[philalethes]

Hi @ChristianAbata ,

Thanks for the suggestion!

I am afraid it isn't quite getting at what I am trying to accomplish, though.

I already have the beginning of a Flow created that creates a new task in a specific bucket when another task is completed.  The next piece I am stuck on is figuring out how the Flow can find the next task that is due soonest in that specific bucket, changing its status to "in progress", and then emailing the person it is assigned to.

If it is easier to search for this task that is due soonest by part of a name, instead of by a bucket id, that would work for my set up as well.  My Flow already looks for a Title that includes "Mammo Task" which could be used for this next component as well.

Do you have any ideas on how to build a flow that selects the Planner task that is due the soonest in a specific bucket and then update the progress status?

Thanks!

---

Edit:

I have tried working on finding the soonest due date portion a bit and am not having luck.  It seems that creating an array variable may be a part of the solution, but I keep getting errors.  Any ideas?

[philalethes · Accepted solution]

I figured it out.  It took quite a while, but here is what worked for me:

I initialized an array variable, listed my tasks, and then ran an apply to each looking for the part of the name that identifies the tasks I am looking for and excludes completed tasks.

Then, I appended to that array the due date values with this formula:  

ticks(items('Apply_to_each')['dueDateTime'])

 

Then, I listed my tasks again and then ran an apply to each looking for the part of the name that identifies the tasks I am looking for, excludes completed tasks, and looked in the array for the minimum date that I wrote into the array in the previous step.

Note: I had to update the ticks formula to point at the current Apply to each 5 section.

ticks(items('Apply_to_each_5')['dueDateTime'])

min(variables('DateDue'))

  

Then, upon finding the matching min date, I simply updated the task and sent a message to the user identified in the task.  

 I hope this helps someone else, too!