Unanswered

Error handling while doing multiple patches to multiple SharePoint Lists

(0) Share

Report

Posted on by michaeldanieal

Hi guys, I'm currently working on a project where I have to make multiple patches to multiple SharePoint Lists. Now what I want to do is, if any one of the Patch() fails then the other patches should also fail. I tried to implement this using IsError() like this,

Scenario 1: pass the ID of the first patch to the second patch

If(

IsError(

Set(

patchVal,

Patch(list1,Defaults(list1),{col:val})//Patch ends

)//Set ends

)//is error ends

,//condition ends

Notify("Error while patching")

Patch(list2, {col:patchVal.ID})

)

Scenario 2: the patches are unrelated

If(

IsError(

Patch(list1,Defaults(list1),{col:val})//Patch ends

)//is error ends

,//condition ends

Notify("Error while patching"),

Patch(list2, {col:val})

)

Now the problem with this approach is that, sometimes the first patch works correctly and I get an error on the second Patch() only. Is there any way to cancel the first patch also if the second one fails. Thanks in advance.

Condition: If any one Patch fails then all the other patches should also fail.

@mdevaney @elseb @FLMike @WarrenBelz

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @michaeldanieal ,

You can use IfError function as well to detect error and then act up on.

Also, similar work around is carried out by this blog [Blog Link].

Hope this helps
michaeldanieal on at

Like
a
(0)

Report
Copy link

Link copied!

I read the blog, But I don't think this method would work if the internet connection is lost just after the first patch is completed. Any ideas/suggestions on that scenario. Thank you for replying.
elseb 774 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

you could wrap your patch in a var and check that var for content.

Set(varPatch1, PATCH_1_GOES_HERE),

If(!IsBlank(varPatch1), PATCH_2_GOES_HERE)
michaeldanieal on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, do you have a solution which would work if the internet connection is lost just after the first patch is completed. I want to rollback the first patch also if any one of the patch after it fails(even after internet is cut off after first patch).
elseb 774 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, there isn't a nice and neat way to do that. You could save the ID of the first patch in each of the following in the chain, then check if you have the full sett when new patch is created, this of course would not fix the issue of missing full record etc. If you're worried about the internet dropping I'd look in SaveData, LoadData this way you could store the data on the device and if check Connection.Connected goes back to true, patch that saved data.