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
Which one is more efficient? Do you have a better way?
Go to Solution.
The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and to discard those that don't.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.
For both, the formula is evaluated for each record of the table.
So I think there is little difference between the speed of the two function.
Take a look at the article about Filter and LookUp functions in PowerApps:
View solution in original post
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020