Answered

SubmitForm not updating multiline text field with selections from a Combobox, or creating value on new record

(0) Share

Report

Posted on by ScottRMeredith

141

I have an app that I have had live for a few months now and a portion of the SubmitForm() is not working. It no longer saves values into a multiline text field on a new record or updates the values on an edit form. I added a combo box to the data card for the multiline text field in the form. In the update property of the data card, I have:

Concat(cmbTriggers_1.SelectedItems,Title, "::")

When I preview the selection in the formula bar, it displays what I want saved.

I have tried other fields in the form, and it updates and creates those just fine.

I even reverted the update property of the data card back to the textinput control that was created when I added the form, and set the default property of the textinput to the concat function above with no luck. It displays the selections as desired in the textinput control, but does not update on save.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ScottRMeredith ,

This is a debugging exercise - if you put a Button in the Form somewhere with this, what happens ?

Patch( YourSPListName, { ID: ThisItem.ID, YourTextField: Concat( cmbTriggers_1.SelectedItems, Title, "::" ) } )

I also assume here that the Primary text displayed in the Combo Box is Title.
ScottRMeredith 141 on at

Like
a
(0)

Report
Copy link

Link copied!

I didn't think about trying Patch as a diagnosis step. Patching to the field worked fine.
WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ScottRMeredith ,

Sounds like a corrupt card to me. You might consider patching the whole thing anyway.
ScottRMeredith 141 on at

Like
a
(0)

Report
Copy link

Link copied!

I haven't removed and re-added it yet because I customized the data card so much already. I will try that, then if that doesn't work I can try to use the onsuccess event and variables to patch the field individually as a work around.
Verified answer

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ScottRMeredith ,

You would need to save the value as it would no longer be there after submitting the Form so you could remove the Update of the Card and

UpdateContext( { varWhatever: Concat( cmbTriggers_1.SelectedItems, Title, "::" ) } ); SubmitForm(YourFormName)

and do this OnSuccess

Patch( YourSPListName, { ID: Self.LastSubmit.ID, YourTextField: varWhatever } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
ScottRMeredith 141 on at

Like
a
(0)

Report
Copy link

Link copied!

That is what I was thinking. I am going to try it tomorrow....I will let you know how it goes.
ScottRMeredith 141 on at

Like
a
(0)

Report
Copy link

Link copied!

So, I tried to remove the data card from the form and re-add it. That didn't work. So, I did what @WarrenBelz recommended. I created a variable to store the data from my combo box, and in the OnSuccess property of the form I added a Patch to the same record to update just that field.