File Properties

(0) Share

Report

Posted on by garthh

138

I need to Move files from one folder to another using the Property '.CreationTime'

I have tried the following PAD action

The date variables have been checked and are correct

The isues is the error 'Files3' does not have a property '.CreationTime' appears

When I look at Files3 '.CreationTime' is a Property - what do I need to do to filter/select/move files by '.CreationTime'?

Categories:

Power Automate Desktop

All responses (12)

Answers (1)

Sort by

Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

You're doing a for loop on files3, yet you're also telling it to look for .CreationTime in files3, switch it to Currentitem.CreationTime, as with the way you're doing right now you're asking for the "CreationTime" property on the entire list of files rather than one file at a time.
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you want to compare Current File with Yesterday? Try to update Files3 with CurrentItem
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Pavel
Thank you
I have tried what you suggested and checked that the dates %Yesterday% and %ResultedDate% were in the same MM/dd/yyy format (our reginal format is dd/MM/yyy). I also used >= to overcome the date time difference but are unsre if that is the way to handle the time difference, or if that is necessary?
I get this error now but presume this is not date releated.
Any other thoughts please!
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Kaif

Thank you
You may have seen my reply to Pavel;
avel
Thank you
I have tried what you suggested and checked that the dates %Yesterday% and %ResultedDate% were in the same MM/dd/yyy format (our reginal format is dd/MM/yyy). I also used >= to overcome the date time difference but are unsre if that is the way to handle the time difference, or if that is necessary?
I get this error now but presume this is not date releated.
Any other thoughts please!
Verified answer

Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

Move to files should also be moving Currentitem, not files3, should've noticed that, my bad.
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you try @Pavel_NaNoi suggestion ? just update 'file3' with 'CurrentItem'.
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Pavel & Kaif
Thank you - Yes, CurrentItem works
I have another probelm and hope you can help
I need to Move the files into a folder but the folder name changes daily
When the folder is created it has the name of the previous days date - in other works if created on the 11 March 2023, part of the folders name would be 10 Mar 2023. This is achieved in the Flow
When running the Flow it will make Date this new folder yesterdy
I need to move the files into the folder made on the previous day, day before yesterday
I have used the Action Get subfolders in Folders but the variable produced is a list.
I can't fathom how to move the folder needed from the list into a variable that is a folder so it can be used in the Move files to folder action
Are you able to help?
Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:
-Get current date and time
-Subtract dates (to get the correct date time you want)
-Use Parse Text action, and parse the list of subfolders via a regular expression option ticked and look for the date time you've just made.
-The match variable produced will be your folder name.
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Pavel

Thank you
I believe I understand what you have outlined.

I used Get sub Folders in Folder as that allows a folder filter but creates a list
However, I can’t move files into a Folder that is in a list as the Move files action says ‘Destination Folder must be Folder’

Can I find the path of the folder in the list as it appears a path is required for the Move files action?

I’ll try the Parse text action also

Garth
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Pavel

Will the variable 'Match' store a folder path?
I have checked the dates as the Parse action isn't providing a Match variable
I don't know if thats an issue with Parse or if Parse can't store a Folder path?
Here is the Flow