
I want to do two thing in the same gallery
1st - Fetch only those employees which belong to a particular manager
2nd - Add a search so that i can search through that Gallery for a particular employee
My functions are
Filter(EmployeesTables,Manager = manager) // 'manager' is a variable i have with the manager name stored.
Search(EmployeesTables,Search.Text,"cr011_name") // 'cr011_name is the name of the employee in the EmployeesTable
Both of them are to be added in the items property of the gallery , how can i achieve that ? Need Help
@PAJ ,
Like this
Search(
Filter(
EmployeesTables,
Manager = manager
),
Search.Text,
"cr011_name"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps