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.
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.
Community Support Team _ Phoebe Liu
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021