I have a SharePoint list having a Notes and another NotesHistory field. Every time user puts some note that should get appended with the NotesHistory field and the original Notes field gets reset.

Requirement is to store the notes in JSON string array as below. [{"Date":"16/3/2021","Notes":"This is a sample note1"},{"Date":"16/3/2021","Notes":"This is a sample note2"}]

So, each time the notes gets added how would I append the {"Date":"16/3/2021","Notes":"This is a sample note3"} to the above JSON array retrieved from the current list item using Power Automate

Please help me on this.

1 Answer 1


You could either use [Append to array variable] action or union() function like union(variables('arrayNotes'), variables('arrayNoteItem')) to add a new item to the original array.

See the screenshots below.

enter image description here

Using Union function

enter image description here

  • @Matiur_Rahman, this is great info. I didn't know union was so powerful. Thank you
    – SeaDude
    Commented Mar 2, 2022 at 6:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.