web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / SQL Get Rows with filt...
Power Automate - Using Connectors
Unanswered

SQL Get Rows with filter throws time out

(0) ShareShare
ReportReport
Posted on by Jorge_

I'm getting rows from SQL in PA.

 

If I don't include any filter, it works

If I add any of these 2 filters, it works

(SU_TYPE eq 'Es' or SU_TYPE eq 'Te') -> 21477 rows
(SU_STATUS eq 'Active' or SU_STATUS eq 'Pending' or SU_STATUS eq 'Planned') -> 58161 rows

 

But if I change the SQL filter to this doesn't work, it timeout after 4h

(SU_TYPE eq 'Es' or SU_TYPE eq 'Te') and (SU_STATUS eq 'Active' or SU_STATUS eq 'Pending' or SU_STATUS eq 'Planned')

Categories:
Licensing
I have the same question (0)
  • SpongYe Profile Picture
    SpongYe 5,603 Super User 2025 Season 2 on at
    Re: SQL Get Rows with filter throws time out

    Hi @Jorge 

     

    Try this:

    SU_TYPE eq 'Es' or SU_TYPE eq 'Te' and SU_STATUS eq 'Active' or SU_STATUS eq 'Pending' or SU_STATUS eq 'Planned'

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • Jorge_ Profile Picture
    Jorge_ on at
    Re: SQL Get Rows with filter throws time out

    thanks, but it doesn't work

  • SpongYe Profile Picture
    SpongYe 5,603 Super User 2025 Season 2 on at
    Re: SQL Get Rows with filter throws time out

    Hi @Jorge 

     

    Can you post some screenshots?

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Coming soon: forum hierarchy changes
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 555 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 388 Moderator

#3
chiaraalina Profile Picture

chiaraalina 264

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans