cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JC2288
New Member

Help Extracting String from Object Array

This is the output of my Array. 

 

[
     {
          "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
          "Claims": "i:0#.f|membership|kev1234@company.org",
          "DisplayName": "Smith, Kevin",
          "Email": "Kevin.Smith@company.org",
          "Picture": "https://company.sharepoint.com/sites/UserPhoto.aspx?Size=L&AccountName=Kevin.Smith@company.org",
          "Department": "Finance Data",
          "JobTitle": "Financial Analyst 1"
     }
]

 

I am seeking only DisplayName, as a string, like this:

 

Smith, Kevin

 

Please help, please provide very clear instructions.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

This is very helpful and parsing JSON was successful. The video was also very helpful. Appreciation for your help. 

View solution in original post

4 REPLIES 4
Ankesh_49
Power Participant
Power Participant

@JC2288 Please refer it for your solution:

https://powerusers.microsoft.com/t5/Building-Flows/Extract-value-from-an-object/td-p/422924

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-extract-elements-from-array-and-as...

https://powerusers.microsoft.com/t5/Building-Flows/Extract-only-Record-value-to-an-array/m-p/1587876

 

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

JC2288
New Member

The first URL is not helpful because it is extract string from object. In my case I am not extracting from object, I am extracting from Array. 

The second URL does not show the code used in the expression.

The third URL is extracting from Array to Array. This is not my scenario. I am extracting from Array to String.

I am new to Power Automate so I am requesting a specific solution to my scenario if possible.

 

Ankesh_49
Power Participant
Power Participant

@JC2288 Use Parse JSON

 

Ankesh_49_0-1656624204749.png

 

In case of any issue wrt interpretation, refer this video : https://www.youtube.com/watch?v=6nJSUNh579w

 

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

This is very helpful and parsing JSON was successful. The video was also very helpful. Appreciation for your help. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,803)