Share via

How to get empty values in the condition on Logic app

Mahesh Madhusanka 221 Reputation points
2023-10-23T12:42:24.62+00:00

Hi Team.

Currently have a requirement to capture sql connector result empty points and base on it use it to logic app conditions to use as a logic condition, however I have used few options as below however empty result not captured to condition filter, kindly check and confirm it?

Current Value on SQL connector-

User's image

Current condition-

User's image

User's image

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,557 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeUrnun 9,777 Reputation points Moderator
    2023-10-25T04:17:40.6+00:00

    Hello @Mahesh Madhusanka Thanks for reaching out. In order to use Conditional effectively, it's important to understand the kind of data type you're working with, please see my answer here: https://learn.microsoft.com/en-us/answers/questions/1344227/logic-app-condition-issue

    In your case, you want to check if the ResultSets property (which is a property of JSON response from SQL Connector) is empty or contains other child properties -- please let me know if I misunderstood here.

    If correct, you can use the empty() function as described in the following blog post: Check JSON object null/empty in Power Automate

    Note: even though the blog post referenced above is for Power Automate, in this case, you can use the Conditional the same way for your Logic Apps workflow.

    Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.

    2 people found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.