Filter Gallery from SharePoint list (choice field) with buttons

[KHenderson]

I am trying to filter my galley to only show expense reports by status. Open,Approved and Rejected are the choice fields that I am attempting to use from my SP list and link to a button to sort. I am trying to do something similar to the template expense report app. Something is not wired correctly and I could use some help. 

Variable: Need help

Set(varStatus, "Open")



Galley Items:

SortByColumns(Filter([@EXPR],CreatorEmail=varUser.Email,StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))


Status(choice field):Approved,Open, Rejected
Concat(ThisItem.'status expense '.Value, Concatenate(Text(Value),""))

[mdevaney · Accepted solution]

@KHenderson 

Begin my making a Choices field in your SharePoint list called 'Status' having the following options:

Open, Approved, Rejected

Then place a new ComboBox in the canvas app with this Items property

Choices(your_sharepoint_list.your_column)

Finally create a gallery and use this code in the Items property

Filter(
    your_sharepoint_list,
    CreatorEmail=varUser.Email,
    Status = ComboBox_Status.Selected
)

Assuming the rest of your function works you can place it like this.

ShowColumns(
    Filter(
        your_sharepoint_list,
        CreatorEmail=varUser.Email,
        Status = ComboBox_Status.Selected
    ),
    "Title",
    If(SortDescending1, Descending, Ascending)
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."