Dear all, first... a big hello to all of you.
I'm really new in power app and I've created a new app with a gallery. My problem is that I would like to add a filter to the gallery to select the records with a specific owner, plus remove from the list the "completed" actions
The data source is a sharepoint table with:
Owner = text field
Status = dropdown with unic value choise
name of gallery = 'PR&C Accountability Board'
Can you help me with a step by step process considering that I'm really new?
Thanks a lot for helping
Solved! Go to Solution.
Hi @AlexTB ,
If you have set the OnSelect property of the control or set its TabIndex property to 0 or higher, you need to edit the accessible-label property to describe it. Otherwise, try to delete the control and recreate it.
If Not funciton isn't supported, change the filter condition to Status.Value= "Other Choices 1" && Status.Value= "Other Choices 2" && Status.Value= "Other Choices 3"
To make the gallery show all records if nothing input, add if function to check the text box is empty.
Filter('PR&C Accountability Board';If(IsBlank(TextInput1.Text),true,Owner=TextInput1.Text && Status.Value= "Other Choices 1" && Status.Value= "Other Choices 2" && Status.Value= "Other Choices 3" ))
Hope this helps
Thank you all... however... filter does not works.
I have rebuild all pages. The Gallery is working, selecting the line it goes in the new page to modify the records. Adding button regularly works going in the new record page and save button works. All is good but the filter does not work.
So, I inserted a textinput box, I tried with
1 - Filter('PR&C Accountability Board',Owner=TextInput1.Text &&Not(Status.Value="Completed"))
1 - Filter('PR&C Accountability Board';Owner=TextInput1.Text &&Not(Status.Value="Completed"))
2 - Filter('PR&C Accountability Board',Owner=TextInput1.Text)
3 - Filter('PR&C Accountability Board';Owner=TextInput1.Text)
There is no formula on textbox... do I have to put something there?
I should be an easy command in my mind:
a) no text into the box --> results all records excluding the completed ones
b) any digit into the box--> results all records selected with the same digit into the Owner colomn
What I can do? Please tell me which information you need or I have to check and I will provide
Thanks a lot
OK guys.... navigating into the web I found this very good video (youtube video) and following the suggestions step by step at the end my filter works!!!! Hurrà!!!
Ok guys, navigating I found this very good video and I follow ut step by spep.
Finally... IT WORKS!!! Hurrà!!!!
Thanks to all have dedicated time to me!
Final formula is
Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata"))
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights