You’re offline. This is a read only version of the page.
Hi all,
I'm working on a canvas app attached to a SharePoint list as the data source. I have a gallery on the 1st screen to select an existing client or create a new client form. The form has quite a few columns and most are working as I'd like, but there's one group that I am having issues with and hope someone here has an idea to help because this is a big roadblock right now.
For these forms, there are a number of columns/fields where we have a "Standard" for how the client's cases are handled by our team and we really want to be the default. So I added a checkbox to those fields - it does not send information back to SPO, it just controls the visibility of the text input. And that works great in creating a new form. However, if we go to edit it and (for example) recheck the "Standard" box and delete the text, the text remains and the checkbox does not stay checked. Every other field seems to work fine on editing, except these ones. I have searched for answers for awhile and not finding anything that solves the issue.
On the Default for the Checkbox, I have If(Parent.Default="Standard", true, false)
Update property for the datacard is txtSummaryofServicesFreeform.Text
I see. The SharePoint column is "Standard" by default. But when you uncheck the box, nothing is updating SharePoint with the new value. I made the following example:
Hopefully this sort of captures your data source, seen in the table. As the "Masking" column values are ALREADY set to "Standard" by default, we need to change that value when a change is made.
A few options would be the OnUnCheck property of the checkbox, or the OnChange property of your text input:
As seen above, when I uncheck the box, the value is cleared out. I don't know if you want to clear it out, this is just an example 😛
Share
Report
All responses (
Answers (
Patch(colTest,DataTable1.Selected,{Masking:""})
Or, I can instead use my OnChange to save the new value:
Patch(colTest,DataTable1.Selected,{Masking:TextInput1.Text})
Let me know if this wasn't what you're looking for
I will try my best.
For example we have a field for how much of an account number will be masked in communications. We want the default to be that it's all but the last 4 digits. So the Standard box is checked and the text input is not visible. The default for the column in SharePoint is "Standard". If the client wanted a different way of masking the account number we would unselect the checkbox and add the new instructions.
If I create a new client form, the data I save from this field works in both the ViewMode and in SPO. However, if I go to edit the form and change one of those fields - either way to uncheck or to recheck - the form retains the original information. It only affects these columns as far as I can tell, every other field (multi choice columns, single choice, text) all work fine.
Happy to provide any more information if it gets me to where I need to be. This is all still pretty new to me and sometimes I'm not sure I'm communicating in the right language when looking for help.
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
