SQL Date Filter - Get Rows

(0) Share

Report

Posted on by Markus44

Hello Community,

I have an SQL table from where I get data by using the "Get Rows" function.

The table contains thousands of entries, so I would like to filter them.

Goal:

Filter the SQL table for the field "created_on" for entries that got entered later than 2020 January 1st.

Question:

How can I add a filter to the Filter Query of Get Rows to achieve the goal?
I tried several possibilities I found online, also here in the community. None of them seem to work.

When I use the select function to see what the data looks like, I get the following:

Also, when I download the output from the Get Rows function, I can see the created_on date looks like the following:

For example, when I enter

created_on ge date(2020-01-01T00:00:00.000Z)

in the Filter Query, the flow seems to run fine but it does not provide any values, however, I know there are some.

I am a bit lost and desperate, any idea would be much appreciated.

Thanks and regards

Markus

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Markus44

Try filter qery

created_on ge date(2020-01-01T00:00:00Z)

A while ago I answered this. Please see this post.

Solved: Re: SQL GetRows OData Date Filter - Page 2 - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Markus44 77 on at

Like (1)

Report

Hello @abm ,

thanks a lot for your reply.
However, this also does not work for me. The flow runs, however it does not provide any results even though there are multiple entries later than 2020.

I simply do not understand why it does not return any values.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Markus44

Thanks for your reply. Is your SQL column created_on data type DateTime?

Thanks

Was this reply helpful? Yes No
Markus44 77 on at

Like (1)

Report

Hello @abm

Thanks for the reply!

Unfortunately I do not have access to the SQL table. I will reach out to the admin to check this out.
Thanks!

Was this reply helpful? Yes No