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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
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 pablik01

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:
Building Power Apps
I have the same question (0)
  • Rajkumar_M Profile Picture
    Rajkumar_M 3,743 Super User 2025 Season 2 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
    SebS 4,686 Moderator 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
    pablik01 on at

    Excellent thank you very much!!

  • pablik01 Profile Picture
    pablik01 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

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 408

#2
WarrenBelz Profile Picture

WarrenBelz 382 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 328 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans