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