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
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
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.
User | Count |
---|---|
257 | |
110 | |
95 | |
57 | |
40 |