web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Adding multiple entrie...
Power Automate
Suggested Answer

Adding multiple entries in SharePoint with incremental dates

(1) ShareShare
ReportReport
Posted on by 2
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:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at
    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 ?
     
     
  • Suggested answer
    abc 123 Profile Picture
    789 Moderator on at
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard