web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Automated Change

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hey Guys,

 

I have a drop down column called 'Tour Status' that only shows "Pending or Completed" with a default set to Pending. I would like help setting up some type of command that will check the current date. Any date greater then the current date such as "5/17/2022 or higher" will automatically  change the drop down to "Completed" and change the color to red. Appreciate your assistance.

 

2022-05-16_21-51-20.jpg

Categories:
I have the same question (0)
  • Verified answer
    iltoningui Profile Picture
    247 on at

    Hi! @Anonymous 

    1. You should update the choices to include one that represents expired (red)

    iltoningui_0-1652769948066.png

    2. Create a recurrence trigger I used 1 hour

    iltoningui_1-1652769986759.png

     

    3. Get all items that are expired and their status is pending (You may need to include the time, I only used the date)

    iltoningui_2-1652770037969.png

    the formula contains utcNow('yyyy-MM-dd')

    4. Use the apply to each to update any record retrieved from the get items

    iltoningui_3-1652770848066.png

     

    If this help consider marking it as a solution.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    That was what I needed.. .THANK YOU SOO MUCH!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard