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.
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"))
it is a Text Column. I tryied to use a combobox but I read from the post that this is not easy to manage when filtering by Power App, therefore I decided to stay on the Text colum (there are no many names in the organization) Thanks
Hi @AlexTB ,
1. Add a TextInput Box at the top
2. Set items property of Gallery:
Filter('PR&C Accountability Board',Owner=TextInput1.Text &&Not(Status.Value="Completed"))
Hope this helps
The Status is Choices type column, right?
What is the error message on items property? Please share it via screenshot.
Hi @AlexTB ,
Please try this:
Filter('PR&C Accountability Board';Owner=TextInput1.Text && Not(Status.Value="Completed"))
Change the comma to a semicolon to fit your local language.
so... much better:
1 - the entire formula gives an error (a yellow alert) saying that "&&Not" is not supported by this connector
2 - changing the formula to --> Filter('PR&C Accountability Board';Owner=TextInput1.Text) the filter works but only if I digit some letter. Remaining empty does not appear nothing and this is not what I want. With no input the gallery should show all records
I hope I'm clear 🙂
looking the app checker i noticed a lot of missing accessible labels and I had modified the parameter as suggested from -1 to 0
and I have introduce a name where suggested. Now... the filter, also without the && part is not working even if there is no error. Errors appears in the other pages like: name isn't valid. Is this connected? why there is a suggestion to put a name if them there is conflict?
Additionally, what I wroto above remain:
The first part of filer works (I hope, resolving the above) but only if no digit the gallery remain empty. The second part, excluding "completed" doesn't works .
Thanks for support
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT