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

Notifications

Announcements

Community site session details

Community site session details

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

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,129 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard