Hi there, silly question here, but I am tired of reading post and posts without any luck.
I have a sharepoint list with two columns Name and Region.
In my app I have a dropdown menu that shows all of the names, so far so good, but I want a label that show the region once the name has been selected.
I have been trying lookup but nothing works.
thanks in advance
Solved! Go to Solution.
A Dropdown or Combobox control contains all of the columns in a record of the dataset that is it's Items property although it only displays one of them in the window of the control. However, all of the other columns in the list can be accessed by other controls that reference the Dropdown or Combobox control. The formula that you are looking for in your label is
Where YourListName is the name of the Items property of your Combobox control. If you had more columns in your list, you could reference any of them and prepopulate a gallery with labels referring to each of the columns.
Thank you very much for your prompt reply, so my data is like this:
The Share point list = SRList
Name = Title
Region = Region
My combobox for the name is = CboAssessor
and the label for my region = LblRegion
So the formula should be:
Looks right to me. If the region is a choice or lookup type column you will need to add a .Value to the formula.
Does it work?
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications