Answered

Delegation workarounds - current filter not working

(0) Share

Report

Posted on by ctedesco3307

623

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"

All responses (3)

Answers (1)

ctedesco3307 623 on at

Like (1)

Report

Re: Delegation workarounds

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

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Re: Delegation workarounds

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)
MVP-Phipps 3,447 Super User 2024 Season 1 on at

Like (0)

Report

Re: Delegation workarounds

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