Invalid Argument Type

[Anonymous]

I am using my data source as an excel and trying to filter my list using the below

Filter(Travel,Travel.Email=User().Email)

But it show invalid argument type, I have tried In and ExactIn but those does not work.

Any help would be appreciated.

[hpkeong]

Hi
Is Travel is already an Email?
I doubt you should put it as
Travel.Text = User().Email

Please verify.
Tq

[CarlosFigueira · Accepted solution]

Assuming that Email is a column in the Travel list, then you don't need to specify the list name the filter expression. This should work:

Filter(Travel, Email = User().Email)

The term 'Email' in the expression above is bound to each individual item in the Travel list that is being filtered.

When you say 'Travel.Email', you're referring to all of the values of the Email column in the Travel list, and that cannot be compared with a single value, which is why you see the error you have.

[hpkeong]

Hi @CarlosFigueira

You are right Email=User().Email..I wrote wrongly as Travel and thanks for the correction,

TQ

[Anonymous]

Great, that works. Thank you