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 / Create Multiple Period...
Power Automate
Answered

Create Multiple Periods for Each Date and Lab

(0) ShareShare
ReportReport
Posted on by 35

Hello,

 

I am creating a Lab Booking system where I want to automate the creation of bookable slots in my SharePoint list ("Slots").

 

In excel, I have 3 tables.

 

  • 'Labs' (there are 6 labs)
  • 'Dates' (there are 100+ dates)
  • 'Periods' (there are 8 periods)

 

For each lab, I want to batch create SharePoint list entries for all 8 periods for each date.  This would be a manual start flow.

 

If someone could detail the steps in Power Automate for me, this would be very helpful.  I have explored "List rows present in a table" and "Apply to Each", but I can't quite get the process right.

 

Many thanks in advance

 

Rachel

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @rachel_bisland ,

    That should work, you need to reference the values from those actions in your Create item action

    SudeepGhatakNZ_0-1707876257906.png

     

  • Verified answer
    rachel_bisland Profile Picture
    35 on at

    Hi Sudeep,

     

    This solution is failing on Create Item.  I feel I have setup the flow as you described - perhaps except for the "apply to each - select an output from previous step".  This isn't detailed in your screenshot as you are on the new designer, but is a required field.  What did you select?

     

    Thanks

     

    Rachel

     

    rachel_bisland_0-1707903840571.png

     

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Can you expand your Create item action?

    What is the error you are getting.

    It is quite late in NZ, I will respond back in the morning.

    If you send me a sample excel, I can build a flow sample for you.

    Have a good day.

     

  • rachel_bisland Profile Picture
    35 on at

    Hi Sudeep,

     

    I worked it out from your solution.  Thank you.  I had an issue in one of my Date/Time formats within the create item but have now resolved.

     

    Rachel

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard