Unanswered

How do i put less than or equal to and greater than or equal to in my filter query?

(0) Share

Report

Posted on by jeo

Hi all,

I have been trying to get Power Automate to send an email of all the task that is due in the following month, a month before. However, i cant get the filter query in "List rows present in a table" to filter those in the range. The attached photo is a screenshot of my workflow.

Screenshot 2024-05-16 163224.png

Thank you,
Jeo

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @jeo,

That is a known limitation of the List rows present in table action:

https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations-with-actions

The List rows present in table action supports basic filtering and sorting:
- Supports the following filter functions: eq, ne, contains, startswith, endswith.
- Only 1 filter function can be applied on a column.
- Only 1 column can be used for sorting.

You could use 1 filter and apply the other one via a Filter Array action afterwards. Over here is a blog from @mdevaney which demonstrates this type of filtering:

https://www.matthewdevaney.com/how-to-filter-excel-table-rows-in-power-automate-text-numbers-dates/

Was this reply helpful? Yes No
jeo 46 on at

Like (0)

Report

Alright thank you. I will give it a try

Was this reply helpful? Yes No
jeo 46 on at

Like (0)

Report

Hello,
i tried the method that was provided in the link but i cant seem to get it work on my data. Any idea on how to fix it?
My data in my excel is in date format.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @jeo,

In that case I would remove the int function from the DueDate, that won't work with a date formatted value.

Use the below instead

item()?['DueDate']

You can use that directly in the Filter Array.

Below is an example, if that helps?

@and(greaterOrEquals(item()?['DueDate'], body('Substring')), lessOrEquals(item()?['DueDate'], body('Substring_1')))

Was this reply helpful? Yes No
jeo 46 on at

Like (0)

Report

alright great! It works now. Thank youu very much!

Was this reply helpful? Yes No