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"}))
Solved! Go to Solution.
Sorry for the posting i think i resolved it by doing the below:
Patch(Table7_1,First(Search(Table7_1,Text(ThisItem.Branch),"Branch")),{Column9: 1})
If anyone is interested.
Sorry for the posting i think i resolved it by doing the below:
Patch(Table7_1,First(Search(Table7_1,Text(ThisItem.Branch),"Branch")),{Column9: 1})
If anyone is interested.
User | Count |
---|---|
253 | |
112 | |
92 | |
48 | |
38 |