How can I show data as per user id

[Fabhoreca]

I have a sheet where sales person name is mention with their assigned brand:-

Item ID	Item Name	Brand	Sales Person
835789000000014648	Red Bull ED 330 Ml	Red Bull	Sales Person1
835789000000014657	Red Bull ED 350 Ml	Red Bull	Sales Person1
835789000000014666	Red Bull ED 250 Ml	Red Bull	Sales Person1
835789000000014675	Red Bull ED Red 250 Ml	Red Bull	Sales Person1
835789000000014684	Red Bull ED Sugar Free 250 Ml	Red Bull	Sales Person1
835789000000014693	Red Bull ED Sugar Free 330 Ml	Red Bull	Sales Person1
835789000000014702	Red Bull ED Yellow 250 Ml	Red Bull	Sales Person1
835789000000019046	Apple Juice 1 Ltr	Dabur	Sales Person2
835789000000019055	Real koolerz 2 Juice 125 Ml	Dabur	Sales Person2

Now, I want when a sales person is filling order form having (Sale Person, Order Id, Brand,Item,QTY), Only their linked brand and item will shown.
For example when sale person filled Sales Person 1 then in Brand col only Red Bull will show. 

[Aurelien]

Hi @Fabhoreca 

You may want to use the valid_If expression of the Item.

This is a dependent-dropdown.

Drop-down from Valid_If - AppSheet Help

You may need to use this expression:

FILTER("Item", 
  [Sales Person]=USEREMAIL()
)

Reference: FILTER() - AppSheet Help

 Or, even more efficient: use a security filter, so that the Sales Person can only access the item that matches the assigned brand.

For reference:

Security filters: The Essentials - AppSheet Help