Answered

Issues with Get Items (SharePoint List)

(0) Share

Report

Posted on by PowerTaco

Hi there!

I am very new to flow and have been trying to build a OData filter to grab items once a day in a SharePoint list that have not been modified for 90 days and has a location of completed for deletion. Here is what I have built so far:

Location eq 'RV Cancelled' or Location eq 'RV Completed' or Location eq 'SL Cancelled' or Location eq 'SL Completed' and Modified lt datetime 'OUTPUT'

(OUTPUT is a variable (compose) using this expression:

adddays(utcnow(), -90) )

I am sure I am just not understanding how the queries work. Any help would be greatly appreciated!

When I try to run the flow it failed (The expression is not valid. Creating query failed.)

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Christopher S on at

Like (1)

Report

Hi @PowerTaco

I think the issue is that oData filtering only accepts one condition, you can try removing the conditions and only leaving one and check again to save the Flow, if the conditions work then this is a limitation of the oData filtering.

Best Regards
--
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @PowerTaco ,

Please try to remove datetime and try again. Please note that we could use choice filed as a filter in Filter Query.

Best Regards,

Was this reply helpful? Yes No
PowerTaco 8 on at

Like (0)

Report

Worked! Thank you!! 😎

Was this reply helpful? Yes No
PowerTaco 8 on at

Like (0)

Report

Thank you for your response! The filter accepted the multiple conditions (after I removed "datetime"), however I will keep this in mind for future testing. 😊

Was this reply helpful? Yes No