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 ...
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.
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
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)- Still 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.- Oh now that you say that I see the issue, I should have caught on with the original post. You can't use filter onselect, you basically have to take your gallery items property is where you set your filter and you need to set it there.
Basically you need to have a filter value either via Textbox, or from another gallery and set the filter value to that. So if you create a textbox to put your filter in then this.
Filter(
Inventory,
Columnname,
textbox.text
)
So when you input that value into the Textbox you get the filter. You can create a manual drop down box as well, but if you need all values, then you have to use an IF statement in the items field saying IF it's blank then this, else use the filter so
If(textbox.text = "", 'datasource', Filter('datasource',columntofilter = textbox.text)
- I 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?