because my sharepoint list has more than 5000 items and there is a problem with searching (after indexed columns, Sharepoint search input show nothing). I'm trying to create a PowerApp for search in this sheet.

One of the column in the Sharepoint List is LookUp, and items are stored in another List. This code below works good in my PowerApp search input txtSearch

With(
    {itemDoda: txtSearch.Text},
        Filter(
        'ListA',
        'ListAColumnName'.Value = itemDoda
    )
)

But, is it possible to change this code to search in fulltext?

When i have item in the listroses are red and in txtSearch put only roses found nothing.

Thx for any advice.

Because my SharePoint list has more than 5000 items and there is a problem with searching (after indexed columns, SharePoint search input show nothing). I'm trying to create a PowerApp for search in this sheet.

One of the column in the SharePoint List is LookUp, and items are stored in another List. This code below works good in my Power Apps search input txtSearch

With(
    {itemDoda: txtSearch.Text},
        Filter(
        'ListA',
        'ListAColumnName'.Value = itemDoda
    )
)

But, is it possible to change this code to search in fulltext?

When I have item in the list  roses are red and in txtSearch put only roses found nothing.