Unanswered

How to filter data from sql server table

(0) Share

Report

Posted on by D.Clark

Hello! I simply want to pull only records from my SQL server table where the division has the word "commercial" in it. What is the syntax in the Items property of my canvas app?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey!

This should work:

Filter( SQLTale_Name, Find("commercial", Divison))

Or:

Filter( SQLTale_Name, "commercial" in Divison)

Or:

Filter( SQLTale_Name, "commercial" exactin Divison)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
D.Clark 6 on at

Like (1)

Report

Thank you so much for the quick response, @Goncalo! I used the "in" syntax, and it works perfectly! Thanks, again!

Was this reply helpful? Yes No