Showing results for 
Search instead for 
Did you mean: 

How to dynamically create records from one master list to another using Flow.

To fulfill this requirement, we first create a schedule master list which is having some items such as: (refer Image 1)



Sample values of data: (refer image 2)


Now, we create preventive documents list with following columns: (refer image3)


Now, we create a Microsoft Flow to create these schedule records:(refer image4)



This is the condition where we have to check today`s date with last created date

Formula in condition is when we clicked on advanced mode:

@equals(formatDateTime(utcNow(), 'MM-dd-yyyy'), formatDateTime(items('Apply_to_each')?['NextCreationDate'], 'MM-dd-yyyy'))


Now, if the condition is met then we have to follow these below steps else we do nothing.(refer image6)


Here, I am explaining all steps (refer image 7)

image 7image 7


addDays formula is :



LastCreatedOn : formatDateTime(utcNow(),'MM-dd-yyyy')

NextcreationDate: formatDateTime(variables('varNextCreatedDate'),'MM-dd-yyyy')


This flow now runs on everyday and find records in ScheduleMaster list which is required to be created on today and then update LastCreatedOn as of date created and sets the next creation date by adding days which is specified.



* This solution can attach all attachments too from one master list to another. 

Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • My name is Timothy Shaw and I create digital solutions using the Power Platform, Office 365, and Azure SQL and handle the IT for a small company in the energy sector. When not building the future :), I enjoy playing guitar, good (or really bad!) sci-fi, Xbox therapy, and hanging with my wife and son. Twitter: @ShortForTim