Power Platform Community Forum Thread Details

Content migrated from TechNet. Post attribution to:Brian Dang

In Excel, Index(,Match()) is more efficient than a vlookup or hlookup. In practice, I don't see the difference, but that's what experts say.

I am wondering if there is a difference in LookUp speeds in PowerApps/Project Siena.

I have two ways I generally check if a returned value is equal to a target:

LookUp(source, ID=item1, return)=target

First(Filter(source, ID=item1))!return=target

Which one is more efficient? Do you have a better way?

Brian

Categories:

LookUp speed