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

Unable to delegate Filter to Sharepoint

Hi,

 

I have assigned the following to the datasource of a gallery and for some reason, I'm getting the blue underline at Id=2.

 

SortByColumns(Search(Filter(translated_database,status.Id=2), TextSearchBox1_1.Text, "cn","en"), "en", If(SortDescending1, Descending, Ascending))

 

Firstly, the "status" column is a lookup column from another SPlist. As such, it was my understanding that the Filter command can be delegated to Sharepoint, so I don't know what I'm doing wrong here. Any thoughts? I know that the Search function will happen locally, which is fine so long as the datasource is filtered first. My issue is that my data will have at least 3000 to 4000+ records within a few weeks of getting it implemented, so proper filtering is a must.

 

Is it because I'm trying to apply a filter to a LookUp column?

 

Additionally, I want to be able to Search through my People and LookUp columns; how do I do that?

3 REPLIES 3
sfishe
Level: Powered On

Re: Unable to delegate Filter to Sharepoint

I have this issue too. On the Items property of a Gallery I have the following:

 

SortByColumns(Filter('Exp Behaviour 2', Animal_rel0.Value = Gallery_Animals.Selected.Title), "Exp_x0020_Date", SortOrder.Descending)

These tables are on SharePoint lists. This operation isn't working at present - it's not returning records beyond the first 500. And I get the blue "i" dot and a squigly line over the ".Value = " part above.

 

I thought Filter and the = operator are delegatable, and hence shouldn't be a problem?

Highlighted
ScienceDept
Level: Powered On

Re: Unable to delegate Filter to Sharepoint

I'm fairly certain it's the lookup or calculation from another column in the list that makes it non-delegatable. I had an issue with using filter on a column thatgot its values from left(Anothercolumn,2) and powerapps wouldn't delegate it (although I don't think I got the warning blue i) it just didn't look past 500 records. I remade the column without the dependency on another column and it worked fine.

Super User
Super User

Re: Unable to delegate Filter to Sharepoint

Hi @sfishe,

 

The delegation function from Sharepoint is still a work in progress as far as I can see, yes the filter function works, but there are limitations - although several other operators are listed as capable of delegation, I've only found that they work at present for text fields and for number-type columns as these both have explicit static fields.
So you can't point to the value of a selected radio or dropdown control or etc.

 

 

Create a new Text column in SharePoint, Call it Animal_rel0Value,

Refresh the data source in your app, add that column as a field within your forms.

In any of your edit/new screens have your app fill the Default value of the Textbox within the Animal_rel0Value Card with Text(Animal_rel0.Value) during every edit/new item (or go into sharepoint and retrospectively copy/paste the text value for all historic items OR create a Flow that extracts Animal_rel0.Value and creates a new Text Column based on that or fills a column with these values). you should ahve this as an invisible card as we don't want users to alter the value as it's only pulling the text value from a choice item.

 

Once those fields are filled, you can change your filter to:

Filter('Exp Behaviour 2', Animal_rel0Value = Gallery_Animals.Selected.Title)

Which should then be Delegable,

 

Cheers,

ManCat




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

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

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 224 members 4,740 guests
Please welcome our newest community members: