Unanswered

Troubleshooting Filter Query in SharePoint get items

(0) Share

Report

Posted on by Danielx64

Hello,

I don't know if I am just having a bad day or doing something stupid but I have a rather long Filter Query and I'm not getting the required output. So I taken the step to break it right down, starting with the date that I am interested in (to aid troubleshooting), and I wrote my Filter Query as

remindtimerstartdate eq '2022-08-16'

Where remindtimerstartdate being a date/time column in SharePoint configured to date only. and i'm not getting any output at all, even though I am getting data when I remove the Filter Query and search the json:

Am I doing something stupid or just running into a bug?

Cheers

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Try comparing the dates using the formatDateTime() function
formatDateTime(remindtimerstartdate,'yyyy-mm-dd') eq '2022-08-16'

Was this reply helpful? Yes No
Danielx64 34 on at

Like (0)

Report

Hi there,

I just tried that and i'm getting The query is not valid. message and if I do to use a proper expression, I am unable to save the flow.

Cheers

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Danielx64
Can you show in which format you are getting the date, by using get items, and create a compose action and add the date in it.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

From one of my flow runs

Was this reply helpful? Yes No
Verified answer

Danielx64 34 on at

Like (0)

Report

Ok, I managed to solve this, I suspect that the original column went bust. Fixing it was easy as I just created a new one, create a flow to import data over to the new column and call it a day.

Was this reply helpful? Yes No