How can I rewrite this query to avoid delegation

(0) Share

Report

Posted on by Kirah

Hello Community,

Please how can I rewrite this query to avoid the delegation issue caused by 'Lower()'

Filter(Sort('App System', Created, Descending),(Lower('Negotiator Assigned'.Email)= Lower(User().Email)))

Thanks in advance.

Kira

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kira-Daw ,

You actually mean to include Delegation (you currently do not have it). Lower() is not Delegable and it is your only filter - you can do this

With( { wData: Sort( 'App System', Created, Descending ), wMail: Lower(User().Email) }, Filter( wData, Lower('Negotiator Assigned'.Email) = wMail ) )

and it will action the newest (Delegation Limit) records with the bottom filter, but that is the best you will do short of (I recommend this as I have done it) cleaning up your data so the emails are all Lower Case and then enforcing this on new records.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Thanks for your response.

you said : ' it will action the newest (Delegation Limit) records with the bottom filter , but that is the best you will do short of'
I'm not sure what you mean. Can you please explain further, Do you mean I will still face delegation issue with this approach?

I'm not sure we can manipulate the capitalisation of the email addresses, as they are derived from a people picker and stored in the Sharepoint List.

I look forward to your response on this, Thanks in advance.

Regards
Kira

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kira-Daw ,

Yes - you pretty much nailed - Lower() simply is not Delegable. You need to have at least have your SharePoint list in lower case, then

With( {wMail: Lower(User().Email)}, }, Filter( wData, 'Negotiator Assigned'.Email = wMail ) )

will be Delegable.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thats great, thanks alot for the guidance.

Regards
Kira

Was this reply helpful? Yes No