Help with filter on Gallery

[UserInterface7]

Hi, I am trying to build a little storefront but I am still having trouble with filtering.

I have a List called, 'Store Data - Categories' with the Title field renamed to 'CategoryName' and another list called 'Store' also with a filed called 'CategoryName'

In my app, I have two galleries 'Options' (which is the 'Store' List in SP) and 'Categories' (which is 'Store Data - Categories' in SP)

I am trying to only show the items (from 'Options') that match the selected category, I tried this but it doesn't work.

SortByColumns(Filter('Store Data - Categories', And(Title = Categories.Selected)))

Can anyone help? Think I might just be confused because I named my Galleries differently to the SP List and I'm not sure what the filter is requiring, but I have tried different combos and they didn't work.

[Jeff_Thorpe]

FYI: when using SortByColumns the second parameter (in this case Group) needs to be in double quotes ("Group"). Also PowerApps uses the internal SharePoint field name which is the name it was given when it was created. Anytime you change a field name in SharePoint you are just changing the display name.

Why do you have "Category.Selected.CategoryName"? I thought CategoryName was a rename of the Title field in "Store Data - Categories", so it should be called "Category.Selected.Title".

I don't understand how you are changing the field "Group" to "GroupLabel" in the Gallery.

Lets try and simplify it to see if we can get it working.

Filter('XXXXX Store', Group = Category.Selected.Title)

'XXXXX Store' needs to be changed to the actual name of the list but don't change anything else. After the code is in and if there are no errors then click on category and see if it filters.

[UserInterface7]

"Category.Selected.CategoryName" Um. I was just trying different combos, but that made the field highlight as below. But your right it should be title. Think I went down the rabbit hole with that one when I tried too many things this morning

I don't understand how you are changing the field "Group" to "GroupLabel" in the Gallery.

When I create the gallery, it gives the field some generic name like Label4 etc, I am just right clicking and selecting rename to give it a name I recognise.

Trying the below works as expected.

Filter('XXXXX Store', Group = Category.Selected.Title)

[UserInterface7]

When i try this, it works. 

SortByColumns(
Filter(
'XXXXX Store',
Group = Category.Selected.Title
),
"Group"
)

Seems to be just an issue with the sort.

If(SortDescending1, Descending, Ascending)

[Jeff_Thorpe · Accepted solution]

Changing the control name to GroupLabel doesn't impact the how we are trying to use Group which is actual field name.

If you haven't a variable called SortDescending1 that explains why it said the if statement was invalid.

You can still sort by doing this:

SortByColumns(
Filter(
'XXXXX Store',
Group = Category.Selected.Title
),
"Group",
Ascending
)

[UserInterface7]

Thank you! 

That works, I think I was getting confused with using the label name vs the actual SP list column name. Also, changing the sort as you suggested works.

Thanks for your time, I just couldn't get my head around it. The other mistake I made was that renaming the column in SP wasn't changing the name. That was my biggest mistake I think. 

I'll just have to work out how to clear the filter again to show all options again if they want but that can wait for now.