Flow with IF Statement

[RJF61]

Hello,

I have a Flow that updates a SP Column "DaysOld" based on the difference when a record was Created and Now().  I have created an additional Column "DaysOldRange" that I would fill with a text value based on the "DaysOld" Flow result (as shown below).

Is providing an expression "If Statement" the most efficient way to accomplish or is there a better method?

[schwibach]

Maybe I'm not getting what you're trying to do, but is there a specific reason why you are using Flow and not calculated columns directly in SharePoint with the Today() oder Now() function?

[RJF61]

@schwibach Thanks for the response.  My primary reason for the Flow is to continually update the difference between Created and Now().  I will have a Powers Apps summary where the # Days Old will be displayed.  I'm not aware of a method to have a calculated field update on a daily basis assuming there are not changes to the record.

May sense?

[schwibach]

This here deals with exactly what you want:

Calculate with Today’s Date in a SharePoint Column without Daily Updates - European SharePoint, Offi...

If it's about displaying in the SP-list, then I'd use the last option that's mentioned.