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

106

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:

Flow Mobile App

Business Process Flows

All responses (1)

Answers (0)

creativeopinion 10,450 Super User 2025 Season 1 on at

Like (0)

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

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