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

Re: Working with more than 2000 records

Hi Sik,

here is what I got: "Sort" and "Filter" works (SortFilter.png), but "If" doesn't work (If.png).

Is there any other way to select for "Abteilung" and "Klasse" or empty?

Best regards,

Hans Peter

 

AppsBe-Med
Level: Powered On

Re: Working with more than 2000 records

Hi Sik,

selection by "Klasse" works as well. 

If the first two dropdowns ("Abteilung" and "Klasse") are blank and the DatePicker shows the date of today then all the records of today should be shown. How can I handle this as I may not use If()?

Best regards,

Hans Peter

Microsoft v-siky-msft
Microsoft

Re: Working with more than 2000 records

Hi @AppsBe-Med ,

 

Thanks for you debug, that reminds me a thread I ever answered: Hitting Non-Delegable query limit when I think I'm using delegable functions  .

It seems the IF function in the SortByColumns/Filter function will cause the non-delegation error. And the workaround is to move If part function to the beginning of the formula, first to check IF condition. Although you have three if condition, the code could be much complex, I think it deserves a try.

Best regards,

Sik

View solution in original post

AppsBe-Med
Level: Powered On

Re: Working with more than 2000 records

Hi Sik,

so far it works (if.png).

Best regards,

Hans Peter

hpc
Level: Powered On

Re: Working with more than 2000 records

Hi Sik,

it works (All.png, All.png)!

How about the date transfer into numbers? This also doesn't work for big datasets.

Best regards,

Hans Peter

Microsoft v-siky-msft
Microsoft

Re: Working with more than 2000 records

Hi @AppsBe-Med ,

 

it looks good now, but do you still think the gallery doesn't show all match item?

Is there any delegation warning there? How many items it should be?

BR

Sik

hpc
Level: Powered On

Re: Working with more than 2000 records

Hi Sik,

the filter works correct, I get all the items.

Thank you for your patient and extensive help. It is really much appreciated!

Best regards,

Hans Peter

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (4,945)