Unanswered

Last Modified Date

(0) Share

Report

Posted on by JoyK

Hello,

I need to determine the last modified date for a share point list using Power automate. Any idea on the Expression? Someone suggested using Max Date in “Get Items”. I may not be doing it correctly, so reaching out for assistance.
Thank you

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

v-xiaochen-msft on at

Like (1)

Report

Hi @JoyK ,

According to your description, you want to get the last modified datetime in SharePoint list .

Here are the steps you can refer to :
(1)We can use the "Get items" to get the items in SharePoint List:

And this is the sample output:

(2)Then we can add a Select action to get all the "Modified" value:

(3)Then we can add a Compose action to get the max "Modified" value:

last(sort(body('Select'),'Modified'))['Modified']

Then we can get the max of the "Modified" in SharePoint List:

Best Regards,

Wearsky

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

What @v-xiaochen-msft suggested might be a solution if you were doing this in cloud flows. But since you posted this in the forums for Power Automate Desktop, I have to ask - are you doing this in desktop flows?

Was this reply helpful? Yes No
JoyK 27 on at

Like (0)

Report

Yes I am.
thank you

Was this reply helpful? Yes No
JoyK 27 on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @JoyK ,

Sorry, i may misunderstand your need , you want to realize it in Power Automate Desktop.

You can try to use the "Get Items" in Power Automate Desktop like this:

The first step "Get Items" , you need to configure the list you want to connect :

The For Each steps:

The "Add Item to list" step:

The Last "Set variable":

Then in the last we can get the max modified datetime:

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

A simpler alternative to this would be adding some parameters to the Advanced options of Get items. If you set it to be ordered by Modified in descending order, you can then simply get the date of the first item. So, do it like this:

And then you can get the date as %GetItemsResponse.Value[0].Modified%.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No