Answered

check if a date is late and change the status of the SharePoint column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone ,
I would like to make a flow that checks if the date of a SharePoint list item is overdue.
For example: the order date of a sale cannot exceed 15 days. If this happens, power automate would change my SharePoint status column to "overdue".

Would it be possible to do this?
Thanks

Categories:

General topics

All responses (4)

Answers (2)

Sort by

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Anonymous Pls use calculated column for such purpose. It will be easy to handle.

overdue calculated column will be like [sale date]+15 and then you can either use flow to update or use calculated column again with if else logic.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Verified answer

mobashee Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Dear Partner,

As suggested by Hardeh, the calculated column will be the right approach.

If you want the same in the flow, create a scheduled flow & schedule it to run every morning. Validate the column & update it using update sharepoint action.
I am not giving you exact expressions that may slow down your learning experience.

Did I answer your question? Please consider to mark my post as a solution to help others.

Regards,

Mohamed Sanuj Basheer
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

then the easiest and fastest way is to do it directly in SharePoint. thank you for your availability.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I will also do it for learning, thanks for the availability