How to filter a datatable

Oskar Kuus
Iron Contributor
Mar 18, 2019
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.
- ChrisWebbTech
  MVP
  Mar 18, 2019
  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)
  - Oskar Kuus
    Iron Contributor
    Mar 20, 2019
    ChrisWebbTechI dont get it... where do i put what code?
    
    i created a textbox and typed in this
    Filter('Underlag Kostnader';Status;TextInput1.Text)
    
    put on the textbox onchange and tried the onselect
    textbox dont have a Item to put anything on so i dont know where to put the code
    
    "underlag kostnader" = sharepoint list and datasource
    status = column
    textinput1 = textbox

Forum Discussion

Resources