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),""))
Solved! Go to Solution.
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."
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."
User | Count |
---|---|
239 | |
116 | |
94 | |
58 | |
32 |
User | Count |
---|---|
287 | |
132 | |
106 | |
63 | |
57 |