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"
@AndreasN now I got it. Thx you so much! Much appreciate!
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:
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.
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".
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.
@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.
@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"?
@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.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1