I am building a PowerApp that is connected to a SharePoint List. I created a Home Screen that contains three (3) buttons.
- Buttons:
- Pending Requests:
- OnSelect = Set(var,"In progress"); Navigate(BrowseScreen1, Transition.None)
- Needs Quality Check
- OnSelect = Set(var,"Needs Quality Check"); Navigate(BrowseScreen1, Transition.None)
- Completed
- OnSelect = Set(var,"Done"); Navigate(BrowseScreen1,Transition.None)
I put the OnSelect formula in parenthesis above. The word in "" is what the SharePoint choice is in the list.
On the BrowseScreen1, I have the gallery that is connected to SharePoint and that I am trying to filter using the buttons. Below is the formula I have but it is not working. No matter what button I push, all records show no matter what the progress selection is.
- Formula on Gallery
- SortByColumns(
Filter(
[@'Print Request Tracker'],
StartsWith(
Title,
TextSearchBox1.Text
),
If(
var = true,
Progress.Value = "In progress",
Progress.Value <> ""
)
),
"Title",
If(
SortDescending1,
Descending,
Ascending
)
)
NOTE: the enter new request button take user to edit screens so it does not need to be in the formula
Can someone help me and tell me what I am doing wrong???
