Unanswered

Trying to automate copying data with multiple row columns

(0) Share

Report

Posted on by Shoekstra

Hi,

So I'm new to Power Automate and I'm trying to figure out how to copy certain items from a sharepoint list to the same list, I've added a screenshot of what the data would look like.

What I wanna do here is copy all the data from the last month (for example the highest month in this case is 3) and then copy it into the same list and change the month of the newly copied values to 4 (so that month 3 and 4 are the same) > and repeat this process the next month so that it copies all data from month 4 and pastes it with month 5.

Let's just say month 1 is january month 2 is february and so forth, they're linked with a foreign key to another sharepoint list.

How can I do this with Power Automate?

And secondly I seem to have issues trying to copy data that has data type ''multi row'' in sharepoint, is there a good workaround for this? how to copy all this data without getting errors.

Categories:

Building flows

data.png

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report
If I understand you correctly, these actions will achieve what you want, which you can use with a scheduled flow that runs once per month:

In the Get items action you can use the filter query Month eq [expression to get prior month number] on your Month field, which assumes it is of type number set to zero decimal places. The expression would be:

int(addDays(startOfMonth(utcNow()),-1,'MM'))

The condition just checks to make sure items were found. The expression on the left side of the condition is:

length(outputs('Get_items')?['body/value'])

In the Create item action:

Just populate the fields with the prior month's data and use this expression to set the current Month value:

int(formatDateTime(utcNow(),'MM'))

If you have a lot of items that need to be copied each month, you could have some issues with threshold limits.

I don't know what you mean by "multi row" so I cannot speak to that. In lists, each item is a row,

Result:

Was this reply helpful? Yes No
Shoekstra 55 on at

Like (1)

Report

Thank you David!

I will try it out after my vacation and let you know how it goes!

Have a good weekend.

Was this reply helpful? Yes No
Shoekstra 55 on at

Like (0)

Report

Hi David,

Sorry for the late response, things got a bit busy after my vacation! I've tried it and it works like a charm, thank you very much for your help.

Was this reply helpful? Yes No
Shoekstra 55 on at

Like (0)

Report

Hi David,

Sorry for the late response, things got a bit busy after my vacation! I've tried it and it works like a charm, thank you very much for your help.

Was this reply helpful? Yes No