Filter gallery using Or operator missing rows

(0) Share

Report

Posted on by C-Jac

Hi all,

I've run into a problem where my Filter operator including the Or operator filters out to many rows in my gallery.

I have a filter which sorts a list of items, and order numbers, and this list should be filtered to see only the ones the user is related to. The user can be related by two fields in which their email is. Below is the code:

SortByColumns(
Filter(
'[app].[v_VR_Voyage]',
Or( User().Email = EmailField1, User().Email = EmailField2
)) ,
"Item" , Ascending
, "OrderNumber" , Descending
)

For some reason, some of the order numbers are missing, even though the person in charge of it is on the mailing list.

Does anyone know what I'm doing wrong?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @C-Jac ,

User().EMail is not Delegable, but if you do this at App OnStart

Set(varUserMail,User().EMail)

then this should work

SortByColumns( Filter( '[app].[v_VR_Voyage]', EmailField1 = varUserMail || EmailField2 = varUserMail ) , "Item" , Ascending, "OrderNumber", Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @C-Jac ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.