How to get the output body/value from multiple lines

Like (0) Share

Report

Posted on 10 Oct 2023 08:46:08 by Scherodan

Hi All,

I need your help how to get all values of a combi field for a sharepoint list.

Example below. I need to get the value of multiple lines.

Result should be 'Value 1' and 'Value 2'

Thx Martin

{
"statusCode": 200,
"headers": {
},
"body":
"Test1": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 237,
"Value": "Value1"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 67,
"Value": "Value2"

All responses (11)

Answers (1)

Verified answer

AndreasN 307 Super User 2024 Season 1 on 10 Oct 2023 at 12:34:13

Like (1)

Report

Re: How to get the output body/value from multiple lines

Is your compose 6 action pointing at the specific column or the whole output of your "get item"?

The output of your compose 6 looks off, it should not return ID and all the other columns, but only the values of your "value" column from your "get item".

As you can see mine does: