News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Update choice column i...

Power Automate - Building Flows

Answered

Update choice column if the date is before today

(0) Share

Report

Report

Posted on by Graciaso

47

Hello,

apologize if the question was asked before.

I have a choice column called Status and has 4 choices "Unscheduled, Scheduled, Overdue, Closed" and a date column called "Scheduled Finish Date".

I am trying to build a flow to make the status column change based on the date column only in one case.

If the scheduled finish date is before today then update the status to "Overdue".

Can someone help me with that?

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Graciaso 47 on at

Like (0)

Report

Re: Update choice column if the date is before today

@Johnnyg

Thank you very much.
For some reasons it doesn't work for my flow.
I edit it a bit and I could manage to get it works as following:
Graciaso 47 on at

Like (0)

Report

Re: Update choice column if the date is before today

Thank you very much.
Sutherland on at

Like (0)

Report

Re: Update choice column if the date is before today

Hi Graciaso,

You could made a simple with formatDateTime(*****,'yyyy-MM-dd') function to compare the date field as below snapshot>

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans