Answered

List rows present in a table - Filter Query not working

(0) Share

Report

Posted on by Dan_Aspire42

Hi all I'm hoping someone can help with this.

Have a flow that grabs a table with one of the columns being today's date and sending email to those customers.

Trying to use Filter Query comes up with nothing however in the output of the flow test it looks identical to the data:

The compose checks the number of matches, and keeps returning 0.

Any help would be greatly appreciated.

Regards

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Dan_Aspire42 ,

Although you chose the ISO 8601 format, it is actually a serial number.

Hope it makes sense.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dan_Aspire42 31 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply, do you know how I could have the Filter Query field be so that the date serial is TODAY, as this flow is scheduled to run every morning.

Also trying a filter column doesn't work either:

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Dan_Aspire42 ,

Please don't use excel function in your excel table if you want to get values from this table using Power Automate.

If you want to filter the items whose date is today, please try this:

add(int(split(dateDifference('1900/1/1',utcNow('yyyy/MM/dd')),'.')?[0]),2)

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dan_Aspire42 31 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

Thanks again, it seems having the column be a formula is an issue, will have to do more learning about OData language to implement what I need via PA instead of Excel.

Thank you.

Was this reply helpful? Yes No