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"
 )
 )
)

All responses (4)

Answers (1)

pablik01 on at

Like (0)

Report
Re: Gallery not showing when app starts

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" ) ) )
pablik01 on at

Like (0)

Report

Re: Gallery not showing when app starts

Excellent thank you very much!!
Verified answer

SebS 4,141 on at

Like (0)

Report
Re: Gallery not showing when app starts

@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" ) ) )
Rajkumar_404 555 on at

Like (0)

Report

Re: Gallery not showing when app starts

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.