Marcel Lehmann

Do you create dropdown or combobox lists that depend on other lists, such as categories, subcategories, and additional subcategories? If so, check out this tip to keep your performance optimal!

Instead of loading everything multiple times, load all the data only once and always reference it using GroupBy. This way, you’ll avoid using DISTINCT and improve your app’s efficiency.

Just remember that GroupBy is not delegable, so make sure to use it wisely.

If you want to see the overview above all #PowerPlatformTip – click here