Marcel Lehmann

learn and find tipps & tricks around the powerplatform

PowerPlatformTip 32 – ‘GroupBy’

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

Published by

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: