Announcements
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.
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.
Hi @CarlosFigueira
You are right Email=User().Email..I wrote wrongly as Travel and thanks for the correction,
TQ
Great, that works. Thank you
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
