Skip to main content

Formula level- Error Management

Today we start looking at another feature from the feature list called ParseJSON. We have already seen Named Formulas, Find and Replace, and ParseJSON function in our previous blog(s).

What is Formula level-Error Management?

Allows us to create custom errors to improve app usability and gather valuable error information.

How to enable Formula level-Error Management feature?

Assuming you have already created an app and you are using the latest version of PowerApps studio. Click on settings on the top bar of the screen. 

image

You need to select Upcoming Features and select the Preview Features option and search with “Formula” in top search bar. 

You should now see the “Formula level- Error Management” feature, just enable it.

Graphical user interface, text, application, email Description automatically generated

 

How to use Formula level- Error Management?

We already had IFERROR wherein we could put the error prone code as first parameter and error message in 2nd parameter.

Now you have an additional facility to handle types of Errors using the Error function.

Earlier we were using IfError(Text(1/0),"Divide by zero") to handle errors this was generic but now we can do as below.

IfError(Text(100/Value(TextInput1.Text)),Error({Kind:ErrorKind.Div0,Message:"Divide by 0 error"}))

You do have multiple options for Error Kind and you can also access FirstError and AllErrors to handle.

image

FirstError gives you the error stack for first error found. It can be used as below.

IfError(Text(100/Value(TextInput1.Text)),Error({Kind:ErrorKind.Div0,Message:FirstError.Message & "Divide by 0 error"}))

Hope this helps!

Thanks,
 Keyur Pandya

Labels:

Comments

Post a Comment

Popular posts from this blog

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...
2 comments
Read more

SharePoint Server continuously prompting for Credentials

Sometimes it is the case when your SharePoint server keeps on prompting for credentials. After some amount of googling and going through some reliable blogs I found following solution. Open Run Type “regedit”.                                                                  In the registry window left panel find HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > LSA                                                                                                                      Now right clic...
3 comments
Read more

Identity client runtime library (IDCRL) did not get a response from the login server.

Recently I was doing some testing with a background PowerShell and encountered a weird error. “Identity client runtime library (IDCRL) did not get a response from the login server”. The error that you might encounter while working with PowerShell. This error is very misleading when it comes to identifying what could go wrong. After doing quite a good amount of research below are the probable causes for the error. Invalid Credentials MFA (Multi-Factor Authentication) Manage security defaults. Solutions Invalid Credentials Check if your credentials are wrong. Especially if you are using variables. MFA (Multi-Factor Authentication) Check if MFA is enabled on the account which you are using. These only affect you badly if you are developing PowerShell for a background Job. Go to Microsoft 365 admin center Users -> Active users -> Select the user -> Manage multifactor authentication -> Select the user -> Disable multi-factor authentication. M...
2 comments
Read more