Filter Query for Get Items - anything due in 7-14 days time

(0) Share

Report

Posted on by Jap11

441

Hello,

I'd like to build a filter query to get anything that has a delivery deadline that equals 7-14 days away from the date the flow runs.

For example today is 01/08/23. When the flow runs, I'd like it to get items of anything that has a delivery deadline of the 8th-15th.

I currently use this to get anything with a delivery deadline of anything in the next 7 days which works great but not sure how to get the above to work.

Any helps appreciated as always.

Thanks,

Josh

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Manish Solanki 15,169 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @jap11

To get the records between range of dates, you need to write the below query:
DeliverDeadline ge '@{formatDateTime(addDays(utcNow(),7),'yyyy-MM-ddTHH:mm:ssZ')}' and DeliverDeadline le '@{formatDateTime(addDays(utcNow(),15),'yyyy-MM-ddTHH:mm:ssZ')}'
This query will return the records from 7-15 days (including 15) away from the date when flow runs. Here is the screenshot:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Jap11 441 on at

Like (0)

Report
Copy link

Link copied!

Hello @ManishSolanki

Thank you for your quick response.

It seems i'm getting an error message when using this, could it be related to how the Delivery Deadline is formatted in my sharepoint list? can the filter query be amended accordingly to align with this format?

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @jap11

Pls try without giving blank space in column name. As you are only taking the date in that field so, we can skip the time part in the filter query:
DeliveryDeadline ge '@{formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')}' and DeliveryDeadline le '@{formatDateTime(addDays(utcNow(),15),'yyyy-MM-dd')}'
You may copy & paste the above statement directly into the "Filter query" textbox and try running the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Jap11 441 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki

Sorry this still didn't work. I tried without the blank space and it said the column did not exist, so i added back in the space and then got this error message. I also tried changing the order of the date to dd-MM-YYYY, as with how the column in sharepoint is formatted, but i got the same error

Thanks,
Josh

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @jap11

In the filter query, we use the internal name of the field. Pls check the internal name of the 'Delivery Deadline' from the SharePoint site.
1. Go to List settings and scroll down to columns section:

2. Click on the "Delivery Deadline" column, here I am using different name (To be assigned to):

You can find the internal name at the end of the site address in Field query parameter (after Field=). In the above example, the internal name of 'To be assigned to' field is 'Tobeassignedto'. We are supposed to use the internal name in the filter query in "Get items" action.

Pls check the internal name of the field 'Delivery Deadline' and replace it with the field name in the Filter query.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Jap11 441 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki - that's done the trick.

The column was named Delivery_x0020_Deadline - so once correctly to this in the expression, the flow ran successfully.

Thank you very much.

Was this reply helpful? Yes No