Answered

Update sharepoint list items: add instead of overwriting

(1) Share

Report

Posted on by vipfafen

Hi all,

I have a SharePoint list with five columns. Except for one column, the remaining four are filled with information. Thats fine....

The fifth and last should run through a loop and add entries instead of overwriting them.

The final "Apply to each" loop looks like this:

Column Expression:

items('Apply_to_each_-_Update_sharepointItem')?['accessPackage']?['displayName']

The flow running into a "Succeeded" Status:

but.... the loop overwrites all previously set entries

Is there a add Funktion / Expression to avoid overwriting?

Sharepoint List "Append changes to existing text" is not a option. I need legible, first-hand information for the email automation task.

Thank you!

Regards

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

rzaneti 4,249 Super User 2025 Season 2 on at

Like (1)

Report

Hi @vipfafen ,

Assuming that your column is of string data type, you can use a concat() expression: concat([your_current_value], ', ', items('Apply_to_each_-_Update_sharepointItem')?['accessPackage']?['displayName']).

You must replace the text in red for the dynamic content of your current column value. Based on the image shared by you, it will probably be items('Apply_to_each)['Active_Zugriffspakete'].

Also, you must replace the text in blue for the separator that you want to use for each new displayName included in the column. I used a comma and a blank space as example, but you can change it for anything else.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
vipfafen 98 on at

Like (1)

Report
Thank you for feedback @rzaneti !

Datatype ist string i suppose. Sharepoint field-Type is "Multiple lines of text".

The expression I set looks like this
concat(items('Apply_to_each')?['Active_Zugriffspakete'], ', ', items('Apply_to_each_-_Update_sharepointItem')?['accessPackage']?['displayName'])

Output: However, the output is the same... old entries are overwritten, only a comma is now in front of each entry (, AP-Name).

Did I do something wrong?

Regards

Was this reply helpful? Yes No
vipfafen 98 on at

Like (2)

Report

ok, i got it.

wrong: "Active_Zugriffspakete"
correct: "AktiveZugriffspakete"

Was this reply helpful? Yes No
vipfafen 98 on at

Like (1)

Report

maby one more Questions, how to seperate by "new line" instead of comma?

I try this one, but get an error. Have to be placed right...
- decodeUriComponent('%0A')

Was this reply helpful? Yes No
rzaneti 4,249 Super User 2025 Season 2 on at

Like (2)

Report

Hi @vipfafen ,

You will need to store the decodeUriComponent('%0A') in a string variable or a Compose, and then use the dynamic content from this variable/compose into your concat.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
vipfafen 98 on at

Like (1)

Report
Solution in my case:
concat(items('Apply_to_each_-_Update_item_1')?['AktiveZugriffspakete'],decodeUriComponent('%0A'),items('Apply_to_each_-_Update_sharepointItem')?['accessPackage']?['displayName'])

Was this reply helpful? Yes No