Filter Gallery by current user and combobox

(0) Share

Report

Posted on by Dive1

169

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 ?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

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

Was this reply helpful? Yes No
Dive1 169 on at

Like (0)

Report
Copy link

Link copied!

thanks it worked

Was this reply helpful? Yes No