web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : 50mzu+jbpqkjpPgTqfFopb
Power Platform Community / Forums / Power Automate - Building Flows / Sharepoint List Flow: ...
Power Automate - Building Flows
Answered

Sharepoint List Flow: Automatically update "last action date" column when the most recent date column changes.

Like (0) ShareShare
ReportReport
Posted on 8 Jul 2022 17:27:51 by Jonesm52 8

Hi All,

 

I'm new to power automate and I have a SharePoint list that has 28 different date & time columns that need to be updated as a project progresses. Currently, we manually update a separate "Current Status Date" date & time column when we move through each milestone of a project for reporting and calculation purposes. Is there a flow anyone has built for when a date & time column is updated it updates a separate column showing the status date of an item?

 

All the suggestions I have seen have been focused on automatically updating dates when a choice column changes, but I'm having difficulty replicating it for just date and time column changes.

 

Any assistance will be helpful.

I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on 13 Jul 2022 at 02:49:14
    Re: Sharepoint List Flow: Automatically update "last action date" column when the most recent date column changes.

    Hi @Jonesm52 ,

     

    How many date columns do you have in the list?

     

    I assume there are four and you would like to get the latest date populated into the last column. So I made a demo for your reference:

    vjefferni_0-1657680472463.png

     

    actions within Apply to each:

    vjefferni_1-1657680481094.png

     

    Hope this helps,

     

    Best regards,

  • Jonesm52 Profile Picture
    Jonesm52 8 on 08 Jul 2022 at 18:03:38
    Re: Sharepoint List Flow: Automatically update "last action date" column when the most recent date column changes.

    Hi Scott,

     

    The highlighted column is the column I'd like automated based on the dates from the previous columns. Any thoughts?

     

    Would it be helpful to show the flow that I built? I figured I'd start from scratch since the flow I built isn't accomplishing the task. 

     

    Thanks in advance. I'm very much a novice with flow builder.Capture.JPG

  • ScottShearer Profile Picture
    ScottShearer 25,236 Most Valuable Professional on 08 Jul 2022 at 17:48:45
    Re: Sharepoint List Flow: Automatically update "last action date" column when the most recent date column changes.

    @Jonesm52 

    Sorry but I'm not quite clear on what you want to do.  Could you provide some screen shots and additional explanation?

     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans