Power Platform Community Forum Thread Details

Trying to update datatable value when checkbox is checked on Gallery.

Patch(Table7_1,Search(Table7_1,ThisItem.Branch,Branch),{Column9:"1"})

I need to match the id of the datatable and the gallery checkbox to update datatable's column9 from 0 to 1.

I am getting an error:

The function search has invalid arguments

I also tried this function but still getting error when trying to update the datatable.

If(!IsBlank(LookUp(Table7_1,Branch = ThisItem.Branch)),Patch(Table7_1,LookUp(Table7_1,Branch = ThisItem.Branch,Column9),{Column9:1}),"")

and this

ForAll(CheckedItems,Patch(ChecklistItemsSource,LookUp(ChecklistItemsSource, Id = CheckedItems[@Id]),{Status:"Done"}))

Categories:

Error received when trying to patch datatable from checkbox