web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery Search and ForAll

Power Apps

Answered

Gallery Search and ForAll

(0) Share

Report

Report

Posted on by SevenWishes

47

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
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.
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@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 !

Join the conversation