what's wrong with this ?

(0) Share

Report

Posted on by tanveal

235

Hi,

Do you see anything wrong in this expression. I cannot filter on email, this first filter works. If I remove the bold, the other filter works.

Filter('Trade Approval Process', Dropdown1.SelectedText.Value in TradeStatus.Value, Trader.Email = "....com")

Categories:

Building Power Apps

All responses (15)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tanveal ,

Firstly I assume Trader is a Person column, the drop-down is a single select and TradeStatus is a Multi-Value Choice or Lookup column. Next I assume you are using SharePoint and your list numbers are under your Delegation limit ? Is all of that correct ?
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tanveal

Try

Filter('Trade Approval Process', Dropdown1.SelectedText.Value in Trade Status.Value || Trader.Email = "....com")
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tanveal

Try

Filter('Trade Approval Process', Dropdown1.SelectedText.Value in Trade Status.Value || Trader.Email = "....com")
tanveal 235 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, I tried above, the filter is not working for email, it's still showing everyone on the list
tanveal 235 on at

Like
a
(0)

Report
Copy link

Link copied!

basically no matter which order the filters are applied in the above expression, email filter (Trader.Email = "....com") doesn't work).
It only works if I remove the other filter (meaning it works in isolation)
tanveal 235 on at

Like
a
(0)

Report
Copy link

Link copied!

Also, I am getting Delegation warning
tanveal 235 on at

Like
a
(0)

Report
Copy link

Link copied!

that's correct
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@tanveal ,

I will leave you in the capable hands of @Drrickryp as you have been responding to him - three way conversations just confuse everyone - but you will get a Delegation warning using the in filter which was why I asked if your records number were under your limit.
tanveal 235 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you, so the warning is not the reason why my filter is not working ?
I used @Drrickryp way but the email filter is not working.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Only if your List record numbers are over your Delegation limit - then it will not work fully.