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 |
---|---|
139 | |
129 | |
75 | |
74 | |
69 |
User | Count |
---|---|
221 | |
135 | |
78 | |
58 | |
56 |