Unanswered

Edit Form error - submit form

(0) Share

Report

Posted on by Community Power Pla...

I use the same form to add new fields and edit in my data table in sql.

When I am editing a value, the error below is occurring and I am not editing the value in the data table (PS: when I add a new value, the error does not occur):

I deleted the form and repeated the calls, but still giving the same error, could someone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous

Please review your Update property on the datacard for the column that is causing the error. Make sure you are providing a numeric value for all the fields that require a numeric and that it is not being altered for when you edit a record. In other words, if you are doing some condition to check if the form is in edit or new mode and providing a value, make sure that you are providing the right type for each mode.

I hope this is helpful for you.

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

Like (0)

Report

@RandyHayes

Thank you for your attention.
I have already checked all the update properties of my form.

I have a condition in a datacard, the formula used in Default is:

but its update is with the formula below:

And the error is occurring in the entire form, not in a specific field.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous

Yes, it is complaining about the entire form, but the issue appears from the error to be coming from at least one column that is trying to be converted. To fully track it down, I would recommend using the Monitoring Tool in the designer and see what the request and responses are from the back end system.

Without further information about that particular datacard, I am assuming you have a Dropdown (not a combobox) in the datacard and that you have provided the Default property of that Dropdown and not the Default property of the Datacard. The Datacard should be ThisItem.someColumnName where some column name is the name of the column in your datasource.

IF this is indeed the offending column (again, try to verify with the Monitor Tool) then please supply the Items property of the DropDown and any relevant information about that datasource.

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

Like (0)

Report

@RandyHayes

the dropdown values are the ones informed in the previous post, sorry for not making it clear. But, send again (in this dropdown I have a view that has the name and id and saved in the main table):

Dropdown:

Default activity:

Itens:

Card´s Update:

I checked with that monitoring tool and it resulted in the point where the error happens:

Request:
and the response:

if you can help me with this information. Thanks !

Was this reply helpful? Yes No