Answered

Creating an unsaved changes warning on edit form - Combo Box firing in error

(0) Share

Report

Posted on by LulaLong

I have an App with a SharePoint List Data Source. There are various multi-select combo boxes on Forms with default mode Edit. Making changes to the SelectedItems and SubmitForm is working fine.

I want a warning whereby if someone makes a change to any fields on the form but hasn't yet submitted it, a text box becomes visible which says "Warning - you have unsaved changes". Putting a collection in the OnChange of each field, then passing that to the visibility of the warning textbox is working fine for all control types apart from the ComboBoxes. These keep firing when the app is opened, even when there have been no changes to the SelectedItems.

I have seen others encountering the same problem in various threads, but can't find a workaround that actually works. Best solution I found was to check the ComboBox SelectedItems against the data source, and fire the OnChange collection only if they don't match. But I can't get the syntax correct and keep getting errors saying this formula uses scope.

I'm sure it's something simple but I've spent hours and can't get it.

The Concat(ComboContributor.SelectedItems.DisplayName, ",") on the right of the OnChange is working as expected. But trying to get a match from the data source on the left that isn't working.

Help most welcome! Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

SolTeferi on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LulaLong ,
If I understood you correct, I think it is easier to put the check on the submit button. When the submit button is clicked, create a variable for the combobox selected item like the one below:

Set(varComboBoxItems,ComboContributor.SelectedItems)

and then if any change is made after that on the combobox, put something on the visibility of the Unsaved Changes text label as shown below:

Concat( ComboContributor.SelectedItems,",")<>Concat(varComboBoxItems,",")

With that being said, I recommend to simply change the edit mode of the form to view mode on click of the submit button and show the item just submitted unless you have a reason to keep it in edit mode after it is submitted.

Was this reply helpful? Yes No
lyndseylula 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Discard comment, wrong account used

Was this reply helpful? Yes No
LulaLong 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Yes, it needs to be edit mode as the users will be updating the data with the app.

The problem is that when you first open the app, it says “you have unsaved changes” even though you’ve not done anything yet. I believe it is to do with the way the app gets the data for combo boxes.

The warning needs to come before submit.
For other fields using OnChange as a trigger to add to a collection which makes the warning appear works fine. Just not for Combos.

Was this reply helpful? Yes No
Verified answer

SolTeferi on at

Like
a
(1)

Report
Copy link

Link copied!
Got it! Can you try this. On the Onvisible property of the screen, define a variable like the one below:
Set(varStart,False)
Then on the Visible property of the "Unsaved Changes" label, put the following:
If(varStart, Concat( ComboContributor.SelectedItems,",")<>Concat(varComboBoxItems,","))
Then, on the click of the submit button, put the following:
Set(varComboBoxItems,ComboContributor.SelectedItems); Set(varStart,True)

Was this reply helpful? Yes No
lyndseylula 48 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
lyndseylula 48 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
LulaLong 9 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked, thank you!!

Was this reply helpful? Yes No