I have a dropdown control which pulls data from a SharePoint list. I would like the dropdown box to display the city name (City.Name) and pass the value of that city name (City.ID) onto a gallery, which will be filtered based on the City.ID, not the City.Name.
In the "Advnaced" tap for the dropdown, I've tried to set the Items to City.Name and the Value to City.ID, but when I set the Item to the Name, it forces the Value to Name as well, and won't let me manually set the Value. I've tried several other solutions I've found on the forums and don't seem to grasp what I am doing wrong. Can someone please point me in the right direction?
This is my configuration:
Items: Portfolio.Store (ex: New York, NY)
Default Value: MyDept (which is global variable. ex: "1000")
My problem is when I go to change the "Value" for the dropdown it only shows "Store" as an option. I'm allowed to change it.
Right, so this gets me back to where I was.
Items = Portfolio
Selected = ID
However, I would like the Display value of DropDown to equal a friendly name vs the ID.
City Table (SharePoint):
City Name: ID:
New York 1000
MyDept (Global Varible, O365 Dept Value)
I'd like this behavior:
Item Display = CityTable.City Name
Item Value = CItyTable.ID
Selected = MyDept
Essentially, I want the MyDept value to do a lookup into the City Table and display the City Name, not the City ID.
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT