Powerapps connected with SQL - How i can react on Error/Error messages

[Dominicopitz]

Hello together,

i hope you can help me. I connected powerapps directly with MySQL and I want to react on different Errors. Now I is IfError( to take whatever Error appears to send me to the "Error-page" and to interact.

The problem is to make it 100% right I would like to react to the different Errors which could appear.

For example I have a fiel and my SQL check if it have 17 letter. If not I want to navigate us specifically to this Error. Other Error is that the number (if it have 17 letter) will be checked by my SQL with my back lists, if it appears fine, if not I get a other Error. Here I want to navigate different as on the first Error but I tried yet so many combinations and not get any solution.

I attached a foto (its in german) what the SQL send me back as a mistake message.

Maybe someone could support.

Thank you very much!

Dominic

[ANB]

Hi @Dominicopitz , I didnt get the complete requirement, however based on my understanding it seems you want to navigate to some screen based on different error, if this is what you want then you can update the App.Error property to give more details about that error, something like the expression below: 

If(
  FirstError.Message = "Your Error Message",
  Notify($"Error details: {FirstError.Kind} - {FirstError.Source} - {FirstError.Observed} - {FirstError.Message}");
  Navigate(Screen),
  Error(FirstError) // if not that error, let it bubble up
)

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

[Dominicopitz]

Good morning and thank you very much for your reply. My problem goes in that way. The main problem that i have (like you see on the foto) that i idetify the Error by MySQL as "VIN ist nicht 17 stellig" but it seems like Powerapps receive the mistake message but not recognise it like that.

My plan is that depending on several actions screen that i have per screen 2-3 possible error that could appear. Just to understand it can be that the scanned barcode not is equal with announced and known numbers or that the number isnt 17 letter long.

Depending on the both error and the different "error message" i would like to send my colleagues to the right page to tell them which error appeared and whats the mistake.

I hope it helps more to understand it.

Thank you!

[Dominicopitz]

Hello together, there is a option to show the Errors which appears because of the SQL?

If i go on "App" and then on "OnError" i can do whatever but it not wanna show me the Errors by the SQL.

Thank you!