Forum Discussion
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!
- 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
- minime100Copper Contributor
Thanks jcgonzalezmartin , i will try. Please share any documentation if you have.
- RobElliottSilver Contributor
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