I'm building a checklist app for a team that after they submit their answers to the checklist that they want to be able to go back and edit/update the same list. I've set this up within 2 screens, one is a "list view" that shows the SP List line items, and the actual checklist screen which is a form with embedded galleries for the checkboxes. (Each datacard has a nested gallery for the checkboxes).
The checklist screen is currently being used as a view/edit/new form.
The initial save (submit form) works great, and all the data is saved to the SPList. However, when I go back to the Browse Screen, select the record I want to pull up (all one sharepoint line item) it doesn't display the data from the checkbox columns. All other datacards are pulling the data properly.
The Browse list is a gallery with the:
OnSelect EditForm(ChecklistForm);Navigate('Checklist Screen')
Items is a search in the MRN field : Search(colRecords,txtSearch_1.Text,"MRN")
When I click the entry, it *does* pull up the record (colRecords is collecting MRN, Patient Name, Last Updated, Author, Editor, and ID)
The data from MRN, Patient Name, Created, etc, are pulling the data into the form from the SPList. The individual checkboxes (each color is its own gallery nested in a datacard) are not. I'm pretty sure that's why--but I don't know how to fix it so that the ViewForm or EditForm populates the data from the SPList.
What is the Default property of the Checkbox in the Gallery? It needs to work off of the record data that is stored.
So that was the first thing I started tinkering with based on your suggestion on this post:
Currently there's nothing in the default property. Since it's a checkbox in a gallery that's in a datacard that's in a form--I don't even know WHAT to put for the default property since the parent of the checkbox is the gallery, which isn't going to pull anything, and I tried and ThisItem.Value gives me a delegation warning that the value is looking for a true/false statement.
Well, then the real question would be this - What kind of column is the underlying column in the record?
What also is the Update property of your datacard?
Column is a choice column. The nested gallery Items property is Choices(SPList.Column), and OnSelect is Collect(colSepsis, ThisItem.Value)
Update for the Datacard is colSepsis.
Change your Default property in the Gallery to:
Self.Value in ThisItem.yourChoiceColumnName.Value
Normally you would reference the Parent.Default of the datacard, but since this is in the Gallery, the Parent will be different. So, just specify the ThisItem.yourChoiceColumnName (replace as needed).
HOWEVER...you will Also need to deal with your collections again when you edit. The reason is, if you don't repopulate the collection, then when you submit that form again, it is going to update the column with the contents of the collection...and if you don't recollect it, it will be empty and your record will be blank for that column.
Thanks, I'm going to try this shortly! I have a Clear(colSepis) set on the submit button, but after the SubmitForm, so I should be good, right? I'll report back on the default property.
Thank you for your help so far!
I tried your suggestion, and keep getting this error. When I put Self.Value in ThisItem.SEPSIS.Value in the Default property, it throws an error saying that this functionality is only available in the Items property. I then tried that, and got an error that.
SO, I tried putting ThisItem.SEPSIS.Value in the Default property of the Gallery, and got the below error:
Which control Default property are you putting my formula suggestion in?? It should be in the Default property of the Checkbox control in your Gallery.
I initially put it as the default value to the Gallery since that's what you said in the post.
SO, in putting ThisItem.Value (my only option other than ThisItem.IsSelected) for the default property of the checkbox, and I get a delegation warning:
I tried the Self.Value in ThisItem.Value (ThisItem.SEPSIS.Value is not an option), and got a circular warning:
To be clear--this is in the default property of the checkbox.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.