You’re offline. This is a read only version of the page.
257
I have a simple flow that gets items from a SPO list, once of the fields in a choice field. Normally for these columns in power automate you would select the entry with "ColumnName\value", I don't see this option for one particular column.
This is what a Select action shows:
Share
Report "Deferre Y/N": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "Yes"
}
],
I tried to use an expression
item()?['C3_DeferreYN_1/Value']
but this is returning Null
Is there a way around this?
I might as well jump in too 🙂
If you're access your items within an Apply to each, then you would access the item using the following expression:
All responses (
Answers (
//Assuming your Apply to each was named: Apply to each
items('Apply_to_each')['Deferre Y/N']?['Value']
Hi @kilaj1, I think below expressions should work. I assumed we're trying to get the first value in array.
I haven't tried it but let us know if it doesn't work.
first(item()['Deferre Y/N'])?['Value']
--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Thanks for the reply, I was hoping for an expression solution so i did try the two you suggested and unfortunately, they don't work.
I thought I read somewhere that the Item() expression has to be used with an array?
I've made some progress with the json method, but it seems fairly complexed just to pull one value.
Hey @kilaj1
Pass the above data in Parse JSON, the. Just select the dynamic field of value.
Follow the steps in the video:
Or also try one of the following expressions. Currently travelling so can't test.
item()['Deferre Y/N']?['Value']
or
item()['Deferre Y/N'].Value
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
