Power Platform Community Forum Thread Details

Hi,

I have 10K items in SharePoint list which is being shown in the gallery using below formula.

If(
!IsBlank(TextInput3.Text),
SortByColumns(
Filter(
DataSource,
StartsWith(
BodySingleLineofText,
TextInput3.Text
) Or StartsWith(
AuthorName,
TextInput3.Text
) Or StartsWith(
ArticleYearSLOT,
TextInput3.Text
) Or StartsWith(
AuthorDisplayName,
TextInput3.Text
) Or AuthorName = TextInput3.Text Or ArticleYearSLOT = TextInput3.Text
),
"Date_Posted",
Descending
),
SortByColumns(
DataSource,
"Date_Posted",
Descending
)
)

Now I want to implement search functionality which will search by newsfeed description (multiple lines of text) and show me the search results in gallery, order by newsfeed posted date descending.

May I know how to modify the above code to include search by description which will atleast search across 2000 records and show it in chronological order. I tried adding search function in above code but doesn't work properly

Categories:

Building Power Apps

@Iantaylor2050

For 10k items you will need to narrow down the list to 2k first perhaps with the other filters and use a second textinput box for the search. This would require the TextInput3 to not be blank in order to achieve this, as searching >2000 items is not delegatable in SharePoint. If the _items table is >2000, the users should be warned that the search may be incomplete.

With({_items: SortByColumns(
 Filter(DataSource,
 Or(
 StartsWith(BodySingleLineofText, TextInput3.Text),
 StartsWith(AuthorName,TextInput3.Text), 
 StartsWith(ArticleYearSLOT,TextInput3.Text),
 StartsWith(AuthorDisplayName,TextInput3.Text),
 AuthorName = TextInput3.Text, 
 ArticleYearSLOT = TextInput3.Text
 )
 ),"Date_Posted",Descending
 )
 },
 Search(_items, TextInput4.Text,"Newsfeed Description"),
 If(
 CountRows(
 _items)=2000,Notify("Searching Newsfeed Description May Be Inaccurate", Error)
 ) 
)

* you may need to use intellisense for "Newsfeed Description". FYI: Don't uses spaces or special characters in Sharepoint column names.