//Items//
FirstN(Sort(
Filter(
Test3,
//Check if length of selected is zero, else filter by that selection
Len(DropdownCanvas1.Selected.Value)=0 || DropdownCanvas1.Selected.Value = NPT.Value,
Lower('Created By'.Email) = Lower(User().Email)
),
ID,SortOrder.Descending
),
500
)
With(
{
_Data:
Sort(
Filter(
Test3,
Len(DropdownCanvas1.Selected.Value) = 0 ||
NPT.Value = DropdownCanvas1.Selected.Value,
'Created By'.Email = User().Email
),
ID,
SortOrder.Descending
)
},
FirstN(
_Data,
500
)
)
Hello, there are a few ways to retrieve records that exceed 2000. If you're having difficulties with this and want to fetch more than 2000 records, one suggestion is to create a collection in the app's OnStart as follows:
This way, it will fetch more than 2000 records.
Another suggestion is to create a pagination system that adds more records to the collection as you navigate through the pages.
If you encounter a delegation warning on the ID field, one solution is to create a mirrored column of the ID in number format. This can help resolve the delegation warning.
I hope this helps provide some guidance.
Stay up to date on forum activity by subscribing.