Power Platform Community Forum Thread Details

Hi all,

I have a search box at the top of my gallery, which is searching by Title and by Assigned Director at the minute. I'm using the following formula:

Filter('PMO Portfolio List',StartsWith(Title,SearchInput_2.Text) || StartsWith('Assigned Director'.DisplayName,SearchInput_2.Text), SortOrder.Descending)

However, I'd also like the user to be able to use the search box (SearchInput_2) to be able to search by the ID number and by "Assigned Lead / BPM Specialist" which is a MULTI SELECTION people picker column.

Any guidance on what formula I could use for that, please?

Categories:

Building Power Apps

Hi @EuniceG11 ,

I assume you want to sort this (you have a sort order but no sort command or column. The With()) statement is only to retain some sort of Delegation capability as both elements of the bottom filter are not Delegable, so depending on the size of your list you may not get full results unless a smaller set is returned by the top filter

With(
 wData:
 {
 Sort(
 Filter(
 'PMO Portfolio List',
 StartsWith(
 Title,
 SearchInput_2.Text
 ) || 
 StartsWith(
 'Assigned Director'.DisplayName,
 SearchInput_2.Text
 ),
 YourSortFieldHere,
 SortOrder.Descending
 )
 },
 Filter(
 AddColumns(
 wData,
 "IDNo",
 Text(ID)
 ),
 SearchInput_2.Text in 'Assigned Lead / BPM Specialist'.DisplayName ||
 SearchInput_2.Text in IDNo
 )
)

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