Hello I've a gallery where it show data that user have created in the app and i want that only the user be able to see what i created
With({_item:Opportunités};Search(Filter(_item;'Créé par'.Email=User().Email&&IsEmpty(ComboBoxEtatFiltre.SelectedItems)||(Concat(ComboBoxEtatFiltre.SelectedItems;Value&",") in Concat(Etat;Value&",")));SearchBox.Text;"Nomclient";"Title"))
it's my code in item in my gallery so it worked first but when I've added the combobox to filter the gallery it didt worked anymore but the filter with the combobox work any idea why ?
thanks it worked
@Dive1 ,
The cause might be a confusion in your Filter condition. The OR condition need to be treated separately to AND. Use this:
With(
{_item:Opportunités};
Search(
Filter(_item;'Créé par'.Email=User().Email &&
(IsEmpty(ComboBoxEtatFiltre.SelectedItems)||
(Concat(ComboBoxEtatFiltre.SelectedItems;Value&",") in Concat(Etat;Value&","))
)
);
SearchBox.Text;
"Nomclient";
"Title")
)
Hope it helps !