Hi,
Is there any rollback kind of functionality available in powerApps?
I am using the below formula onSelect of a button:- (noteid is an auto-incrementing PK of SN table)
UpdateContext({callBack:
Patch('[dbo].[SN]',Defaults('[dbo].[SN]'),{
Note: Gallery3_9.Selected.Body,
NoteType: nT
}) });
If(IsBlank(callBack.noteid),
Notify("Something Went Wrong Try again",NotificationType.Error),
Patch('[dbo].[NB]',Defaults('[dbo].[NB]'),{ NoteID: callBack.noteid,
SId: id});
My concern is that what if my 2nd patch through some error because of any issue!
Should I delete the record which is inserted by the 1st patch function?
Or there is any better way to do it!
Please guide, Thanks in advance 🙂
Solved! Go to Solution.
Hi @beniwal
there could be numerous reasons, data source unavailable, permissions got updated and hence user cannot save/update item, column got deleted in data source etc.
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @beniwal
You would have to delete the record inserted by the first patch
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @RezaDorrani ,
Thank you for your response!
I want to discuss more on it, like what are the potential reason for a patch failure?
Specifically, I am asking if multiple users are inserting records in these tables "SN" and "NB", can that be one reason for patch function failure?
Hi @beniwal
there could be numerous reasons, data source unavailable, permissions got updated and hence user cannot save/update item, column got deleted in data source etc.
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
205 | |
94 | |
87 | |
47 | |
43 |
User | Count |
---|---|
252 | |
104 | |
103 | |
62 | |
57 |