Unanswered

Duplicate SharePoint List Items and Increment Year by 1

(0) Share

Report

Posted on by cmndflom

Hi All,

I have a SharePoint list with a year column - what I am trying to do is:

Duplicate all items in the list and for all of the duplicated items, increment the year column by 1. So if they currently say 2022, then the duplicated list should show all the same values except the "Year" column will show 2023.

I am struggling to get this logic working and I am not sure which step to do first after Get SharePoint Items. Any guidance would be immensely appreciated. Thanks!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Ventit 422 on at

Like (0)

Report
Copy link

Link copied!

Simply then do a create item based on the same list and populate the fields with the get items. This will be turned into an apply to each and replicate through every record. If there are a lot of records need to ensure you have modified the settings in the get items to turn on pagintation. Set to max of 5000. You cannot do more than this. If more there are work arounds

In the year column type 2023 - I assume it is a text field or number field. If you are adding to date use an expression like
formatDateTime(adddays(datefield),365),'yyyy')

Was this reply helpful? Yes No
cmndflom 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply! Say I wanted to make the Year column dynamic in my flow so that I won't have to go in every year and update it to the next year in the Create Item section - how would I go about doing that?

Was this reply helpful? Yes No
Ventit 422 on at

Like (0)

Report
Copy link

Link copied!

Simply put the expression formatdatetime(addDays(utcNow(),365),'yyyy')

This will add 365 days to todays date

Was this reply helpful? Yes No
cmnflom 18 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure I'm following how to set this up - in the 'yyyy' do I put the current year?
I currently have the year hard coded as "2023" so that when this flow is triggered, it will create 2023 items. How do I modify that so that it will increment it to "2024" the next time I run the trigger?

Was this reply helpful? Yes No
Ventit 422 on at

Like (0)

Report
Copy link

Link copied!

The formula I gave adds 365 days to the current year it is run. So if it was today it would be 2023

Was this reply helpful? Yes No