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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications