Unanswered

Filter Query - Get Rows from SQL Server

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

I want to Get Rows from SQL Server that have been created precisely three days ago.

The data type of the column in SQL is date (no time).

I tried the following, and the flow ran successfully, but I don't get any rows?

Date_x0020_Install eq '@{addDays(utcnow('yyyy-MM-dd'),-3)}'

The name of the column in SQL has space. That's why I have added "_x0020_".

Thank you in advance 🙂

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Anonymous with your expression you have this output

2020-09-18T00:00:00.0000000

So I if you need just the date you can try with this expression:

first(split(addDays(utcnow('yyyy-MM-dd'),-3),'T'))

and your output could be like this:

2020-09-18

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ChristianAbata

The flow ran successfully, but again I didn't receive any rows.

My table has data from that date, so that isn't a problem.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

ohh @Anonymous your date Install is a string o Date format? Please try to get your data without Filter and then try to see what is the format that Power Automate is reading your data could be diferent.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ChristianAbata,

This is the format in SQL

And this is the output in Power Automate:

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

thanks @Anonymous please try with this expression

concat(addDays(utcnow(),-3,'yyyy-MM-dd'),'T:00:00:00Z')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ChristianAbata,

Still no output 😞

Date_x0020_Install eq '@{concat(addDays(utcnow(),-3, 'yyyy-MM-dd' ), 'T:00:00:00Z' )}'

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Anonymous please make shure that you have data 19-09-2020 could you do a little search?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata Yes, I have data from that date.

You had a colon between T and 0 in your expression. I assume that is incorrect?
I removed it, and it still doesn't work.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

weird @Anonymous just to test something more, could you leave your SQL silter empty and then after this action can you add a filter array and test with the expression that I gave you?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata Doesn't work either. But I removed the filter and tried to search after the specific date in the output with CTRL + F, and it seems like I don't get all the rows from SQL.

If I search "Date_x0020_Install", then it can only find 1689 rows, and I have a lot more rows in the table in SQL.

Can it be true that there is a limit?

Was this reply helpful? Yes No