cancel
Showing results for
Did you mean:
Highlighted
Level 10

## LookUp speed

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

1 ACCEPTED SOLUTION

Accepted Solutions
Level 10

## Re: LookUp speed

Hi Brian,

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:

https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

Best Regards，

Lisa Chen

Level 10

## Re: LookUp speed

Hi Brian,

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:

https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

Best Regards，

Lisa Chen

Announcements

Check it out!

#### Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Power Platform World Tour

Find out where you can attend!

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,191)