Adding multiple entries in SharePoint with incremental dates

(1) Share

Report

Posted on by CU-18081603-3

I have two SharePoint lists. SharePoint List -1 & SharePoint List 2.

SharePoint List -1 - receives its input from a Power App. These inputs have data such as Task name, start date, End Date, and number of days (End Date - Start date).

Once this input is received from the power apps - It is updated in SharePoint list 1.

Based on the No.of days count in SharePoint 1 - I want to create multiple entries in another SharePoint list (SharePoint 2). Each entry in SharePoint 2 should have the same data as the original entry but with the start date incremented by one day for each subsequent entry, continuing until the end date is reached.

Can anyone please help me with how I can achieve it using Power Automate?

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

Trigger: OnCreate (I would only do with new items, not OnUpdate)

Initialize Variable: Integer - intLoopCount* = 1

Initialize Variable: Text - txtNextDate = StartDate (<--field from list)

Do Until: intLoopCount > NumberOfDays (<--Field from list)

Create Item:

{Add all of the columns that need populated, and use txtNextDate}

Add Days: (Use this action to calculate the next day.)

Set Variable: txtNextDate = Value calculated in Add Days

Increment Variable: intLoopCount, 1

//End Loop

//End Trigger

*You don't really NEED to use the loop counter integer, as you could probably key the loop simply off the Dates, but the integer might be cleaner.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

one conformation needed- does the data in sharepoint list 2 - should have these columns - task name, start date, end date and number of days as well where only start date changes ?

Was this reply helpful? Yes No