Filtering List

[habibbs23]

hello i would like to use a condition where UserEmail is equal to the user logged in
how can i solve this following error?

[mateo]

If I understand correctly you put 2 conditions into select(), right?

1. [orderstatus] = “pending”
2. orderlist[useremail] = useremail()

If so, maybe try to write:

SELECT(
orderlist[useremail];
AND(
[orderstatus] = “pending”;
[useremail] = USEREMAIL()
)
)

Hope it helped

[habibbs23]

yes i tried it
but i get the same error saying email type can be compared with list type.
[useremail] in orderlist is a list type as one email can have multiple [orderid].

[Steve]

help.appsheet.com

IN()

Is item in list?