Forum Discussion
How to filter a datatable
How can i Filter a datatable in Powerapp?
I have a screen with a datatable with 3 columns. Datatable is based on a sharepoint list that is connected to my powerapp.
Title | Description | Status
I want to filter on status
Status contain text and i want to filter on things that contain "Ye"
I have looked everywhere, it seems like ppl are able to filter a datatable. but i can not get it to work.
Filter('Underlag Kostnader';Status= "Ye")
Underlag Kostnader = my sharepoint list
Status = status column in the datatable.
Datatable is caled "Datatable1_1"
Above code is placed in a "onselect" button. So idea is the when i press the button, the list is filtered.
Is this possible and if so how?
9 Replies
- Depends on if you're passing in any values from other controls, but If mind serves right you need to use .value after Status, so Filter('datasource';Status.Value = "Ye")
Give that a whirl.- That did not work either.
Filter('Underlag Kostnader';Type.value="Ye")
I get the error telling me that i cant use the "." (dot).
Tried ; and : aswell... no luck- Possible that it's multi choice value?
Filter(SharePointListName,"SearchValue" in Choice.Value)
