I'm using Get files (properties only) to filter results from a SharePoint Library. I want to keep all files with a column date (reviewNotice) before now, and discard all the ones in the Archive folder. Here's my ODATA filter:
(reviewNotice le '@{body('Convert_time_zone')}') and ('{Path}' ne xxxxx/Archive/)
Here's the error message:
The expression "(reviewNotice le '2021-12-21 09:22:52Z') and ('{Path}' ne xxxxx/Archive/)" is not valid. Creating query failed.
Please help!
Thanks,
Anne
Solved! Go to Solution.
Hi @annetoal -
From a glance, your queries look correct. Could you provide a screenshot of the action and query from Flow? That will make it easier for us to identify any potential issues.
Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.
Hi @annetoal :
I'm afraid fields like {Path} are invalid in Filter Query.
Using Filter array is a good choice, I have configured it based on what you provided.
I've made a test for your reference:
@and(
not(equals(item()?['{Path}'], 'xxxxx/Archive/')),
less(item()?['reviewNotice'],body('Convert_time_zone'))
)
I think this link will help you a lot:
Best Regards,
Bof
Hi @annetoal -
From a glance, your queries look correct. Could you provide a screenshot of the action and query from Flow? That will make it easier for us to identify any potential issues.
Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.
Hi @annetoal :
I'm afraid fields like {Path} are invalid in Filter Query.
Using Filter array is a good choice, I have configured it based on what you provided.
I've made a test for your reference:
@and(
not(equals(item()?['{Path}'], 'xxxxx/Archive/')),
less(item()?['reviewNotice'],body('Convert_time_zone'))
)
I think this link will help you a lot:
Best Regards,
Bof
Thanks so much. My filter read
@not(equals(item()?['{Path}'], '/Archive'))
I had already been experimenting with the Filter command, but I failed to put the site name before the slash. Also, I did not include the less(item() afterwards. It works great, thank you so much.
Anne
User | Count |
---|---|
93 | |
45 | |
20 | |
20 | |
15 |
User | Count |
---|---|
134 | |
52 | |
44 | |
36 | |
27 |