In Logic Apps I need to filter an array but the values are upperlowercase, how can I filter using an operator that doesn't require case sensitive value?

Question

In Logic Apps I need to filter an array, but the values are upper lowercase. My variable is all lower case.

How can I filter using an operator that doesn't require case sensitive value?

Or I need to convert array to all lowercase, how can I do that?

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

• You can use the toLower() function to convert both the array elements and the variable to lowercase before comparing them.

    {
        "FilterArray": {
            "inputs": {
                "from": "@variables('YourArrayVariable')",
                "where": "@equals(toLower(item()), toLower(variables('YourVariableToCompare')))"
            },
            "runAfter": {},
            "type": "Query"
        }
    }
  

• If you need to convert the entire array to lowercase before filtering, you can use the map() function along with toLower()

    {
        "ConvertToLowercase": {
            "inputs": {
                "from": "@variables('YourArrayVariable')",
                "select": {
                    "value": "@toLower(item())"
                }
            },
            "runAfter": {},
            "type": "Query"
        }
    }
    
  

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Answer 2

@Duquette, Timothy Thanks for reaching out.

You should use the item as below for your filter array for your JSON object to compare with any of the property.

"Filter_array": {
                "inputs": {
                    "from": "@variables('myinput')",
                    "where": "@equals(toLower(item()['resourceType']), toLower(variables('compare')))"
                }

I have validated the same with your custom JSON object and it return only the element which has availabilitysets value (ignoring case) for the resourceType property in your JSON object as below.

For more details you can refer to this document.

Let me know if you still face any issue and I will be happy to assist you.

Please click on 'Yes' if it helped so that it can help others in the community looking for help on similar topics.