Properly set delegation formula not delegating

[mp6]

I haven't seen any posts with similar issues...

I have a completely delegable function:

ClearCollect(RouteInfo7,Filter('HB Orders',DateID=SelectedRoute));

'HB Orders' is a SharePoint list, and  the DateID field and SelectedRoute are both numbers.

However, the function is not delegating! I know this for a fact because I changed the non-delegation collection limit to 1, and it only loaded one row. Its causing the app to be extremely slow to start.

Any suggestions or clues why this would be the case?

[WarrenBelz]

Hi @mp6 ,

Firstly, what is your Data Source?

The code you posted is Delegable in SharePoint, but nothing is Delegable in Excel (which does not understand what the word means)

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.

Visit my blog Practical Power Apps

[Ramole]

Hi @mp6 

Try this 

Filter('HB Orders',DateID= Value(SelectedRoute))

[mp6]

The data source is SharePoint list

[mp6]

Hi, thanks for your suggestion. It doesn't collect anything now (not even 1)

[mp6]

Hi, thanks for your suggestion. It doesn't collect anything now (not even 1

[Ramole]

ClearCollect(RouteInfo7,Filter('HB Orders',DateID= Value(SelectedRoute))

[mp6]

Thanks.

Error... did you mean to put two "Filter" twice?

[mp6]

@WarrenBelz I took out the second filter, but its still not delegating (only collecting my non delegation limit)

[mp6]

@Ramole Actually, it does collect, but it's still not delegating (only collects what my limit is set to)