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.

SQL Server
SharePoint

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

Now, in SharePoint, I have two lists.

Interview

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

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!!

2 Comments

Join the conversation! Your thoughts help the community grow.

Rahul Singh Solanki4y ago
Didn't work for me!
Rakesh Pinao5y ago
Thanks Dhruvin - This was really helpful. I've used the Step 2 code snippet successfully to set the lookup field on a new form (My lookup field is a multi-select, but here I am just setting one id & value pair). However, when the form is submitted the value is not saved. If I manually make changes to field it does save, so the field works otherwise. Can I check you are only setting the "Default" property of the field?