Delegation workaround for StartsWith in SharePoint

(0) Share

Report

Posted on by WebPortal

2,297

Hi all,

Is there a workaround to solve the following delegation issue with a SharePoint list called from a Gallery:

Filter(
 MySPList,
 StartsWith(Num_Invoice, SearchBoxTextInput.Text) 
)

Where Num_Invoice is a number.

I can see in the documentation that StartsWith is delegable for Text only, for SharePoint and Dataverse, so even if we upgrade from SharePoint to Dataverse, we will still have the same issue.

So, is there a workaround to show a text input box where the user enters a number (eg: invoice number) and the gallery below it will not have delegation issues?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @WebPortal ,

Maybe simply storing the number as Text in another hidden field - you can make the Default of this

Text(Num_Invoice)

and it would save with each record - you can then use StartsWith() on this field.

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
WebPortal 2,297 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
Thanks, I was thinking about adding a new Text column to SharePoint as text, to be used as a search field.
Is that what you are proposing?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@WebPortal ,

Yes - exactly, although I do not bother with number columns at all when I think I may need to search on them and simply store the value as Text.

Was this reply helpful? Yes No