Unanswered

Gallery Search and ForAll

(0) Share

Report

Posted on by SevenWishes

Hi,

I am trying to create a gallery search with ForAll. The ForAll code helps me to remove duplicate items in the SharePoint list which I need to operate. Also, I want to add search function to look for.

This code is located in gallery items:

ForAll(
 Distinct(
 'SharepointList',
 Name
 ),
 LookUp(
 'SharepointList',
 Name = Result
 )
)

I want to add to this code a search value and I have a problem connecting it to ForAll, please let me know if this is possible somehow:

Search('SharepointList', TextInputSearch.Text, "Name")

Both codes work as they should be only they need to be separated, when I want to add them together using "; " I have an error: we expecting operators such as "+" or "&" at this point,

Thanks for help or a different solution

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report
Hi @SevenWishes ,

The Items property will only take a single command, so you have to nest the commands. For that I would use a filter:

Filter( ForAll( Distinct( 'SharepointList', Name ), LookUp( 'SharepointList', Name = Result ) ), If( !IsBlank(TextInputSearch.Text, TextInputSearch.Text In Name, true) )

Disclaimers:
You may want to change the expression in the filter command as "In" is not delegable.
I didn't have time to test the above, this is just what I think it should look like.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
@SevenWishes ,

I'm not sure that is the right approach as sending a large number of queries to SharePoint for each lookup function call will affect the app responsiveness:

ForAll( Distinct( Filter('SharepointList',StartsWith(Name,TextInputSearch.Text)), Name ), LookUp( 'SharepointList', Name = Result ) )

Please note that the Search() function is not delegable to SharePoint and you will get an warning.

To help you optimize the app, I need more details about the app scenario.

Hope it helps !

Was this reply helpful? Yes No