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 Platform Community / Forums / Power Automate / Extract last modified ...
Power Automate
Answered

Extract last modified date from file in a windows folder

(0) ShareShare
ReportReport
Posted on by 10

Hi

 

I am using Power Automate Desktop and don't have sharepoint/onedrive etc.

 

I am trying to make a task that will do a bunch of things and then send an email with the data i have extracted from logs etc.

 

One of the things i am trying to do and am stuck on, is i want to get the file names of the files in a folder and print to an email (this part is done) however the next part i want to print in the email is the last modified date of the said files.

 

How can i query the last modified data for a file eg: abc.csv so that when the email is sent, i can make sure at a glance that the file is less than 24 hours old.

 

The whole point of this exercise for me is to build up some simple to understand email reporting based on complicated logs (which the end user wont understand) with the data massaged in a way that makes sense.

 

I can't seem to figure out how to do it. Is there a way to extract the metadata?

 

1.jpg2.jpg

I have the same question (0)
  • Verified answer
    PrasadAthalye Profile Picture
    on at

    You can extract it using File Properties. I see that you are using GetFiles. You can run a loop on GetFiles Collection and for each Current Item, you will get an option to select ModifiedDate... Refer below

     

    PrasadAthalye_0-1625698300397.png

     

  • Complex86 Profile Picture
    10 on at

    Thank you for your reply, i think i have made some good progress however i am not all of the way.

     

    In the second screenshot i can see the 4 files in the folder, and i can click 'more' on each, which i did, i can also see .LastModified, however when i try to call that attribute in the 3rd screenshot i get an error telling me the file doesn't have a property .LastModified.

     

    I know i am doing something extremely silly.

     

    3.jpg4.jpg5.jpg

  • Verified answer
    tkuehara Profile Picture
    667 on at

    Hi @Complex86 

     

    Change you "Set variable" action:

    from: %KronosUploadFiles.LastModified%

    to: %CurrentItem.LastModified%

    tkuehara_0-1625710200056.png

     

  • Complex86 Profile Picture
    10 on at

    Thank you both for contributing to the solution!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 258 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 198 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 136 Super User 2026 Season 2

Last 30 days Overall leaderboard