I am currently having issues trying to connect the gallery with the data dource, this is the current value for the excel file:
If(category = "Most checked out", Sort(Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName),CountValue,Descending), category = "Reviews", Sort(Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName),Comments,Descending),Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName))
I really don't know how to change this to get the values form the SPL