Unanswered

Filter Query problem

(0) Share

Report

Posted on by SCMSAC

Hi,

I have a Calendar for vehicle bookings and I need to set a flow to send an email reminder for vehicles that needs servicing 1 day after today (i.e. tomorrow). I am using Filter Query but the condition for equals tomorrow is returning no values, even though I do have vehicles booked.

I checked the outputs of my flow and it is picking up the correct date...

Could anyone assist? Thank you so much

All responses (3)

Answers (0)

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Query problem

Can you remove the date filter, run the flow, then click on Click to download (see screenshot) and see what EventDate is returning in the JSON output? If it's a date AND time, then you can't just filter on if it equals yyyy-MM-dd.
SCMSAC 32 on at

Like (0)

Report

Re: Filter Query problem

@v-chengfen-msft
Thank you for your help with this. Please see output below. Not sure how to read it...
Can you translate it for me? Thanks!
v-chengfen-msft on at

Like (0)

Report

Re: Filter Query problem

Hi @SCMSAC ,
At present, it is not possible to determine which of these two conditions cannot be satisfied, resulting in no filtering results.
Please try testing both filter query individually.

Please click Output to view the result

Best Regards
Cheng Feng