Filter Query expression - items today and time is 00:00

(0) Share

Report

Posted on by Lefty

1,625

Hi All,

I wanted to know what the expression would be if I want to only 'Filter Query' items from SPO list:

The column ArrivalDate is today and ArrivalTime (Date and Time field) column is also today and the time is 00:00
or if ArrivalTime field is completely empty, but the ArrivalDate is today?

Categories:

Building flows

All responses (10)

Answers (1)

Sort by

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lefty,

You could refer to the following syntax of ODATA filter query to get today and time equals today 00:00:

ArrivalDate eq '@utcNow('yyyy-MM-dd')' and ArrivalTime eq @utcNow('yyyy-MM-ddT00:00:00Z')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-litu-msft

Thanks

Is there a way of saying if:

ArrivalDate eq '@utcNow('yyyy-MM-dd')' and ArrivalTime eq @utcNow('yyyy-MM-ddT00:00:00Z') Or ArrivalDate eq '@utcNow('yyyy-MM-dd')' and ArrivalTime eq blank
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @v-litu-msft
I've tried this, but get no email and when i check the body of the get items action it states:

{
"value": []
}
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lefty,

You could have a try the following ODATA filter query:

(ArrivalDate eq '@utcNow('yyyy-MM-dd')' and ArrivalTime eq @utcNow('yyyy-MM-ddT00:00:00Z')) Or (ArrivalDate eq '@utcNow('yyyy-MM-dd')' and ArrivalTime eq null)

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-litu-msft This isnt working for me I will break down what is working and what isnt: This sends me an email with the item that match todays date: ArrivalDate eq 'utcNow ('yyyy-MM-dd')' If I put ArrivalDate eq 'utcNow ('yyyy-MM-dd')' and ArrivalTime eq 'utcNow ('yyyy-MM-ddT00:00:00Z')' The workflow runs, but nothing is returned and no email... as this is not working I have not been able to add another condition here, please help
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lefty,

Could you please share your Flow screenshot?

I want to check if you input the filter query correctly.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-litu-msft
This is now working only if I put this one condition on the filter, but I cannot get both the conditions to work:
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lefty,

Do you consider creating two Get items to get items meet two conditions separately?

After two Get items action, combine them in an array. Then use Parse JSON action to extract value.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-litu-msft

I'm not sure how I would do this.
Flow isn't something I have used a lot, just trial and error based on info I can find online and help from the community.
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lefty,

For example, you could initialize an array variable, then use Append to array variable action to append each item met condition to the array variable:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.