Hello,
I have a drop down that is used for the user to set how many weeks they wish to repeat a booking which is then stored as a global variable.
So example @RepeatFor= 4
I then need to append this data to the SharePoint list repeating for the number of times in @RepeatFor and append 7 days on each time.
Im getting errors and I'm going round in circles trying to fix it. Could someone please help ?
Set(repeatCount, RepeatFor);
Set(Increment, 0);
ClearCollect(loopFor, Sequence(repeatCount));
ForAll(
loopFor,
Patch(
'Desk Reservations',
Defaults('Desk Reservations'),
{
Title: selectedPerson.DisplayName & " " & ThisRecord.Title,
DeskText: ThisRecord.Title,
'Check Out From': DateAdd(DateAdd(startTime, Increment, Days), TimeUnit.Minutes ),
'Check Out From Text': DateAdd(startTime, Increment, Days),
'Check Out From Number':Value(Text(startTime,"yyyymmddhmm")),
'Check Out To': DateAdd(DateAdd(endTime, Increment, Days), TimeUnit.Minutes ),
'Check Out To Text': DateAdd(endTime, Increment, Days),
'Check Out To Number': Value(Text(DateAdd(endTime, Increment, Days),"yyyymmddhmm")),
ReservedBy: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & selectedPerson.Mail,
Department: "",
DisplayName: selectedPerson.DisplayName,
Email: selectedPerson.Mail,
JobTitle: "",
Picture: ""
}
}
)
Set(Increment, Increment + 7)
);
