How to apply contains expression to filter array of string in Azure Logic Apps

Hi @Dattatray Pise ,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

While you are using Filters on Alias and it's returning null or empty array. Please try once with contains in the Condition field, in this way the filter will check if the alias property contains the substring which was passed. If the condition is met, the object will be included in the output array.

Below is the example with the problem reference.

{
"actions": {
    "Filter_array": {
        "inputs": {
            "from": [
                { "alias": "_V2_abc.Svc_CI", "definitionId": 63 },
                { "alias": "_V2_abcTEST.Svc_CI", "definitionId": 64 }
            ],
            "conditions": [
                {
                    "left": "@item().alias",
                    "operator": "contains",
                    "right": "abc"
                }
            ]
        },
        "runAfter": {},
        "type": "Query"
    }
}

Please find the reference in below link for the filter action for arrays.

https://video2.skills-academy.com/en-us/azure/logic-apps/logic-apps-perform-data-operations?tabs=consumption#filter-array-action

If the issue persists, please do not hesitate to reach out further assistance. If you find this answer helpful, please click "Comment" and kindly upvote it.

Hi @Dattatray pise,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Hi Khadeer Ali Shaik Kanubai,

Apologize for late reply.

The above condition works with if right side condition with plain text i.e. abc but not working if right side condition value come from variable. In my case that value come from variable and that value is dynamic.

Thanks,

Dattatray

Hi @DATTATRAY PISE (WIPRO LIMITED),

Thanks for coming back with a response.

From the context I could understand that the value should be coming from the Variable. In that case, we can define the values in the variable and can use the variable in the contains condition. Please check the modified example below:

{
  "actions": {
    "Filter_array": {
      "inputs": {
        "from": [
          { "alias": "_V2_abc.Svc_CI", "definitionId": 63 },
          { "alias": "_V2_abcTEST.Svc_CI", "definitionId": 64 }
        ],
        "conditions": [
          {
            "left": "@item().alias",
            "operator": "contains",
            "right": "@{variables('myVariable')}"
          }
        ]
      },
      "runAfter": {},
      "type": "Query"
    }
  },
  "variables": {
    "myVariable": {
      "type": "string",
      "value": "abc"
    }
  }
} 

If the issue persists, please do not hesitate to reach out further assistance. If you find this answer helpful, please click "Comment" and kindly upvote it.