Delegation bug?

(0) Share

Report

Posted on by CAlvy

216

My data row limit is set to 2000 and I have 1000 records.

I was using a gallery filter which is not delegable. On the maker side, it was displaying the records but on the published app it didn't.

After removing the filter, the records display, so it seems as if it's not picking up on my 2000 data row limit.

I'm pretty sure this was working fine yesterday!

I tried changing my authoring version but this hasn't helped. I am now on 3.24052.21.

I did have another bug with the count of gallery items not displaying correctly and updating the authoring version did help this.

Any other suggestions of what I could do?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CAlvy ,

What is your data source type and what is the code (in Text please) that you are using.

Was this reply helpful? Yes No
CAlvy 216 on at

Like (0)

Report
Copy link

Link copied!

Data source is SharePoint and code is:

Filter(SPList,
And(Dropdown_DocFilter_1.Selected.Value = "View all documents" ||
Switch(Dropdown_DocFilter_1.Selected.Value,
"View unlinked documents",
And(IsBlank(Linked_Deliverable.Value),
IsEmpty('Linked Interface')),
"View linked documents",
!IsBlank(Linked_Deliverable.Value) ||
!IsEmpty('Linked Interface'),
"View all documents but cancelled",
Not("Cancelled" in 'Document Title')))
&&
Or(
IsBlank(ComboBox_DocOwner_5.Selected.Value),
IsEmpty(ComboBox_DocOwner_5.SelectedItems),
Originator in ComboBox_DocOwner_5.SelectedItems),
Or(
IsBlank(ComboBox_CTR_3.Selected.Value),
IsEmpty(ComboBox_CTR_3.SelectedItems),
CTR in ComboBox_CTR_3.Selected.Value)
&&
Component_SearchBox_4.SearchValue in 'Document Title')

Was this reply helpful? Yes No
CAlvy 216 on at

Like (0)

Report
Copy link

Link copied!

I have been using Edge. When I try in Chrome it displays all the records.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CAlvy ,

Firstly the suggestion below is using consistent structure (you had a bit of a mix) to make it easier to follow. I cannot see your data, so do not know if your data references are correct, but try this for a start. As the whole thing is not Delegable, I have grabbed the entire list at the start and processed it all locally.

With( {_Data: SPList}, Filter( _Data, ( Dropdown_DocFilter_1.Selected.Value = "View all documents" || Switch( Dropdown_DocFilter_1.Selected.Value, "View unlinked documents", Len((Linked_Deliverable.Value) = 0, "View linked documents", Len(Linked_Deliverable.Value) > 0 "View all documents but cancelled", !("Cancelled" in 'Document Title') ) ) && ( Len(ComboBox_DocOwner_5.Selected.Value) = 0 || Originator in ComboBox_DocOwner_5.SelectedItems ) && ( Len(ComboBox_CTR_3.Selected.Value) = 0 || CTR in ComboBox_CTR_3.Selected.Value ) && ( Len(Component_SearchBox_4.SearchValue) = 0 || Component_SearchBox_4.SearchValue in 'Document Title' ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CAlvy 216 on at

Like (0)

Report
Copy link

Link copied!
Thanks @WarrenBelz
Updated this part of the code to get it working:
Switch( Dropdown_DocFilter_1.Selected.Value, "View unlinked documents", Len(Linked_Deliverable.Value) = 0, "View linked documents", Len(Linked_Deliverable.Value) > 0, "View all documents but cancelled", !("Cancelled" in 'Document Title') )

I can now see all records in Edge - thanks!

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CAlvy ,

This is now solved ?

Was this reply helpful? Yes No