Answered

Sharepoint Delegation Function not working as expected

(0) Share

Report

Posted on by insights

Hello,
I have a sharepoint source with 504 rows and limit of 500 rows.
Applied a delegation function (filter + starts_with) on the source. But its not returning me the expected data.

Works fine if I increase limit to 2000 rows, but its a temporary solution.
Not sure what is the issue

Can youplease help? Attaching screenshot below
Thanks!!!!

Screen Shot 2022-03-26 at 3.05.45 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @insights ,

Assuming SharePoint_Item_Amount is your List and _TYP is a Single Line of Text, what type of field is _TID and what is _TXD?

Was this reply helpful? Yes No
insights 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for the reply
_TID and _TYP both are multiple lines of text in sharepoint list... _TXD is transaction id variable (string)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@insights ,

That is why you have the Delegation error - queries on Multiple Lines of Text are not 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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @insights ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
insights 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thank you so much. This resolved the issue. You are amazing!
Not sure why I couldn't find it in the official documentation.
Would have saved so many hours of my volunteering work 🙂

Was this reply helpful? Yes No