IfError + Patch a blank value with Formula-level error management

[@oluwatobiyusuf]

Thank you Shane. Patching a blank value was a take home for me

[@anantharamakrishnan19]

Thanks Shane. I haven't much tried patching blank but always thought I can patch blank. I knew you can use unrelate to make the related field as Nothing.(when you have no behaviors set) This is like - What!! wasn't this possible earlier in patch!! Good to know. :)

[@ShanesCows]

The little nuances like that are interesting.

[@jeanpierreragequit1726]

til today i patched my sharepoint list in this way : Patch( MyDadataBase; Title="My Title"; Value=" " ). Happy learn u can patch blank(). Many thx Shane one more time !! Converserly , i discovered 2 months ago an empty field in a sharepoint list was blank by default ( & not empty )

[@Leo_Russo]

Boa Shanao deitou no role 🚀🚀

[@ShanesCows]

obrigado

[@oembol]

I'm troubleshooting this exact problem right now, except for .mobilePhone attribute. Thanks for the video Shane!

[@ShanesCows]

Glad to help :)

[@AmyCustomer]

Hi Shane, I tried turning on that feature and I was unable to patch a null from a control, is there a difference between patching a null valued control vs the function Blank()?

[@ShanesCows]

Amy I would need more specifics on what you are trying but should be possible.

[@saveeshmply]

Good One Shane - You are a real Guru :)

[@ShanesCows]

Thanks

[@yehunlavolontededieu322]

Unfortunately this feature being turned on caused an issue to the 'OnStart ' deep linking. All deep links stuck with 'Getting your data' upon opening the links. Any other way/solution to set SP choice field values to null/blank?

[@RUBENARTUROGALLARDODELCARPIO]

Hi, thank you so much for the amazing video. I have a question. If I have 2 pach inside a IfError and the first patch pass without error but the second have an error. The first patch will register the data in my sharepoint list? if that happend, what can I do to only register the data when all patches are okey

[@Excel-power-users]

Hello Shane, I have question do you have any content where you have show cased how to track an employees login and logout and see if the employee is on break or not. Sorry for out of the topic question. Regards Santosh

[@ShanesCows]

I don't, sorry

[@minnies83]

Thanks for the video again. I always learn a lot and grown up error handling is definetly something I will adopt. This video was very helpful again. 🙂

[@powerhub9553]

You are amazing!!! Thanks Shane, great job.

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@dougydoe]

Wow! This is brilliant! I worked along so how cool this is first hand. Thanks for sharing. Hopefully, it goes into GA soon. 🤣🤣🤣

[@ShanesCows]

I hope so too!

[@s961201]

Anyone else having trouble with new errors being introduced when turning on "Formula-level error management"? Suddenly I get on start error messages "text cannot be converted to number". It's a gallery showing plain text field from a sharepoint multiline text column. I've noticed this a few months ago in another app too but then I just assumed it was a bug being an experimental feature. But it's so strange that noone is mentioning this in any threads or videos. Tips anyone??

[@franknielsen3219]

So if I enable this feature and get a bunch of errors from all of my app, I then have to go to every app and take care of these to make the apps work? BTW - cool video as always

[@ShanesCows]

Yup Frank. Sadly Mark had 200+ to fix when he did it.

[@johanynavarro8065]

As usual excellent video buddy... Quick question... in App.OnError a Patch() to create an item on SP list, however, the FirstError.Message sometimes, not always, is blank :( I got the control name but no idea what's the issue... any idea legend???

[@ShanesCows]

YOu could add logic using AllErrors and see if you find something that way. Concat(AllErrors, Message, ";") try patching something like that and see if you get what you want. Code is off top of my head so may not be exact. :)

[@johanynavarro8065]

@@ShanesCows I just modified the Patch() in App.OnError... will let you know buddy... many thanks...

[@johanynavarro8065]

@@ShanesCows I added that logic, It helped me to understand most of the errors, however, the button that triggers a flow is still showing no empty description of the error but the flow runs anyway :( :( :( :(

[@PowerAppsEric]

Does IfError() work like a Try-Catch function where you can do a series of functions with a single error handle, or do you have to have nested IfError() functions, or is it IfError(action1,errorHandle1,action2,errorHandle2,...)?

[@ShanesCows]

IfError(action1,errorHandle1,action2,errorHandle2,...) is the way it works. But you could wrap IfError in another function that triggers only if any output errors. :) At least in my head that should be do able.

[@stevenvits152]

you are a hero!

[@ShanesCows]

Thanks Steven. I really enjoyed this one.

[@alexhaigh9575]

Thank YOu!

[@ShanesCows]

Glad to help!

[@EVSTN25]

🔥💙

[@ShanesCows]

🙏

[@EVSTN25]

@@ShanesCows always your video very helpful... Thanks lots....

[@angrybatvoice]

👊

[@ShanesCows]

💪💪💪