Mar 18 2019 09:18 AM
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?
Mar 18 2019 01:40 PM
Mar 18 2019 01:47 PM
Mar 18 2019 01:55 PM
Mar 18 2019 01:57 PM
Mar 18 2019 02:20 PM
Mar 18 2019 02:33 PM
Mar 20 2019 01:59 PM
@Chris WebbI 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
Mar 20 2019 02:01 PM
Mar 20 2019 03:04 PM
That worked really good. I changed tactic after watching a few videos. I got a first filter working now.
Now i need a bit of more help tho :)
This line works
Filter('Underlag Kostnader';TextInput1.Text in Beskrivning)
The code is put on GALLERY´s Items
Screenshot: http://prntscr.com/n0polx
So typing in TextInput1 i filter the column called Beskrivning.
But how can i now filter by searching in column Rubrik with TextInput1_1?
I tried just double the code like this:
Filter('Underlag Kostnader';TextInput1.Text in Beskrivning)&Filter('Underlag Kostnader';TextInput1_1.Text in Rubrik)
But it did not work.