Filter Query problem

Like (0) Share

Report

Posted on 15 Feb 2023 23:08:35 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

I have the same question (0)

All responses (3)

Answers (0)

grantjenkins 11,059 Moderator on 17 Feb 2023 at 11:40:38

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.

Was this reply helpful? Yes No
SCMSAC 32 on 16 Feb 2023 at 03:25:12

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!

Was this reply helpful? Yes No
v-chengfen-msft on 16 Feb 2023 at 02:49:16

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

Was this reply helpful? Yes No