Answered

Value out of an item/column

(0) Share

Report

Posted on by kilaj1

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:

 "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?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @kilaj1

Pass the above data in Parse JSON, the. Just select the dynamic field of value.

Follow the steps in the video:
https://www.google.com/search?q=parse+json+power+automate&oq=parse+json+power+automate&aqs=chrome..69i57.9243j0j7&client=ms-android-oneplus-rvo3&sourceid=chrome-mobile&ie=UTF-8#fpstate=ive&vld=cid:160f2bf6,vid:e0dzMqoJGtY

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

Was this reply helpful? Yes No
kilaj1 257 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kilaj1

Please modify formula to this:

item()?['DeferreY_x002f_N/Value']

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

Ajinder31 530 on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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:

//Assuming your Apply to each was named: Apply to each items('Apply_to_each')['Deferre Y/N']?['Value']

Was this reply helpful? Yes No
kilaj1 257 on at

Like
a
(0)

Report
Copy link

Link copied!

This one worked thanks!

This was a get items from SPO list and then a Select action it was not wrapped in a apply for all.

Thanks for all the responses!

Was this reply helpful? Yes No