If user submits newform it deletes combobox values then fails required field

(0) Share

Report

Posted on by TrevorMorrice

There are no default values or anything its super confusing it seems to happen to only the boxes that are lookup fields the choice boxes don't seem to have an issue.

The save button is just submitform(formname) and then shows the please wait with a context variable.

I have 4 other forms in my app and none of them seem to have this issue.

Also the form works normally in edit mode, but i do see it glitch out for a seconds and remove the selected items for a split second before saving.

Edit: There seems to be an issue with the Field disambiguation it isnt loading properly.

I attempted to recreate the form with a container and it will not grab any of the lookup fields with the tablename[@fieldname] format.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TrevorMorrice

Some information required here

The Item of the Form

The code OnSelect of the Save button

The Items, DefaultSelectedItems and DisplayFields of the Combo Boxes and whether they are Modern or Classic controls
The names and types of fields you are writing back to

Was this reply helpful? Yes No
TrevorMorrice 77 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz the item is a context variable selected from a gallery that is linked to dataverse.

It works perfectly on EditForm()

The save button is simply SubmitForm(formname)

There is something wrong with my data source connection it is failing with forms

Not sure what you mean with the other requests...its a form it supposed to just do the work for you but it rarely does.

I tried to use both modern and classic.

I ditched the form and went with just manual container and fields with a patch.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TrevorMorrice

Your issue is probably that you are not updating the Context Variable, so if you did this OnSuccess of the Form
UpdateContext({YourVariableName: Self.LastSubmit})

it should show the updated values.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
TrevorMorrice 77 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Its not getting to the onsuccess its failing.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What error message are you getting ? Did you try a monitor session to see what is happening ?

Was this reply helpful? Yes No
Suggested answer

TrevorMorrice 77 on at

Like (0)

Report
Copy link

Link copied!

Its the same error message id get if had just submitted it without making a selection.

Just missing required field.

For some reason when i hit submitform on formode new it clears all comboboxes.

For some reason when i hit submitform on formode edit it works.

We can stop this madness I quit using forms now for good, the modern form with the AI guessing fields added 200 controls to my screen alone :(

Was this reply helpful? Yes No