web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to fill a default ...

Power Apps

Unanswered

How to fill a default value in PowerApp forms for a lookup column?

(0) Share

Report

Report

Posted on by pcakhilnadh

249

I am trying to assign a default value to "UserID" field of my form .
"UserID" is a lookup column in my sharepoint list which points to "Employee" List.
I can get the required record using the formula

 Lookup(Employee,ID= currentUser.ID)

I get error when I try to assign the above formula to the default property of "UserID" data card of my form.

How can I correctly fill a default value to lookup column field of PowerApp forms

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Mitanshu 1,650 Moderator on at

Like (0)

Report
Assuming
Your Lookup function is correctly giving you the desired record
SP List column you want to retrieve is called UserID

Use in the Default Value
Lookup(Employee,ID= currentUser.ID).UserID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
pcakhilnadh 249 on at

Like (0)

Report

No this will not work. @happyume

The Default Property of the data card of myForm accepts a record .
from your formula, Lookup(Employee,ID= currentUser.ID).UserID -> number not record.

I wanted to assign a default value to a field in PowerApp form

Was this reply helpful? Yes No
Verified answer

pcakhilnadh 249 on at

Like (1)

Report

Solution

In the Datacard of the UserID. I unlocked it from advanced panel then DefaultSelectedItems Property, I set as below
{
Id: currentUser.ID
Value:Id: currentUser.ID
}

It requires both Id as well as Value in the record

Was this reply helpful? Yes No

Join the conversation