Answered

IfError Exception handling

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey guys,

Running into a new problem and I'm not able to fix it.

IfError(Set(
 setVar;
 Patch(
 CDS_1;
 gallery.Selected;
 {
 Amount: Value(textfield.Text);
 Mail: combobox.Selected.UserPrincipalName; 
 }
 )
 ); Notify("Not a valid value. Please enter a valid value."; NotificationType.Error));

Following error occurs if I type a comma into the textinput field:

An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '777.677' to the expected type 'Edm.Int32'.---> ...

Yes, I know this value with comma isn't valid and can't be converted into an integer value. But how to perform a try and catch in powerapps?

As you can see above what I did in the code but it's not working. There's no way to catch the exception and throw the error message.

How to achieve it?

Thanks so much for helping!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you explain further what you are trying to achieve. Do you want to validate if the Textbox contains number?

Also is your Patch working without the Error code?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @eka24,

@eka24 wrote:
Can you explain further what you are trying to achieve. Do you want to validate if the Textbox contains number?
I only want that the textfield accepts numbers. No commas, no characters nothing. Only integers.
But if I type a comma, it's being accepted by the textfield. I don't like it.

@eka24 wrote:
Also is your Patch working without the Error code?
Absolutely. Working perfectly without error code.

Thanks so much for your reply.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

The simplest way is to change the format of the Textbox to number. Tha way, anything that is not a number would be rejected.

If you want a notification rather, try;

If(
!IsMatch(textfield.Text,"[0-9]"), Notify ("Your Text here"), Patch(...........)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @eka24,

Thanks so much for your reply.

This is working for me:

If( !IsMatch(textfield.Text,"\d+"), Notify ("Your Text here"), Patch(...........)

"\d+" -> If you type this, it's working the way it should.

Was this reply helpful? Yes No