Power Platform Community Forum Thread Details

Good Afternoon Everyone,

I am new to the Power Apps arena, having watched Shane young videos to help my progress. I have seen many posts on this forum that have helped a great deal.
I now have a puzzle which I cannot figure out. (shane does have a video which is pretty much what i want but i think it misses some key steps or understanding that i have yet to develop.)

And iIcannot get it right with CoPilot!

So what I am trying to achieve:

I need to create a set of appointments on a certain day.

I need 9 appointments on this day, 20 minutes apart starting at 0900hrs.

These 9 appointments will then be published to the sharepoint list.

A customer then sees that this day of appointments is now available and wants to book the timeslot. An email will then get sent confirming the booking.

Now where I am struggling is:

I can create the 9 timeslots to be displayed in the gallery by doing this:

ClearCollect(

colBusinessHours,

ForAll(

Sequence(9),

Time(9, 20 * (Value - 1),0)

))

That gallery is then linked to the collection. I have added an extra field to capture the date from a date picker:

ThisItem.Value & " " & DatePicker1.SelectedDate

In a button, what I thought i could do was create a new collection of the 9 items and the date from the gallery, and submit them, to the sharepoint list.
AA_create_time_slots is the list naame, with columns: Row Number = number, title = single line of text, timeslotanddate=date and time, reserved = yes/no, reserved by single line of text.

I have been successful in patching single lines, but cannot figure out how to patch all 9 records in one go, with a single button press.

I appreciate your time reading this!

Regards

Brian

Categories:

Building Power Apps