read specific data from array after get items from a list

(0) Share

Report

Posted on by P4AndiIT

Hi,

I use the action "get items" on a SharePoint list. I get the following result (see below)

How can I access the individual values?

for example the text "Example Text" from the column "Wert1"

{
"value": [
{
"@odata.etag": "\"4\"",
"ItemInternalId": "1",
"ID": 1,
"Title": "Erster Eintrag",
"Wert1": "Example Text",
"Auswahl1": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Auswahl 2"
},
"Auswahl1#Id": 1,
"Datum10": "2023-01-25T08:00:00Z",
"{Identifier}": "Lists%252fBautagebuch%2bDemo%2bTeam%252f1_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},

Categories:

Using connectors

All responses (4)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@P4AndiIT

If your question is how can you refer to Wert1, that data should be available in Dynamic properties under the Get items action.
P4AndiIT 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ScottShearer,

I do not have access to the Dynamic Content that you have highlighted in yellow, because I have the necessary list selected dynamically beforehand. This is not fixed. I only have access to "value" and "body" (see screenshot).
The flow takes all the lists of a team (I don't know beforehand how many lists there are) and takes elements with certain criteria from each list.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@P4AndiIT

Sometimes you can add a compose action and will have access to the columns. Then, you can reference the Compose action.

Please post a wider screen shot of your Flow. If you do, I can suggest syntax that will allow you to directy refernce the columns that you need.
P4AndiIT 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @ScottShearer
the flow is a bit longer, so a few more screenshots
(sorry, actions are in german language)

First, i search all teams which are not archived

Then I get the website address and call up all the lists of this websites
After that, i only want lists, with a certain word in the beginning of the name in each website

When I have found the right lists, I search for all elements in the respective list that have a certain status / criteria.
I append each result (element) to an array variable

After that i have a array with my desired results. this works fine.
The results in the array are then listed as I wrote in my first post (see above).
Now I would have to split the found elements from the array individually to write them into a new list.

Thanks for your help