cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Using delegable function with SharePoint cause blue exclamation error

I am using a LookUp with SharePoint using '=' or 'in' which is supposed to be supported according to this page, but I am getting a blue dot. Why?

 

 2.JPG

 

ForAll(Beneficiary_Collection,
Patch(Beneficiary,LookUp(Beneficiary, Beneficiary_GUID in Beneficiary_Collection[@Beneficiary_GUID]),
{
...
}))

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Using delegable function with SharePoint cause blue exclamation error

Please note that other functions are supposrted but they're just not deletgable. With 20-50 items you hsould be good to ingore the warning and go ahead with the update.

View solution in original post

6 REPLIES 6
Highlighted
Microsoft
Microsoft

Re: Using delegable function with SharePoint cause blue exclamation error

Hello Kevin,

 

The issue is most likely in the "First" function that is not delegable. You can find more details here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Highlighted
Advocate I
Advocate I

Re: Using delegable function with SharePoint cause blue exclamation error

@dinusc Even without First I get the same error. Please see my updated post.

Highlighted
Microsoft
Microsoft

Re: Using delegable function with SharePoint cause blue exclamation error

You removed the "First" function but you also replaced "=" with "in" which is not delegable. Please see this: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list

Highlighted
Super User
Super User

Re: Using delegable function with SharePoint cause blue exclamation error

In is not supported by SharePoint. Sorry. Need to come up with a clever workaround or change data sources.

 

How many items do you have in your list?

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted
Advocate I
Advocate I

Re: Using delegable function with SharePoint cause blue exclamation error

@ShanescowsI'm still in shock that PowerApps doesn't support so many basic things. Anyway, I need to update ~20-50 items.

Highlighted
Microsoft
Microsoft

Re: Using delegable function with SharePoint cause blue exclamation error

Please note that other functions are supposrted but they're just not deletgable. With 20-50 items you hsould be good to ingore the warning and go ahead with the update.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,554)