Hi.
I have a sharepoint list which has a Main Owner and Secondary Owner Column which are People and Group Type, there is a also an Item Name in the SharePoint List.
My aim is to search on Item Name and the Main / Secondary Owner.
I have placed a data table on my power app which shows the Item Name, Main Owner and Secondary Owner.
On my items property on the data table, i have the following code : Search('MyDataSource', txt_Search.Text,"ItemName")
This works absolutely fine. Now i wish to incorporate a Filter in the search box so it allows the user to filter the data table based on the Main Owner and Secondary Owner..
I have tried the following : Filter(
Search(
'MyDataSource',
txt_Search.Text,"Name"
),txt_MO_and_SO_Search.Text,'Main Owner')
But it doesn't work. Basically, i know Search does not work on People and Group Fields, however, the Filter does.
I dont want to create another search box on the page to filter the data source by owner, i would like to use the same search box to search on item name and also filter the data set by owner and secondary owner.
Can anyone help?
Thanks
