Hello,
I have two SharePoint lists, 'Training Events Data' and Training Events Delegate'.
The former holds records for all the events including course name, start and finish dates and times and each event has it's own unique ID (EventID).
The latter is to store the records if the delegates who've booked on to one of the available courses.
I want to patch the ID of the event from Training Events Data to Training Events delegates (Event ID) so I can use a count function to count how many users have signed up to that event.
In my Gallery, I have a text label titled "lbl_ID" which pulls the Event ID using "ThisItem.EventID' on the selected event.
I then have a button to book the selected event which is used to patch the details of the course to my Training Events Delegates list.
Patch ('Training Events Delegates', Defaults('Training Events Delegates'),
{
Title: Gallery_Select_Course.Selected.Value,
'Start Time TED': Gallery_TimeSlot.Selected.'Start Time',
'End Time TED': Gallery_TimeSlot.Selected.'End Time',
'Event ID': lbl_ID.Text
//'Delegate TED':lblDelegate.Value
});
Notify("Your training event has now been booked, you will receive an email confirming the details)",NotificationType.Success)
Title, Start Time TED, End Time TED are all patching successfully. The label is successfully showing the EventID from Training Event Data but it's just not passing a value over. Both respective ID columns in each SharePoint list are text columns, I've tried multiple variations of the formula IT hasn't worked.
I've also tried 'Event ID': 12345 and it successfully passes the 12345 over.
Any ideas?
