Answered

Help Extracting String from Object Array

(0) Share

Report

Posted on by JC2288

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.

Categories:

General topics

All responses (4)

Answers (1)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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-assign-it-to-a-string/td-p/1338805
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 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@JC2288 Use Parse JSON

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.
Verified answer

JC2288 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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