Answered

Trying to write an expression instead of using Filter Array

(1) Share

Report

Posted on by AI-24061946-0

Hello everyone

I create this follow array using a Select action after List Buckets Action for a MS Planner Board. I am wondering if I can write an expression instead of using a filter array and then a compose to get the bucketid when the bucketname is "To do".

{
    "body": [
        {
            "bucketid": "xOfg9k9Xu0-DmGU3PHdQPGQAANep",
            "bucketname": "Done"
        },
        {
            "bucketid": "uskhJSr-tUaZGan7DeIvOGQANnfy",
            "bucketname": "Hold"
        },
        {
            "bucketid": "EXaN1yv3m0y4CnDpJS0IHGQADIFF",
            "bucketname": "In Progress"
        },
        {
            "bucketid": "knOOX-GfSUuN4HjPC9n6ZWQAAkhY",
            "bucketname": "To do"
        }
    ]
}

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

I believe Filter array is your best bet here, unless the bucket is always returned as the 3rd element for example. In that case you could do Array[2] for example. Is there any reason you would like to get ridd of the Filter array? In my experience its very fast.

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
AI-24061946-0 20 on at

Like (2)

Report

I am new to this platform and wanted to see if there are other ways of accomplishing this, but your answer makes perfect sense as I am doing that currently and thank you for your prompt response.

Was this reply helpful? Yes No
Verified answer

WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report

If you absolutely must avoid using the Filter array action, you can convert the JSON array to XML and then use the xpath() function to lookup an individual item on the buckename and return the bucketid.

1. Original JSON

2. Add a root property

3. Convert to XML

4. XPATH function

Output is the bucket ID. No Filter array action:

Big question though: Why would you do this? It's more work.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report
first( xpath( xml( addProperty( json('{}'), 'Root', addProperty( json('{}'), 'Item', body('Compose') ) ) ), '//Item[bucketname="To Do"]/bucketid/text()' ) )

Was this reply helpful? Yes No
AI-24061946-0 20 on at

Like (0)

Report

Thank you so much for opening up my eyes about using Xpath. You are 100% correct that at my beginning skill level, using the Select array gets the job done. I wanted to see how advance users would handle this issue using other mechanisms.

Was this reply helpful? Yes No