Flow replaces old comment instead of adding new comment to old comment in a column of a sharepoint list

(0) Share

Report

Posted on by Mischa2710

105

Hi together,

my approval flow creates status comments in a column of a sharepoint list. Unfortunately the new comment overwrites the old comment. This should be avoided, but I don´t know how.

I tried to use the column with single line and multible line. Unfortunately not with the wished result.

I know that it works, as I´ve seen it in a great video from @Reza Dorrani.

Has anyone an idea? Thanks in advance.

Michael

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mischa2710

If you’re looking to append the comments to the existing column, you’ll need to get the current value of that column and append the new comment alongside the old. So your value in the column for create item will be both the existing column dynamic content value and the new dynamic content. Otherwise it will always overwrite with the new.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
Mischa2710 105 on at

Like (0)

Report
Copy link

Link copied!

Hi Damien,
that´s of course a possibility but I think it´s more a setting in sharepoint. If you take a look at Rezas video you will see that he didn´t include the old comment in his flow by creating the new comment in approval comments column.
So I think there must be another way. But nevertheless thanks for your help.
Michael

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Mischa2710

Reza is doing what I have explained. He is building up a new comment line and at the bottom of the comment section he is calling the last known content of the column, you see that as a green action.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
Mischa2710 105 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much. Oh my god, I´m so stupid, I´ve overseen this. 😁

Was this reply helpful? Yes No
Mischa2710 105 on at

Like (0)

Report
Copy link

Link copied!

done by mistake

Was this reply helpful? Yes No