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?
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()?
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.
Watch Microsoft Business Applications Summit sessions on-demand.
Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.
And the winner is...
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020
We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.
Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.