Unanswered

Patch function does not update record correctly if same record is updted my multiple user

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

We have one master list in sharepoint containing Capacity for Location, date and slot. When multiple users are booking from PowerApps forms for same Location, date and slot. Capacity is master list is not updating correctly. It only reduces by 1 and not by 3. For example, in master list lets say capacity is 10 for particular Location, date and slot. And 3 users booking for same Location, date and slot. All 3 users are getting message that booking made suxccesfully. But capacity is only reduced by 1. We are using Patch function for updating Master record. Due to this Master List is not showing correct capacity.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you share a bit more like what is you currant formula? that will help your chances of getting resolved quickly
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Below code we have written on button Onselect event. To validate and than Patch.

If(Value(Label7.Text)<>5 && !(IsBlank(DataCardValue2.Text)),Notify("Please enter valid WWID."),
If(
DataCardValue60.Selected.Result = "<select>" || IsBlank(DataCardValue53.Text),
Notify("Please select location."),
Set(
VarStatus1,
"Booked"
);
Set(
varCapacity,
DataCardValue53.Text
);
IfError(
SubmitForm(SharePointForm1),
Notify("Please enter all the required details."),
If(
Value(varCapacity) - 1 < 0,
Notify(
"Something wrong, please do refresh the page.",
NotificationType.Error
),
ClearCollect(
colAfterPatchMaster,
Patch(
Master,
First(
Filter(
Master,
Title = DataCardValue60.Selected.Result && Vaccination_x0020_Date = DataCardValue58.SelectedDate && Slot = DataCardValue24.Selected.Slot
)
),
{Capacity: Value(DataCardValue53.Text) - 1}
)
)
);
Set(
afterPatchCapacity,
First(colAfterPatchMaster).Capacity
);
If(
Value(varCapacity) - Value(afterPatchCapacity) = 1,
SubmitForm(SharePointForm1);
Office365Outlook.SendEmailV2(
User().Email,
"Vaccination Registration is completed successfully.",
HtmlText1.HtmlText
),
Notify(
"Something went wrong..",
NotificationType.Information
)
)
)
));