"Empty" gallery when opening an app any fix ?

(0) Share

Report

Posted on by Dive1

169

When I open my app the gallery is empty I have to select a value in the combox to be able to see the gallery

SortByColumns(
 Search(
 Filter(Opportunités;'Créé par'.Email=User().Email &&
 (IsEmpty(ComboBoxEtatFiltre.SelectedItems)|| 
 (Concat(ComboBoxEtatFiltre.SelectedItems;Value&",") in Concat(Etat;Value&","))
 )
 );
 
 SearchBox.Text;
 "Nomclient";
 "Title");
 "Created"; If(SortDescending1; Descending; Ascending))

here my code in the gallery is this baceause of this or it's a problem of power apps and they're any fix ?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Dive1

Please consider changing your Formula to the following:

SortByColumns( Search( Filter(Opportunités;'Créé par'.Email=User().Email && (IsBlank(ComboBoxEtatFiltre.SelectedItem.Value) || (Concat(ComboBoxEtatFiltre.SelectedItems;Value&",") in Concat(Etat;Value&",")) ) ); SearchBox.Text; "Nomclient"; "Title"); "Created"; If(SortDescending1; Descending; Ascending))

Your problem is with the IsEmpty of the filter. The IsEmpty on the SelectedItems will never be true. Instead simply use IsBlank on the SelectedItem.

I hope this is helpful for you.
Dive1 169 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you it worked that was it