Skip to main content
Community site session details

Community site session details

Session Id : J9pAUfcXenaDaEKZbPX63o
Power Automate - Using Flows
Answered

how to check Execute a SQL query connector output is empty or not.. ? since it returns always false

Like (0) ShareShare
ReportReport
Posted on 23 Jun 2020 11:33:28 by

Hi Mates,

how to check is empty in not from connector "Execute SQL query" output...?

In Shortly: i am querying to get a value is exist or not, query is below.

SELECT ID FROM tblDataMurali WHERE (ID ='123456')

In-Fact that is is not exist in Table. Connector(Execute a SQL Query) executing fine, but now i want to perform few action in SQL table based on Condition, for this i am just checking QueryResult is Equal to empty('') 

flowempty.PNGflowshow.PNG

 

Every time it executes false, instead of true

Since value not exists then condition has to true, but it goes with false how come ..? how to check here ..? any help please

 

  • Community Power Platform Member Profile Picture
    on 25 Jun 2020 at 11:24:29
    Re: how to check Execute a SQL query connector output is empty or not.. ? since it returns always false

    Hi krishna,

     

    Thank you some how i can check now with your solution. 

  • Verified answer
    rsaikrishna Profile Picture
    3,703 on 25 Jun 2020 at 11:12:43
    Re: how to check Execute a SQL query connector output is empty or not.. ? since it returns always false

    @Anonymous 

     

    What does the compose action shows when you run the flow?

     

    In the condition, you should check for:

     

    "Output of Compose" is equals to "true"  -  This will return true.

     

    Give a try and update this post.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

     

     

     

  • Community Power Platform Member Profile Picture
    on 25 Jun 2020 at 10:52:19
    Re: how to check Execute a SQL query connector output is empty or not.. ? since it returns always false

    Hi @rsaikrishna 

    As per below i tried to with compose,

    In-Fact SQL command returns blanks , this is fine as expected, but after i am just checking with condition result set if blank then true or false, but here it goes false condition always.

    how to check here empty or not ..? please see the screen shots.

    now2.PNGnow1.PNG

    I am check with any thing wrong in Condition ..?

  • rsaikrishna Profile Picture
    3,703 on 23 Jun 2020 at 12:01:44
    Re: how to check Execute a SQL query connector output is empty or not.. ? since it returns always false

    @Anonymous 

     

    Your question was answered in the following posts:

    https://powerusers.microsoft.com/t5/General-Power-Automate/Execute-a-SQL-Query-and-Catch-a-Empty-Return/td-p/463314

    https://powerusers.microsoft.com/t5/General-Power-Automate/Add-Condition-Null-SQL-Query-Results/td-p/163589

     

    Please review and post any questions.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

     

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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete