web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery not showing wh...
Power Apps
Answered

Gallery not showing when app starts

(0) ShareShare
ReportReport
Posted on by

Hello, I have a problem with the gallery, or rather with data that does not appear after starting the application. The data is visible after running the search engine or one of the filters. I think the problem is the code in the gallery, because when I remove it and enter it to show only sharepoint data, everything is fine.

 

With({
 asmt: SortByColumns(
 Filter(
 Ksiazka_telefoniczna;
 StartsWith(Nazwisko; searchQuery) || StartsWith(Pokój; searchQuery) || StartsWith(Telefon;searchQuery)
 );
 "field_1"
 );

 asmt_1: SortByColumns(
 Filter(
 Ksiazka_telefoniczna;
 StartsWith(Nazwisko; searchQuery) || StartsWith(Pokój; searchQuery) || StartsWith(Telefon;searchQuery)
 );
 "field_1"
 )
};
 If(
 filtr.Selected.Result = "Pokaż wszystkich pracowników";
 If(
 filtr_1.Selected.Result = "Pokaż wszystkie piętra";
 asmt_1;
 SortByColumns(
 Filter(
 asmt_1;
 Text(Piętro) = filtr_1.Selected.Result
 );
 "field_1"
 )
 );
 SortByColumns(
 Filter(
 asmt;
 Stanowisko = filtr.Selected.Result
 );
 "field_1"
 )
 )
)
Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi @pablik01 

     

    Refer this link : Solved: Show Gallery entries when the app is starting - Ho... - Power Platform Community (microsoft.com)

     

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • Verified answer
    SebS Profile Picture
    4,746 Super User 2026 Season 1 on at

    @pablik01 

     

    You do not handle Your Blank Controls means the code expect your controls to provide something 

     

    You need to add IsBlank(searchQuery) for example

     

    With({
     asmt: SortByColumns(
     Filter(
     Ksiazka_telefoniczna,
     IsBlank(searchQuery) || StartsWith(Nazwisko, searchQuery) || StartsWith(Pokój, searchQuery) || StartsWith(Telefon,searchQuery)
     ),
     "field_1"
     ),
    
     asmt_1: SortByColumns(
     Filter(
     Ksiazka_telefoniczna,
     IsBlank(searchQuery) || StartsWith(Nazwisko, searchQuery) || StartsWith(Pokój, searchQuery) || StartsWith(Telefon,searchQuery)
     ),
     "field_1"
     )
    },
     If(
     filtr.Selected.Result = "Pokaż wszystkich pracowników",
     If(
     filtr_1.Selected.Result = "Pokaż wszystkie piętra",
     asmt_1,
     SortByColumns(
     Filter(
     asmt_1,
     IsBlank(filtr.Selected.Result) || Text(Piętro) = filtr_1.Selected.Result
     ),
     "field_1"
     )
     ),
     SortByColumns(
     Filter(
     asmt,
     IsBlank(filtr.Selected.Result) || Stanowisko = filtr.Selected.Result
     ),
     "field_1"
     )
     )
    )

     

  • pablik01 Profile Picture
    on at

    Excellent thank you very much!!

  • pablik01 Profile Picture
    on at

    I messed something up, I wanted to add another filter and everything fell apart

    With({
     asmt: SortByColumns(
     Filter(
     'TELEFONY — kopia';
     IsBlank(searchQuery) || StartsWith(Nazwisko; searchQuery) || StartsWith(Pokój; searchQuery) || StartsWith(Telefon;searchQuery)
     );
     "field_1"
     );
    
    
    
     asmt_1: SortByColumns(
     Filter(
     'TELEFONY — kopia';
     IsBlank(searchQuery) || StartsWith(Nazwisko; searchQuery) || StartsWith(Pokój; searchQuery) || StartsWith(Telefon;searchQuery)
     );
     "field_1"
     );
    
     asmt_2: SortByColumns(
     Filter(
     'TELEFONY — kopia';
     IsBlank(searchQuery) || StartsWith(Nazwisko; searchQuery) || StartsWith(Pokój; searchQuery) || StartsWith(Telefon;searchQuery)
     );
     "field_1"
     )
    
    
    };
     If(
     filtr.Selected.Result = "- Pokaż wszystkich pracowników -";
    
     If(
     filtr_1.Selected.Result = "- Pokaż wszystkie piętra -";
    
    If(
     filtr_2.Selected.Result = "- Pokaż wszystkie komórki -";
    
     asmt_1;
    
     SortByColumns(
     Filter(
     asmt_1;
     IsBlank(filtr.Selected.Result) || Text(Piętro) = filtr_1.Selected.Result
     );
     "field_1"
     )
     );
    
    
     SortByColumns(
     Filter(
     asmt;
     IsBlank(filtr.Selected.Result) || Stanowisko = filtr.Selected.Result
     );
     "field_1"
     )
     );
    
    
     SortByColumns(
     Filter(
     asmt_2;
     IsBlank(filtr.Selected.Result) || Komórka Organizacyjna = filtr_2.Selected.Result
     );
     "field_1"
     )
     )
    
    )

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard