Answered

Delegation workarounds - current filter not working

(0) Share

Report

Posted on by ctedesco3307

754

Hello - this is my current code for a Label. The Status.Value <> "D" part does not appear to be working. I get the delegation error message - and when I put in a value that has a status of D it still returns a result. It should say TIN Not Found

Assuming delegation is the reason why - the list has 27,000 records in it. Looking for suggestions for workarounds.

Thank you

LookUp(

'TIN Crosswalk',

txtTINNew_2.Text = TIN && Status.Value <> "D",

Prov_Acct_ID

"TIN NOT FOUND"

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

MVP-Phipps 3,514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Here is an article you will find useful in order to learn about Delegation, and how to avoid delegation: https://devoworx.net/how-to-overcome-powerapps-delegation-limit/#:~:text=To%20avoid%20the%20delegation%20warning%20in%20PowerApps%2C%20try%20wisely%20to,the%20value%20above%20500%20records.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
The <> is the operator that isn't delegable. Since the operator is being used with a status column maybe you don't have too many status options and could use the "=" operator on the options you want. See example below.

LookUp('TIN Crosswalk', txtTINNew_2.Text = TIN && (Status.Value = "A" || Status.Value = "B" || Status.Value = "C" || Status.Value = "E"), Prov_Acct_ID)

Was this reply helpful? Yes No
ctedesco3307 754 on at

Like (1)

Report
Copy link

Link copied!

@Jeff_Thorpe That took away the delegation error - thank you!

Was this reply helpful? Yes No