Unanswered

Prepend existing file name with Last Modified date/time stamp

(0) Share

Report

Posted on by SynchroSting

Hello. I'm a rookie user. My goal is to prepend existing files with the last modified date/time stamp. I've succeeded with the current date/time, but keep failing with last modified. I've tried so many different flows, I'm not sure which one is best to post here.

The process is as follows:

Get files (properties only) (find all files created in the past 24 hours)

Filter Query: Modified gt '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')}'

Then, under a For Each:

Get file metadata (based on Identifier)

Get last modified time/date stamp in string format (I've tried several methods, none of which have worked)

Get file content (based on Identifier)

Create file

File Name: (concat LastModified + existing file name and extension)
File Content: body('Get_file_content')

Delete file (based on Identifier)

Again, I'm a rookie, so I apologize if this needs to be presented differently. Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report

Where are these files stored? If they are stored in SharePoint, I would not bother. The modified column contains this data. If not implemented correctly, the modified date in the filename could not match the modified date field and cause confusion to users.

If your files are in SharePoint, use the modified date value in your expression instead of trying to manipulate the utcNow() value.

Was this reply helpful? Yes No
Suggested answer

Mark Nanneman 991 Super User 2025 Season 2 on at

Like (2)

Report

Your "Get Files (properties only)" will include the date modified for each file. But you'll want to convert it to a different file name friendly format.

I'd recommend an expression like this:

formatDateTime(item()?['Modified'],'yyyy-MM-dd_hhmmss')

But you can format it however you like. MM is month, mm is minutes.

Was this reply helpful? Yes No
Verified answer

SynchroSting on at

Like (0)

Report
Thank you for your responses, @Mark Nanneman and @David_MA. Believe it or not, I got it working, and managed to keep it as simplistic as possible.

Get files (properties only)

Filter Query: Modified gt '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')}'

Find all files created or modified in the past 24 hours. I used modified only because If a file is only saved once, it's creation and modified dates should be the same.

For Each:
Get file metadata (based on Identifier)

Get file content (based on Identifier)

Create file

File Name: concat(formatDateTime(addToTime(body('Get_file_metadata')?['LastModified'], -8, 'Hour'), 'yyyy-MM-dd HH_mm_ss'), ' ', body('Get_file_metadata')?['Name'])

File Content: body('Get_file_content')

File Name also converts UTC to CST.

Delete file (based on Identifier)

Original: Test file.docx (last modified 1/9 at 2:47 PM)

Modified: 2025-01-09 14_47_22 Test file.docx

I still need to confirm that the script will only affect files less 24 hours old, but the prepend is working great! Thanks again!

Was this reply helpful? Yes No