cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KHenderson
Frequent Visitor

Filter Gallery from SharePoint list (choice field) with buttons

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),""))

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@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."

 

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@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."

 

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,287)