Set A Default Value Of The Look Up Column In PowerApps New Form

Overview

 

Using the text value of the one data source, we need to set the Look Up value of another data source. So, at that time, there is a possibility that we don’t have an ID column associated with the Look Up. We only have the value for the “Value” column, and we need to find its ID and store the data into the SharePoint list. At this time, we can go with the approach provided in this article.

 

Scenario

 

I have two data sources.

1. SQL Server
2. SharePoint

I have a column named “Designation” in SQL Server.

 

Now, in SharePoint, I have two lists.

 

Interview

 

Designation

 

In the list “Interview”, I have “Designation” as a Look Up column of Designation list.

 

When a user clicks on the New Form, the default Look Up value for the Designation field should be set automatically.

 

So, let’s get started!

 

Step 1

 

Create a new PowerApps Form.

 

We have a Designation column there.

 

 

Step 2

 

Select the Designation Data Card.

 

Add the Default Property as shown in the below screenshot or the code snippet.

{
   '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id: LookUp(Designation_3,Title = "Software Developer",ID),
   Value: "Software Developer"
}

 

Now, let’s understand its logic first!

 

Look Up column accepts the value in the Record format.

 

Now, let’s say below are my possible values for the Look Up drop down.

 

 

We only have a value in the text format that I want to set the default value as “Software Developer” in the dropdown. Then, how does Look Up column know what my ID is?

 

In order to find out the ID for the associated Look Up value, we will use LookUp function.

 

Below is the syntax for it.

 

Source = My SharePoint’s Designation List

Condition = Designation list > column name on which we need to apply the condition.

Result = Designation List > Result column name which we want

The above function will return us an ID associated with the text value.

 

Now, we have both the values available to set as the default value.

 

Step 3

 

We set “Software Developer” as Default Value.

 

Step 4

 

Run the form and fill the information.

 

 

Step 5

 

Check the result in the SharePoint list.

 

We can have “Software Developer” as a default value.

 

 

Conclusion

 

This is how we can easily set the Default Look Up column value in the PowerApps Form.

 

Hope you love this article!

 

Don’t forget to follow me!!

 

Happy PowerApping!!