Trying to filter array using an option from a Choice SharePoint column that has both and "ID" and "Value"

(0) Share

Report

Posted on by melf123

I'm trying to filter my array by it's status column, which in this output is field_20.

I'd like to only keep the values with a status of 'deployed', but my status column in SharePoint is a choice column and comes with an ID and Value. How can I just select the value from this field? When I try using

item()?['field_20']['Value'] I get an error that it's only receiving null values when my first screenshot proves there should be some rows with a 'Deployed' status.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
Try to use this expression:
item()?['Value']
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No