You’re offline. This is a read only version of the page.
9
Hi all,
I am really struggling with an issue within my editable gallery.
By way of background, I have created a blank vertical gallery and added a number of text input fields to it as I want my users to be able to update data within the gallery. My data source is a SharePoint List.
So now I want to only use the Patch function to update records that have been changed, rather than writing all records back to my list. And to do this, I am trying to use a hidden Toggle switch to identify which records have changed.
I have 8 x Text Input fields within the gallery and 7 of them are single line fields and 1 is a multiline field.
I am using the following formula:
ThisItem.Software <> txtSoftware.Text ||
ThisItem.Vendor <> txtVendor.Text ||
ThisItem.Approved <> txtApproved.Text ||
ThisItem.Licenced <> txtLicenced.Text ||
ThisItem.CostType <> txtCostType.Text ||
ThisItem.Expires <> txtExpiryPeriod.Text ||
ThisItem.PurchaseMethod <> txtPurchaseMethod.Text
This all works beautifully on all the single line text input fields but when I add the multiline field into the formula (i.e. ||
ThisItem.Comments <> Comments.Text), the toggle switch will turn 'ON' for all records where there is no data in the Comments field and 'OFF' for all records where there is data in the Comments field.
I must be missing something really simple here but I cannot for the life of me figure it out!
Any help or suggestions would be much appreciated
I managed to fix this by simply adding text to the Notes field of the first record in my SharePoint list. The toggle switch then behaved as expected.
Share
Report
All responses (
Answers (
