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:

Business Process Flows

I have the same question (0)

All responses (10)

Answers (1)

v-litu-msft on at

Like (0)

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

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.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

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

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

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report

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

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": []
}

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

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

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.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report

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

@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

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report

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

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:

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report

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

@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.

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No