Delegation Warning - Creating Form for SharePoint List

[Anonymous]

Hi,

I'm creating a form within Power Apps to use with a SharePoint list. I have never created a form or used Power Apps before. When I linked the Power Apps form with my SharePoint list, I received a "delegation warning" without clicking on a thing. All I did was connect the list to Power Apps and had a warning immediately.

The SharePoint list does not contain more than 500 records because it is fairly new. However, I expect to be using it for many years while keeping track of some items, so one day it should exceed this limit. I don't know how to simplify the formula or move the data to a different data source.

This is the formula that triggered the delegation warning:

*The name of my SharePoint list has been redacted for privacy.

Should I delete the formula because I'm creating a form from scratch? Or would that "break" something?

Any help would be greatly appreciated. Thank you!

[WarrenBelz]

Hi @Anonymous ,

Just change all of that to 

SharePointIntegration.Selected

(the last bit without the closing bracket). This is an oversight from Microsoft (to actually set it up that way by default).

If you want to know more about Delegation, I have done a blog on it.

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.

[Anonymous]

Thanks for the response. @WarrenBelz 
I'd like for the form to display some of the preexisting data in the SharePoint list. When I change the formula to what you suggested, the data disappears from the form. This happens while viewing in edit mode.
When I changed the formula I copied and pasted your suggestion into the bar.
Did I follow your instructions correctly?

[WarrenBelz · Accepted solution]

@Anonymous ,

It will initially, but if you save and go back in again, it should show a record (mine all do and I have changed every Integrated Form to this). Also it will work perfectly when you select a record from SharePoint (to edit or view). As mentioned this is something Microsoft should fix. If you leave it the way it is (and ignore the Delegation Warning), it will also function.

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.

[WarrenBelz]

Hi @Anonymous ,

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.

[Anonymous]

Hi, @WarrenBelz 

I opted to ignore the delegation warning. I was still having issues with the form failing to populate when I changed the formula to the one you provided.

Thank you for your help!