Update date column every time a gallery item is patched into another datasource

[jbend088]

Hello Power Platform Community,

I have a gallery that uses SharePoint as a data source and its columns include several text input fields, a date field and a checkbox field. I also have a button to patch over the records that are selected by the checkbox column  in the gallery (using a collection 'colGrid'). I am trying to configure the date column so that if a selected record is patched, the date field will update to today's date for the selected records only (unselected records are not patched and hence I do not want the date for these items updated). 

Please let me know if this process is achievable; your response is greatly appreciated. 

Thanks,

Jackson

[RandyHayes · Accepted solution]

@jbend088 

Ditch the collection and this will all be automatic!

Your OnSubmit formula on the button outside of your Gallery should be:

Patch(yourDataSource, 
    ForAll(Filter(yourGallery.AllItems, yourCheckbox.Value),
        {ID: ID,
         yourDateColumn: Now(),
         otherColumn: yourTextInput.Text
        }
    )
)

This will patch all selected records to your datasource and update the Date column to Now and any other column to any other value from the gallery or elsewhere.

As long as the gallery is based on the datasource and not some static collection, then the Gallery will reflect the changes immediately.

I hope this is helpful for you.