Forum Discussion

minime100's avatar
minime100
Copper Contributor
Apr 06, 2020

copying files from one folder to the other folder

Hi,

I am trying to move files from main documents to archive folder on a daily basis, meaning 1 day or older files will be moved to Archive folder. But my flow is throwing an error at "Get files (properties only)" step.  Could you please help?

Below is the flow step:

 

And this is an error I am receiving during run:

 

{
"status": 400,
"message": "The expression \"EventDate It datetime'2020-04-05T06:59:12.7849439Z\" is not valid. Creating query failed.\r\nclientRequestId: 2b1c4d08-0ba9-4fe6-80a9-405befbab0e1\r\nserviceRequestId: 2b1c4d08-0ba9-4fe6-80a9-405befbab0e1"
}

 

Thanks in advance!

Microsoft Flow
  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Apr 06, 2020
    You are hitting one of the "usual" problems when dealing with dates in SPO. You might need to make some pre-processing with the date data so it can be accepted by SPO with no problems
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Apr 06, 2020

    minime100 it's not a SharePoint problem, there are several problems with your filter query. The text datetime shouldn't be there at all, there should be a space before the opening single quote, and you've left out the closing single quote. It should look like this (although my example uses the Created column rather than another one):

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources