Handling delegation warnings

(0) Share

Report

Posted on by bchager6

132

Hi everyone...

I inherited a Power App with a page connected to a SharePoint list that's returning a delegation warning. I've been able to handle a different delegation warning by using the StartsWith function within the Items property of a gallery, but I need help with the below formula.

Can anyone suggest where I might insert, "StartsWith?"

SortByColumns(Filter('SharePointList',(Title_search.Text in Title || Title_search.Text in Author.DisplayName || Title_search.Text in Owner.Value) || IsBlank(Title_search.Text)),"Title")

Thanks in advance to anyone who can help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bchager6

Let me give you an example here is a code am using multi StartsWith and is delegable which you can amend to your requirements

Filter(Customers, ( Or( StartsWith(Company,InpSearchCustomerMain.Text), StartsWith('Business Phone',InpSearchCustomerMain.Text), StartsWith(City,InpSearchCustomerMain.Text), StartsWith(Address,InpSearchCustomerMain.Text), StartsWith('ZIP/Postal Code',InpSearchCustomerMain.Text) ) )))

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bchager6

That this Solve what you have asked?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @bchager6 ,

Try this

SortByColumns( Filter( 'SharePointList', Len(Title_search.Text) = 0 || ( StartsWith( Title, Title_search.Text ) || StartsWith( Author.DisplayName Title_search.Text ) || StartsWith( Owner.Value, Title_search.Text ) ) ), "Title" )

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
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bchager6
Let me know if you need any more assistance.

Was this reply helpful? Yes No