How to get the output body/value from multiple lines

(0) Share

Report

Posted on 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"

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

AndreasN 318 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

can you please share a screenshot of your flow? This will make it much easier to assist you.

Best regards - AndreasN

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@AndreasN thx for your answer. Not really know what I should capture from screen as I need a logic to build 🙂

At least I have a get item action - and within the resutl you find the json above. From this in need the values to use this for a reference on another get item action.

Was this reply helpful? Yes No
AndreasN 318 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Scherodan

Okay, there's two different IDs in your JSON so are you extracting two different items, or is it one item with multiple values?

Are you using "Get item" or "Get items"?

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@AndreasN Thx you.

I use Get item (only one specific) and within this output the json above is coming. So both value sit within one.

Was this reply helpful? Yes No
AndreasN 318 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Scherodan

Okay, so you have to loop through both choices if it's a multi choice column.
A simple way to do this, is simply to compose your "value" column, with a compose action. This would apply a "for each" loop. Given you want the output to be both values, you can initialize a variable and append the composed value in your apply for each.

Like so:

Your variable will then store the values for you.

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@AndreasN

now I get both values double 😞

Was this reply helpful? Yes No
AndreasN 318 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you show me how you've set it up??

This is how I've done mine:

The input for the compose action is my multi choice column called "test value".

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@AndreasN

It looks like this. The problem seems to be that I have to "xxx.value" column in my list as the column is the result of a lookup column.

Was this reply helpful? Yes No
Verified answer

AndreasN 318 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@AndreasN now I got it. Thx you so much! Much appreciate!

Was this reply helpful? Yes No