Date is already in DatePicker10 but clears it out on Save
Patch(
SPList,
LookUp(
SPList,
ID = SharePointIntegration.Selected.'ID'
),
{
Date10: DatePicker10.SelectedDate
}
)
);
Solved! Go to Solution.
Okay...let's see if you run into it again!
Is DateofConcurrence10 the column?? You indicated it was Date10 in your original posted formula!
Also, the thing here is your history shows that NO date was submitted. Which is why it would then show empty in your datepicker.
But, I believe your problem stems from the Gallery! You are referencing DatePicker10 out of context. DatePicker10 is in your gallery. If your button to submit is outside of the gallery, then you will only be referencing the DatePicker10 of the row that is currently selected.
You indicated that your Gallery has 10 items/records. But your Items formula will only ever produce one record!
So, there is some confusion as to what you are doing with the gallery still.
What is the DefaultDate property of the datepicker?
ThisItem.Date10
Okay...working backward - What is ThisItem? Is your datepicker in a form or a gallery?
gallery
Okay...next, what is the Items property of your Gallery?
Filter(SPList, ID=SharePointIntegration.Selected.'ID')
So you have a gallery table that will only have ONE record? What does purpose does a gallery serve in this case?
Back to your original statement though - "Date is already in DatePicker10 but clears it out on Save"
When you refer to Save - are you referring to the Save button in the SharePoint interface?
When you say it clears, are you stating that all the rest of the information is there but the DatePicker date disappears?
my gallery is for 10 items. But the Save Icon (not interface save) I am using to patch updated records would clear out the date already in place. I just republished the form and did a test on date10. It did not clear out the date this time. Strange. I will monitor this and reach out if it happens again.
Okay...let's see if you run into it again!
User | Count |
---|---|
256 | |
103 | |
92 | |
47 | |
37 |