In this blog post , we will discuss the PowerApps lookup function, what is the lookup function, how to use?, and give some examples about the lookup function in PowerApps, such as the LookUp function with single condition, the LookUp function with multiple condition , the LookUp function with lookup column, and so on.
In Power Apps, the Lookup function is a powerful tool for finding and returning the first record that matches certain criteria! But the way you use it can make a huge difference.
Let’s clarify it:
Lookup(Source, Filter, COLUMN): This syntax directly returns the desired COLUMN’s value from the first record that matches the filter criteria. It’s straightforward and efficient.
Lookup(Source, Filter).COLUMN: This syntax first retrieves the entire record that matches the filter criteria and then extracts the COLUMN’s value. It takes an extra step, thus slightly affecting the performance.
For example:
Lookup(MyCollection, Age > 30, Name): This directly gives you the “Name” of the first person older than 30.
Lookup(MyCollection, Age > 30).Name: This first finds the record of the first person older than 30, then extracts the “Name”.