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

Finally, the PowerApps Formula-level error management feature has moved from experimental to preview, which means I can make a video. You will learn how Formula-level error management add additional Power Apps functions like IfError, FirstError, and AllErrors. This allows you to better handle your PowerApps error messages and take control. In addition, Power Apps Formula-error management also allows you to Patch blank values to your data sources like SharePoint, Dataverse and SQL. You can even patch date fields back to a null value. This is a feature we have all waited on for a long time. Watch the Formula-level error management video and you will learn to build better apps by dealing with your errors.

0:00 Power Apps formula-level error management
2:17 Turn on formula-lever error management
3:03 Invalid operartion division by zero error and IfError function
6:25 Office 365 Users connector error management UserProfileV2 User not found or Resource not found
10:04 Handling Patch errors with IfError function
15:03 Using FirstError function to provide error message and source
17:10 IsBlankOrError function
19:15 Patch a blank value or date to SharePoint

[oluwatobiyusuf]

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

[oembol]

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

[anantharamakrishnan]

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. :)

[dougydoe]

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

[saveeshmply]

Good One Shane - You are a real Guru :)

[powerhub]

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

[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

[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()?

[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

[minnies]

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. 🙂

[franknielsen]

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

[johanynavarro]

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???

[yehunlavolontededieu]

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?

[s]

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??

[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, ...)?