Answered

Gallery not showing when app starts

(0) Share

Report

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)

All responses (4)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

SebS 4,746 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
pablik01 on at

Like (0)

Report
Copy link

Link copied!

Excellent thank you very much!!

Was this reply helpful? Yes No
pablik01 on at

Like (0)

Report
Copy link

Link copied!
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" ) ) )

Was this reply helpful? Yes No