Answered

Search not working properly in gallery

(0) Share

Report

Posted on by Iantaylor2050

603

I have a powerapps canvas app with sharepoint as the datasource. I noticed that search is working fine, however returning some blank results as well, which should not happen.

I suspect its due to the ForAll function in Items property of the code. May i know where i am going wrong?

Items Property of Gallery

With(
    {
        uniqueID: ForAll(
            Distinct(
                Filter(
                    'Events',
                    Start_Date_and_Time > Now()&& Status = "Active"
                ),
                EventUniqueID
            ),
            {Result: ThisRecord.Value}
        )
    },
    Sort(
        ForAll(
            uniqueID As CurrentID,
            First(
                Sort(
                    Filter(
                        'Events',
                        (Len(RegSearch_2.Text) = 0 || RegSearch_2.Text in Title)&&EventUniqueID = CurrentID.Result && Start_Date_and_Time > Now()
                    ),
                    Start_Date_and_Time,
                    SortOrder.Ascending
                )
            )
        ),
        Start_Date_and_Time,
        SortOrder.Ascending
    )
)

Screenshot of Gallery when searched

It should show only the first box which has data and other box which are blank should be hidden when searched

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

abc 123 789 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Far too complicated. Break down to just a couple of collections.

Was this reply helpful? Yes No
Iantaylor2050 603 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Could you please help me out on this?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,327 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi iantaylor2050

You are are firstly getting all the Distinct values from 'Events' of the field EventUniqueID, then for each of them filtering the same list with additional criteria and then looking for the matching record. If there is none (as it did not match the bottom filter), you will get a blank result - so maybe do the all the filtering first
With( { uniqueID: Distinct( Filter( 'Events', Start_Date_and_Time > Now() && Status = "Active" && (Len(RegSearch_2.Text) = 0 || RegSearch_2.Text in Title) ), EventUniqueID ) }, Sort( ForAll( uniqueID As CurrentID, LookUp( 'Events', EventUniqueID = CurrentID.Value ) ), Start_Date_and_Time, SortOrder.Ascending ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No