Am I missing something really simple?
Inside a flow, inside of Sharepoint Get Items action
This returns multiple items
DateComplete gt '@{outputs('Compose')}'
This returns multiple items
StaffChangeToCompleteDate gt '@{outputs('Compose')}'
This returns nothing
DateComplete gt '@{outputs('Compose')}' or StaffChangeToCompleteDate gt '@{outputs('Compose')}'
For context - here's where I'm using it.
@BenMunk ,
Try comparing the dates in the same format using the formatDatetime function. The format you should use is yyyy-MM-dd.
Like:
DateComplete gt formatDateTime('@{outputs('Compose')}','yyyy-MM-dd')
Thanks for you suggestion, but I seem to be getting a syntax error with that "The query is not valid."
@SudeepGhatakNZ I tried formatDateTime on the Compose action. Syntax worked fine, but still same problem with the filter - each clause fine by itself, as soon as combine the clauses with the "or" operator, I get no results.
Can you upload a screenshot?
First screenshot shows setup and output with "or" operator - no results. Second screenshot shows same thing without the "or" statement - multiple results.
Its possible that its a bug.
It seems I can run
Interesting! I will have to try that out. I use Or all the time. Can't find an example where two dates are involved.
Would be interested to hear if its happening for you. In the end I had to use non-date columns to achieve my needs. If it is a bug hopefully its rectified soon.
User | Count |
---|---|
22 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
43 | |
28 | |
25 | |
24 | |
23 |