@Anonymous You can set this in the OnChange property of the search TextInput,
With({_codes:ShowColumns(Filter(SPItemsList,Item1=Value(TextInput.Text) || Item2=Value(TextInput8.Text)),"Code1","Code2")},
With({
_code1:RenameColumns(ShowColumns(_codes, "Code1"), "Code1", "Code"),
_code2:RenameColumns(ShowColumns(_codes, "Code2"), "Code2", "Code")
},
ClearCollect(colCodeCount,GroupBy(ClearCollect(colCodes, _code1, _code2), "Code", "Count"))
)
)
Set the Items property of the DataTable to colCodeCount and 2 Fields to the DataTable, the First will be "Code" and the second will be "CountRows(ThisItem.Count)"
Please remember to give a 👍 and accept my solution as it will help others in the future.
