Answered

Filter query for List_rows_present_in_a_table

(0) Share

Report

Posted on by UserNsk

Hi,

I'm trying to filter rows from List_rows_present_in_a_table item. I want to filter rows that has value of column name 'ItemRequiredDate' is equal to today.

I have tried with different filter query with different syntax.

Below is the currently I'm using,

Left side function of eq: formatDateTime(item()['ItemRequiredDate'],'mm/MM/yyyy')
Right side function of eq: formatDateTime(utcNow(),'dd/MM/yyyy')

Below is the my flow,

Below is the error I'm getting,

This is the Copilot suggestion on the error,

The 'MealRequiredDate' property cannot be selected in the 'List_rows_present_in_a_table' action. Double-check that the correct property name is being used. Did you mean to use the 'Modified' property instead?

I have folowed few forum thread and documantation. Did't get any help.

Filter query of excel list rows on month and year of a date column

list rows present in a table

Use lists of rows in flows

What is the reason for this error?

How can I filter table rows ?

Suggestions are really appreciated.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @UserNsk ,

Please try put this expression in Filter Query:

ItemRequiredDate eq 'utcNow(dd/MM/yyyy)'

And set The DateTime Format to ISO 8601 in List rows present in a table.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
UserNsk 18 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your quick reply.

I have changed the filter query as below. Also changed the date standerd to ISO8601.
There is no any error and flow is running. But It seems filter dosen't work. Because, there is a some rows in the table that has ItemRequiredDate is today.

This is the input of "list rows present in a table" item. Is this correct? I think it shoudn't has utcNow() function it self.

"table": "{00000000-000C-0000-FFFF-FFFF00000000}", "$filter": "ItemRequiredDate eq 'utcNow(dd-MM-yyyy)'", "dateTimeFormat": "ISO 8601"

And output is empty.

000C-0000-FFFF-FFFF00000000%7D')/items", "value": [] }

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @UserNsk ,

Could you please take a screenshot of your excel date column for me?

I want to see your date column format.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
UserNsk 18 on at

Like (0)

Report
Copy link

Link copied!

Thre are few more table headers.
Hope this is OK

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @UserNsk ,

Please try put this expression in Filter Query again:

ItemRequiredDate eq 'utcNow(MM/dd/yyyy)'

Best Regardss,

Sunshine Gu

Was this reply helpful? Yes No
UserNsk 18 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

Still getting no values as output. 😣

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @UserNsk ,

Ok fine, I know where is the problem.

We should use 'M/dd/yyyy' Date Format.

ItemRequiredDate eq 'utcNow(M/dd/yyyy)'

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

UserNsk 18 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-yetonggu-msft ,

Problem is solved. 🎉🎊

Correct syntex as below.

function is:
formatDateTime(utcNow(),'MM/dd/yyyy')
It's essential '' symbol in the filter query as above screen shot.

As @v-yetonggu-msft mentioned, DateTime Format should be ISO8601

Thank you so much for your help @v-yetonggu-msft 😊

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @UserNsk ,

If your problem is solved, please mark my reply and your own reply as the solution, so that my answer and yours will help more people who encounter this challenge in the future.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
UserNsk 18 on at

Like (0)

Report
Copy link

Link copied!

@v-yetonggu-msft
I have marked it. Also make it more explaind answer.

Was this reply helpful? Yes No