Hello,
I'm going to try set the stage, since I'm new here.
I have a Microsoft List with less than 100 records.
Screen1
I filter this list through a Text input box
Default = ""
I then use a button to initiate the search / filter
OnSelect = UpdateContext({varSearch:'sbox - ID'.Text})
This will filter a gallery
Items = LookUp('ThankYouCardList',IsBlank(varSearch) || false || ID = varSearch)
I chose LookUp because there maybe multiple ID's that are the same and I only need the first one to confirm the ID.
Screen2
On this screen it captures the ID from sbox - ID in a Text Label
This also is the criteria for filter another gallery that only displays the items with the particular ID.
There can be 1 to 5 items listed in this gallery.
In this gallery I have inserted a Checkbox to indicate if this task is complete.
Remember there can be multiple tasks and each item in the gallery has it's own Checkbox.
I am using Patch to try update the specific record in the Microsoft List
OnCheck = Patch('ThankYouCardList', ThisItem, {Completed:If(Self.Value,"Yes","No")})
OnUncheck = false
OnSelect = Select(Parent)
Text = If(Self.Value,"Card Completed","Check box when Card is completed")
I tried this originally with Excel as the data source and it seemed to work fine, but when I chose a Microsoft list this will not update the record.
So with the information above, I'm reaching out for assistance on why this is not updating the record?
Here's a screenshot of that last screen. I cleared out some content but left all structure in place.
If one check box is marked this is what it should look like
With the Submit button I would like to update the record in the Microsoft List and then reset the first screen.
Clearing out the input text box and the first gallery.
Also navigating to the next screen that is a Label screen saying thank you
Screen 3
This is for the user to confirm completion and exit the program
Hopefully this may help someone get me on the right track.
