Power Platform Community Forum Thread Details

I have a Powerflow that queries data from 8 different PowerBI reports (this is working as expected with no issues). That data is saved into a SharePoint list in a column called "Current %".

This flow will run weekly. My challenge is that on each subsequent run, I need to move the data over a column. By that I mean that the current run should send data to the Current % column.

Next week when it runs that data should be moved over to the "Week 1" column, and new data will replace the "Current %".

Two weeks from now, the original data should be moved to the "Week 2" column, etc.... What is the best way to do this? Has anyone had a similar need?

Thanks!!