cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Migrated_User
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
Migrated_User
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

View solution in original post

1 REPLY 1
Migrated_User
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

View solution in original post

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

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)