cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenGillard
Level: Powered On

Removing Delegation Warning

I thought i was removing the Delegation warning by using a collection however it still remains. Can anyone suggest a way to remove the delegation warning, or is it not possible?

ClearCollect(OneNoteCol,Search(AllResources_1, "OneNote","Title"))

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
egallis
Level 10

Re: Removing Delegation Warning

Hi @BenGillard,

The best way is to load first your datasource into a global variable first (put it in an OnStart or OnVisible event):

Set(DS_AllResources,AllResources_1)

Then you can proceed with the ClearCollect without having any delegation issue:

ClearCollect(OneNoteCol,Search(DS_AllResources,"OneNote","Title"))

Tell us if this does the trick...

Emmanuel

4 REPLIES 4
egallis
Level 10

Re: Removing Delegation Warning

Hi @BenGillard,

The best way is to load first your datasource into a global variable first (put it in an OnStart or OnVisible event):

Set(DS_AllResources,AllResources_1)

Then you can proceed with the ClearCollect without having any delegation issue:

ClearCollect(OneNoteCol,Search(DS_AllResources,"OneNote","Title"))

Tell us if this does the trick...

Emmanuel

BenGillard
Level: Powered On

Re: Removing Delegation Warning

I now have this is the OnVisible:

Set(DS_AllResources,AllResources_1);ClearCollect(OneNoteCol,Search(AllResources_1, "OneNote","Title"))

It works and gives correct result as it did before but still has delegation warning on the search part of the formula.

Am i doing something wrong?

Thanks

egallis
Level 10

Re: Removing Delegation Warning

@BenGillard,

It's because you need to search on the DS_AllResources datasource now, not on the AllResources_1 anymore Smiley Happy

So your OnVisible property should be:

Set(DS_AllResources,AllResources_1);ClearCollect(OneNoteCol,Search(DS_AllResources, "OneNote","Title"))
BenGillard
Level: Powered On

Re: Removing Delegation Warning

Apologies, I was having a moment!

Thanks so much for the help.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 53 members 4,467 guests
Please welcome our newest community members: