how many days?

(0) Share

Report

Posted on by javierz

186

Spoiler (Highlight to read)

your help please

I created a flow, with 9 cases
NOT STARTED
REJECTED
COMPLETED
IN PROCESS PO DISPATCH
...
sharepoint scenario

now they ask me to calculate how many days pass between each case
Example days between NOT STARTED and IN PROCESS PO DISPATCH

in the flow, within each case, I have updated the list to record the modification date

but I create a loop, because the flow is executed again

try to send the modification dates to another sharepoint list, but the id generates problems

any ideas?

https://drive.google.com/file/d/1Frfxu1S7ryRapv9x4y9Jv62ZJI4vPm97/view?usp=sharing

Image

thank you

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RobElliott 10,525 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of doing this with Flow you could add a calculated column to your SharePoint list to calculate the difference between the dates, e.g Process PO despatch minus NotStarted.
Rob
Los Gallardos

Was this reply helpful? Yes No
javierz 186 on at

Like
a
(0)

Report
Copy link

Link copied!

this option already try

Columns calculates works fine, but users review the documents and go to the list to change it's state
the flow is activated and adds the date of the modification, in another column
as seen in the attached image 2
at this moment a loop is created
I'm trying another option by removing the swictch and adding conditions for each state and then another condition that validates if the field where the date of the modification is empty

Capture 2

https://drive.google.com/file/d/1K7DKAe0g6PwmMgB7r-KNY03cD1LxgA9F/view?usp=sharing

capture 3
https://drive.google.com/file/d/1WjBaeSu0nj55gWpZdINykrGADRnndyK5/view?usp=sharing

what do you think?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @javierz ,

Could you share more details on your scenario?

I guess that you have a Choice column for the Status, and a date column for the Modified date time.

Do you want to calculate the days between the modified date of two status? Besides, it looks like the modified date time column will be updated whenever an item is modified.

If so, please check if flow likes below will be a reference for you.

After the trigger “When an item is created or modified”, get item, then use a Compose to get the DueDate.

Then update item action to update the DueDate with the following function:

Adddays(utcnow(),7,’yyyy-MM-dd’)

Then Get item 2, and Compose 2 to get the current DueDate.

Add Compose 3 with the following function to get days between two dates.

div(sub(ticks(outputs('Compose_2')),ticks(outputs('Compose'))),864000000000)

Note: When you are using the trigger When an item is created or modified and Update item on the same list within a flow, an infinite loop will be caused.

Best regards,

Mabel

Was this reply helpful? Yes No
javierz 186 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello
Thanks for the help
a little more information, the idea is to calculate the dates between the status jumps
I have 8 jumps, and you want to see how many days each user takes to do the process (image 1)
I am testing with the flow of image 2, sending the dates to excel and using = DATEDIF ()
but I have doubts if it is the best way or can be improved

Image 1

Imagen 2
regards

Was this reply helpful? Yes No