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 / Retrieve sharepoint me...
Power Automate
Unanswered

Retrieve sharepoint metadata column value

(0) ShareShare
ReportReport
Posted on by 33

Hi everyone,

Hope you are doing well.

I'm trying to retrieve a value from a column in a sharepoint list. This column is made of metadata from my organization, and display job titles correctly in the list

DamienMG_0-1684767700155.png

But when i try to get this value in my power automate flow, i get this:

DamienMG_1-1684768155681.png


{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid":"6445c8e7-e341-4e60-a0e8-e750849e2799","WssId":15,"Label":"15","Value":"15|6445c8e7-e341-4e60-a0e8-e750849e2799"}


As you can see, i can't even retrieve the job title from "Value", so i'm a bit stuck.
I was thinking of building an association table between the Label and the expected value, but can't find it in the Azure directory.

If anyone can help, it would be greatly appreciated.

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Damien-MG 

    is that column represents job titles of indiviuals in sharepoint list ?

  • DF-04091330-0 Profile Picture
    33 on at

    Hi @Nived_Nambiar ,

    Yes the column do represents job titles of individuals, and seems to be related to Azure, since it autocompletes the different jobs in the choice list.
    Thanks

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

    Hi @Damien-MG 

     

    is there any other attribute starting with this in dynamic contents?

     

    Also

     

    does the value present in json you have shared represents the unique id of job title ?

     

     

  • DF-04091330-0 Profile Picture
    33 on at

    Hi @Nived_Nambiar 

     

    Thanks for your help !

    Yes Managers from my organization are displaying the same way in my sharepoint.

    DamienMG_1-1684932836086.png

     

     

    And for this, it is working corretly since i can retrieve the name in my flow

    DamienMG_0-1684932657848.png

     

    And yes i suppose the values in the json are unique Ids related to job titles, since the number is different each time i try with a different job title in the sharepoint.

     

    Thanks

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

    Hi @Damien-MG 

     

    Could you show the complete list of dynamic contents ?

     

    Also just to know where we can get the job title details ?

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 273 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 149 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 144 Super User 2026 Season 2

Last 30 days Overall leaderboard