Please HELP: Auto select value in a drop down baswed on a value in a label

[sufiyan_akhtar]

Hey PowerUsers,

I am currently having a label which holds an ID. I also have a drop down called A which is linked to a lookup field in a Sharepoint list which holds values for the IDs. All I want to do is auto select the ID value in the drop down based on the ID value in the label. So if the label value is 003, I want 003 to be automatically selected in the drop down. Values in the label are always there in the drop down.

Thanks guys

[v-yutliu-msft]

Hi @sufiyan_akhtar ,

Do you want to filter items based on a look up column?

If so, try this formula:  (set the drop down's Default)

LookUp(listname, lookup column name.Value=Label1.Text)

Please replace the listname, lookup columname with your actual information.

Best regards,

Community Support Team _ Phoebe Liu

[sufiyan_akhtar]

hI @v-yutliu-msft  It still doesnt show the value 😞 Im attaching a screen shot below. EmployeeID is a variable Im passing from the previous screen.

[yashag2255]

Hi @sufiyan_akhtar 

Can you try to update your formula as:
Lookup(LMS_Table,Employee_ID.value = Value(EmployeeID))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[TopShelf-MSFT]

Hi @sufiyan_akhtar how are you progressing with this? Was the above reply helpful?

@TopShelf-MSFT