lookup

Here’s how to think about and use the Lookup function in Canvas Power Apps!

Lookup is used to fetch a single record that matches a criteria from the source (usually a table)

Scenario

I have a Gallery control which is populated with Accounts data from Dataverse.

Then, I have a Textbox (Text Input) in which I’m going to pull up a field from a record from Dataverse table which matches a certain criteria.

Let’s see how we can use Lookup in a Canvas App based on the above scenario –

Start by typing Lookup and you’ll see that it’s a valid function in the list. And the first thing in the parameter after opening the bracket is the source.
As you can see, suggestions are also seen in the list below. Here, you have the select the Table / Entity from which you want to fetch the record.
Now, Accounts is the table which I’m looking into. Hence, I’ll select that and press comma (,). Next, I’ll be asked the condition.
Here, you need to mention what record you want to retrieve based on what criteria.
So, I want to retrieve an Account whose “Account Name” is equal to <value>. So, below is how I write it.
In this example, I’m trying to fetch an Account record whose ‘Account Name‘ field has value “Coffee House”
Further, once I have this condition satisfied, what field I want to retrieve so that it can be shown in the Text Input box I have inserted (for which I’m writing this Lookup)

So in this case, I want to retrieve the ‘Main Phone’ field.
And once my formula is complete, I can end it with a closing bracket.
And as you see the result below, the Main Phone from the matching criteria Account has shown up.

And that’s how Lookup() function can be used to pick a record’s value based on a certain criteria.