read specific data from array after get items from a list

Like (0) Share

Report

Posted on 3 Jan 2023 16:46:32 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
},

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (4)

Answers (0)

P4AndiIT 16 on 04 Jan 2023 at 09:07:25

Like (0)

Report

Re: read specific data from array after get items from a list

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

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 03 Jan 2023 at 17:28:33

Like (0)

Report

Re: read specific data from array after get items from a list

@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.

Was this reply helpful? Yes No
P4AndiIT 16 on 03 Jan 2023 at 17:20:47

Like (0)

Report

Re: read specific data from array after get items from a list

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.

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 03 Jan 2023 at 16:48:50

Like (0)

Report

Re: read specific data from array after get items from a list

@P4AndiIT

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

Was this reply helpful? Yes No