Forum Discussion
Oskar Kuus
Mar 18, 2019Iron Contributor
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 ...
Mar 18, 2019
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.
Give that a whirl.
- Oskar KuusMar 18, 2019Iron ContributorThat 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- Mar 18, 2019Possible that it's multi choice value?
Filter(SharePointListName,"SearchValue" in Choice.Value)- Oskar KuusMar 18, 2019Iron ContributorStill nothing.
Tried your last code aswell.
Tho im not sure what you mean by drop downs in powerapps?
This is my first app.. my idea is to use a button to activate a filter, but if there is a better way im open for it.
- Mar 18, 2019I was thinking in terms of drop downs in powerapps. It should just let you filter on that the way you did it, did it give an error that way or it just doesn't return anything?