Power Apps SharePoint Lookup Column Not Auto Filling Report ID

(1) Share

Report

Posted on by CU15031730-0

I am building a Field Service Report app using Power Apps Canvas App with SharePoint lists.

Lists I created:
• Field Service Report
• Parts List
• Technician Entries

I have attached screenshot .

Search([@'Field Service Reports'], SearchInput1.Text, Title, Title)

But it shows errors.

Any guidance would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

PowerDeveloperTP 453 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello,

This is not really error, but its shows delegation warning that search will not work on large database. By default it is set to 500 and you can increase the limit to 2000 in settings of power app. You can find more details in below url

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Hope this helps.

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Please try below :

Filter([@'Field Service Reports'], StartsWith(Title, SearchInput1.Text))

Was this reply helpful? Yes No
Suggested answer

ITWithAllan 160 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

That's not an error, it's a warning. You'll be able to publish it and use it but microsoft is warning you that some error may occur in the future. (Probably because sharepoint has delegation issues (in larges lists you won't be able to load all your data, so it's recommended for you to always filter it or use dataverse if possible))

Was this reply helpful? Yes No
Suggested answer

Ytalo Silva 193 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @CU15031730-0

As mentioned by @PowerDeveloperTP, this is not an “error,” but just a delegation warning.

Based on your formula, I assume you want to filter a gallery using a text input. One approach I recommend, which does not trigger a delegation warning, is to use Filter, like this:

Filter( 'Field Service Reports', Or(IsBlank(SearchInput1.Text), Title = SearchInput1.Text) )

I hope this helps!

Was this reply helpful? Yes No