Unanswered

use values of objects within an array to create item in sharepoint list

(0) Share

Report

Posted on by StijnVerbeeck

i have an array with multiple object. Each object contains 3 values separated by a komma (,). a number, a displayname and a department. each object of the array must be imported in the sharepoint list with three columns (nr, displayname and department) in a new row. So, if the array has 4 obects, the list must be append with 4 new rows and ach row must contain the three corresponding values.

Categories:

Building flows

example of array.jpg

I have the same question (0)

All responses (7)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report

That's some strange JSON you have - values are the field names. Is this array of objects something you create yourself from some other data within the flow, or is it the data that comes from somewhere and you have to use it as it is?

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Hi @StijnVerbeeck ,

If I have understood the question correctly, you want to do the following: create a new SharePoint item for each JSON object in an array.

For example

Here is one method you can use to achieve this:

A variable containing the data:

We can use a Select action to transform the data into a new JSON array so that the properties are clear and easy to reference:

The expressions used in the Select action are:

nr: json(concat('[',replace(slice(string(item()),1,-1),':""',''),']'))?[0] displayname: json(concat('[',replace(slice(string(item()),1,-1),':""',''),']'))?[1] department: json(concat('[',replace(slice(string(item()),1,-1),':""',''),']'))?[2]

An Apply to each loop is then used to create new items in the SharePoint list using the Output of the Select action:

The expressions used in the Create item action are:

items('Apply_to_each')?['nr'] items('Apply_to_each')?['displayname'] items('Apply_to_each')?['department']

See: 📝Short Notes: Illustrating the Item() and Items(‘Apply_to_each’) function in Power Automate

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
StijnVerbeeck 8 on at

Like (0)

Report

That works pretty well! Thank you @ekarim2020

Was this reply helpful? Yes No
StijnVerbeeck 8 on at

Like (0)

Report

The "strange" array i have is a variabele array C. I compare two arrays A and B and the json objects that don't exists in array B are appended in the variabele array C. This array C is the source creating new items.
Array A is a http requets for group members in Azure followed by a "parse json and a select to just keep the needed fields.
Array B is the result of "get items" from the sharepoint list also followed by a select.
I suppose there are more elegant ways to achieve a sync between group members ad a sharepoint list, but i'm learing.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

@StijnVerbeeck Are you able to show the flow and how it creates your array? I think if you fix that so it stores the JSON property/values correctly, then you would end up with a much cleaner flow.

Was this reply helpful? Yes No
StijnVerbeeck 8 on at

Like (0)

Report

i start with a http request followed by parse json to remove headers from the request and just keeping the body.
then i use a select and now i see that is where the fieldnames disappear. I used the select action cause i found it in other solutions for filtering and comparing two arrays and because my fieldnames (in case columnnames) are different (id and nr, displayname and leerling, department and school).

the same steps i do for the get items for the list

in the end i apply to each for comparing the values of the select (all items of the group members). If an item of the list not belongs to the current item, i append that current item to the third array (my variable array)
on the" if-yes"side i have now an array with items that are group members (http request) that are not in my sharepoint list. And that's where i start begin to ask for help.
next goal: on the "no-side" of the condition update the items in the list that already excist but where the department has changed.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
For your Select 2, you should add the values on the Right, and the property names on the Left. See example below. This would avoid having to go through trying to convert everything to get back to this.

Running the flow with four objects would give us something like below:
[ { "id": 1, "displayName": "Bob", "department": "HR" }, { "id": 2, "displayName": "Jane", "department": "IT" }, { "id": 3, "displayName": "Sarah", "department": "HR" }, { "id": 4, "displayName": "Andy", "department": "Finance" } ]

And exactly the same idea for your Select with the SharePoint values. Property names (you can type whatever you want) on the Left, and the actual values on the Right.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No