LookUp Function in PowerApps Syntax and Example
1. LookUp function is mainly used to return one related record from the database/datasource.
For example if you have id in PowerApps than based on that Id you can fetch other column value.
Syntax.
LookUp(datasource, condition, column_name)
Here -
Datasource - its a first parameter that we have to use, its a datasource name.
condition - Its second parameter that we have to use, your value with column value, it returns true value.
column_name - Its third parameter that we have to use,pass the column name from you want to get particular value.
Example:
In Above table you can see there are two columns available, Now i want to fetch the Age value based on the value
then my function will be -
Set(var_age,LookUp(datasource,Name="Onkar",Age))
By using Set(var, value) function you can store the result into the variable.
In this way you can use the LookUp function.
