
Hi!
I have a project tracking list on Sharepoint that it is linked to Microsoft Power Automate.
I created a list that contains Weekly Status and Cummulative Status.
Once a weekly status is updated, this information should be copied to the cummulative status. I know there is an option to "copy item" however I need this to be cummulative, showing every weekly status update. Let me give you an example:
Hope someone can help me
| Project ID | Weekly Status | Cummulative Status |
| AB001 | 15/01 - Meeting with client | 15/01 - Meeting with client |
| AB001 | 23/01 - Project on hold | 15/01 - Meeting with client 23/01 - Project on hold |
| AB001 | 24/01 - Project closed due budget | 15/01 - Meeting with client 23/01 - Project on hold 24/01 - Project closed due budget |
@Anonymous
Hi there. Do you know how the Cumulative status is formatted? I'm guessing just text, ya? So I might try something like setting a "String Variable" at the beginning to the contents of the cumulative status, then after you grab the Weekly Status, you can "Append to String Variable" that thing onto the end of it.
The only thing I don't know is how to format it so it's on a new line. But I figured this might get you started.
Keep us posted.
-Ed-
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.