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

[DELEGATION] SHAREPOINT LIST FAIL

Hi All,

 

Before anything, i read, read again and read again this document's:

 

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

 

Maybe I haven't interpreted it correctly. But i used this formula in a SharePoint List:

 

Filter(RegistroPagamentos;ALUNO.Value = GALLERY_1.Selected.NOME)

 

 

SharePoint List is a Delegation Datasource;

Filter is a Delegation Function;

This operator = (only string) is a Delegation operator and yet i receive blue-dot suggestion and my application can't list all records (limited in 500 row's)

 

help-me

14 REPLIES 14
Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

i used others formulas too for test:

 

Filter(RegistroPagamentos;StartsWith(ALUNO.Value;GALLERY_1.Selected.NOME))

and

SortByColumns(Filter(RegistroPagamentos;StartsWith(ALUNO.Value;GALLERY_1.Selected.NOME));"VENCIMENTO";Ascending)

 

 

But no success

 

Community Support Team
Community Support Team

Re: [DELEGATION] SHAREPOINT LIST FAIL

Hi @Moises,

 

Thanks for the feedback.

Delegation is not only related with the function, data source, the field type also have effects on that.

Would you please explain a bit for the ALUNO.Value, and the GALLERY_1.Selected.NOME ?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

Hi @v-micsh-msft,

 

Thanks for your answer.

 

The Aluno is a Lookup Field in SharePoint and Value is a String Value for this Field.

 

GALLERY_1.Selected.NOME is a String Value selected in a gallery of this Screen

 

When i click in a value in GALLEY_1 I'd like Filtering the registers in gallery_2, but I'm being stopped because of this limitation.

 

I don't know if you could understand me.

 

Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

help

Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

Someone?

Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

Other with same problem: http://disq.us/p/1krmo8d

 

 

 

Moises
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

Smiley Sad

Highlighted
Community Support Team
Community Support Team

Re: [DELEGATION] SHAREPOINT LIST FAIL

Hi @Moises,

 

Lookup type currently is not supported for delegation.

As a workaround, we could take use of the following way to make the filter work(without delegation remindings):

Filter(
Addcolumns(RegistroPagamentos;
"SampleALUNO";
ALUNO.Value);
StartsWith(SampleALUNO;
GALLERY_1.Selected.NOME)
)

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndrewLansford
Level: Powered On

Re: [DELEGATION] SHAREPOINT LIST FAIL

Michael's workaround should be marked as the solution. The dot operator for filter is not delegated, but this works like a charm!


@v-micsh-msft wrote:

Hi @Moises,

 

Lookup type currently is not supported for delegation.

As a workaround, we could take use of the following way to make the filter work(without delegation remindings):

Filter(
Addcolumns(RegistroPagamentos;
"SampleALUNO";
ALUNO.Value);
StartsWith(SampleALUNO;
GALLERY_1.Selected.NOME)
)

Regards,

Michael


 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

Top Kudoed Authors
Users Online
Currently online: 150 members 3,206 guests
Please welcome our newest community members: