Answered

Allocate a planner urgency based on calculation between dates from sharepoint list

(0) Share

Report

Posted on by chris_scott

Hi,

I am new to Power Automate (Power Apps in general). I am making a simple submission form app that feeds into a SharePoint list. This will then feed into Planner using Power Automate - I have got this nailed down and it sorts it between a new request or an edit request to the right buckets in Planner.

What I would like to do is get Power Automate to calculate the days between 'Created' and 'When do you need this by' on the SharePoint list. I have seen some formulas hanging about on here but I can't work them out or how they would relate to what I am doing, with little context.

I know I need to have a compose step in before create new task, and then in the priority section of create new task, a formula. I just can't figure it out.

Is anyone able to help me please?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @chris_scott ,

Do you want to calculate days between 'Created' and 'When do you need this by' for each item in SP list?

Here is an expression for your reference.

div(sub(ticks('2024-04-3'),ticks('2024-04-01')),864000000000)

Best regards,

Rimmon

Was this reply helpful? Yes No
chris_scott 56 on at

Like (0)

Report
Copy link

Link copied!

Yes I do. Would I replace the dates in the ' ' with a reference to the SharePoint column? I am outstandingly new to this so please treat me as stupid. What is the number long 8 number for?

The resulting number, I would like power automate to then set the priority under create task, based on this number. e.g if it is 5 days I would like it to set the priority to urgent. I know that planner uses numbers to set priority.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @chris_scott ,

Yeah, you can replace the date in the expression with column's dynamic content.

If you calculate the number of days in 'Apply to each' of 'get items', you can put the calculation result in the condition to determine whether it is less than five days, and if so, then set the relevant task to urgent.

Best regards,

Rimmon

Was this reply helpful? Yes No