cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbhul_amvet
New Member

SharePoint Last Modified DateTime is 0001-01-01T00:00:00

Hello Y'all,

 

I am trying to get the last modified DateTime for a SharePoint folder using the 'List Folder' action, but I only get a last-modified value of 0001-01-01T00:00:00 (get folder metadata returns the same value).

 

Any idea on how to fix this or an alternative way to get the last modified DateTime?

 

Thanks in Advance!

 
        {
            "Id": "Id",
            "Name": "Report A",
            "DisplayName": "Report A",
            "Path""/Library/Location/2021/Report A",
            "LastModified""0001-01-01T00:00:00",
            "Size"0,
            "IsFolder"true
        },
 
Edit 1: Clarified Folder Structure
11 REPLIES 11
abm
Super User III
Super User III

Hi @jbhul_amvet 

 

Believe you are looking the root folder of your library. If you look the subfolder or files from the root  you should be able to get LastModified property.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Hi @abm 

 

Thank You for your reply.

 

The folder structure I use is "Library/Location/Year/Report/file.ext" and the List Folder action uses the id for the year level, so I can check if all reports have been uploaded. 

"Name""Report A",
"Path""/Library/Location/2021/Report A",
"LastModified": "0001-01-01T00:00:00"
  

Hi @jbhul_amvet 

 

Thanks for your reply. Is your Location and 2021 is a Folder or library? 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Hi @abm 

 

Location, 2021, and Report A are all folders.

Hi @jbhul_amvet 

 

Here is my test result.

 

image.png

 

Test Result

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Hi @jbhul_amvet 

 

Thats very strange. Are these folders created via any migration or something? How they originally created?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

@abm This is what I got

 

jbhul_amvet_0-1613958950911.png

Result:

jbhul_amvet_1-1613958992674.png

For this folder: 

jbhul_amvet_0-1613959263766.png

 

 

Strange. 

 

They were created through power automate using the create folder action

Prafull
Frequent Visitor

I am also facing same issue with Folders last modified date. It is giving correct date for files.
@jbhul_amvet Did you found any solution?
@abm Do you have any idea?

Is anyone figure out this strange issue with folders last modified date? Any help would be much appreciated.

Please see below screenshots.

Prafull_0-1620316655428.png

 

Prafull_1-1620316720718.pngPrafull_2-1620316755736.png

 

 

Hi @jbhul_amvet 

 

Did you created this folder. Try create a new folder and test it again. Follow my earlier thread screenshots.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Prafull
Frequent Visitor

@abm Yes, it doesn't work for Folder.

I checked with shared documents library as well.

abm
Super User III
Super User III

Hi @Prafull 

 

Interesting. I got the result as expected.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,327)