web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Getting the Value of a...
Power Automate
Answered

Getting the Value of a Specific Column from the Get Items action and storing in a variable

(0) ShareShare
ReportReport
Posted on by 9

Hello All,

 

I'm trying to parse out the value a specific column coming from the Get Items action and store the value in a property. Fairly New to Power Automate Flows and not sure of the proper way of accomplishing this.

EnricoG_0-1697212534231.png

any help would be greatly appreciated

Categories:
I have the same question (0)
  • Verified answer
    EnricoG Profile Picture
    9 on at

    I figured it out. Looks like the proper expression to get the value from the "Status" column I wanted was 

    outputs('Get_All_Assignment_Items')?['body']?['value'][0]?['Status']?['Value']

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @EnricoG 

     

    So i can two ways how you can store column value in a variable.

     

    First way is to store column value of a specific item which is being iterated using apply to each . So here in my list , I have a column named Event Subject, so for every iteration/item in the list item, i want to store Event Subject value in a variable so that i can use it for other purposes for other steps in my iteration. So in that case, i would design like this

    Nived_Nambiar_4-1697213890099.png

     

     

    Second Method: You want to store entire column values to array format , for example The same above Event Subject has values like below

    Nived_Nambiar_1-1697213631165.png

     

    I want to get in a array format like below

    ['sample subject','Sample Subject']

     

    Then you should try like this:

    Click the highlighted section in Select action

    Nived_Nambiar_2-1697213756168.png

     

    Then pass the event subject dynamic content like this :

    Nived_Nambiar_3-1697213810239.png

     

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 636

#2
Valantis Profile Picture

Valantis 372

#3
11manish Profile Picture

11manish 335

Last 30 days Overall leaderboard