Build a flow that populate cummulative status

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (1)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Build a flow that populate cummulative status

@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.