cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zdieter
Helper I
Helper I

SQL Get Rows with filter Flow

Hi,

 

I have a SQL table set up as follows

Capture.PNG

 

I am trying to use the "Get Rows" in flow to return specific rows for the user. I am using the Filter section in "Get Rows" to filter the rows I want. However, I cannot get it to return anything if it successfully runs.

 

I have tried:

[Learning unit code] eq '601'

Learning unit code eq '601'

['Learning unit code'] eq '601'

"Learning unit code" eq '601'

'Learning unit code' eq '601'

 

As well, I have tried it with the "Complete" column to see if I could get something to return but I cannot. It always returns blank.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
DeepakS
Super User
Super User

Hi @zdieter 

 

Have should try following

 

learning_x0020_unit_x0020_code eq '601'

 

--------------------------------------------------------------------

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

 

 

View solution in original post

3 REPLIES 3
DeepakS
Super User
Super User

Hi @zdieter 

 

Have should try following

 

learning_x0020_unit_x0020_code eq '601'

 

--------------------------------------------------------------------

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

 

 

View solution in original post

abm
Super User III
Super User III

Hi @zdieter 

 

  @DeepakS suggestion should work if it's a string data type. If 'Learning unit code' is integer you don't need single quotes around it.

 

For string data type

Learning_x0020_unit_x0020_code eq '601'

 

For integer data type

Learning_x0020_unit_x0020_code1 eq 601

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
v-bacao-msft
Community Support
Community Support

 

Hi @zdieter ,

 

Following the above suggestion, please try to run Get rows action without configuring Filter Query.

 

Then get the name of the column in Body and configure it to Filter Query.

 

As mentioned by abm, if the type of field is a string, the filter should be ColumnName eq '601'.

 

If the type is integer, filter should be ColumnName eq 601.

 

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (5,230)