Power Platform Community Forum Thread Details

I have added a Flow to calculate a column in my SP List for DaysOld. On a daily basis I would like to perform "sub(utcNow(),'Created')". Based on this, I have a couple of questions...

Is this the best way to accomplish? I need the DaysOld to be a daily updated value if the Status is not = "Complete".
Is a calculated column a better method or will it NOT update unless the item is modified?

Any assistance would be appreciated.

Thanks

Categories:

Building flows

If you use a calculated column, it will only recalculate when the item is updated, so you probably need Power Automate if you need it updated daily. You can use three compose actions to get the days:

The first compose will calculate the date difference. It will return the value in days, hours, minutes, seconds (2.18:19:26.2006273).
The second compose you will split this value on the period.
The final compose will get the day value from the first split.

These are the expressions in each Compose action: