Hi,
I want to show defualt value of combo box which is depended on another first combo box field that is too coming from another list.
If I changed the value of first field then its defualt value is sets but when i opened already save form then its not coming.
I am using- On First field (combobox-
OnSelect- ClearCollect(valSelected,{Value:DataCardValue2.Selected.'FullName',CityRequired:DataCardValue2.Selected.City,Id:DataCardValue2.Selected.ID});
DataCardValue2 is my first combo box field
CityRequired : I want this to be set(Which is sets successfully when i changed the combobox)
On my second field- Items: ValSelected
DefualtSelectedItems: valSelected.CityRequired
Solved! Go to Solution.
Thanks @WarrenBelz for your reply.
As required:
for city combobox:-
Please let me know if any other information required.
Thank you very much.
I assume in all of this that the field is actually updating in the list after submission (as @RandyHayes asked) - if not, the below is not relevant.
You have also not answered @RandyHayes 's question on whether that are single or multi-select - I will assume single for this exercise.
Firstly, your Items should be
Filter(
'SPList',
StartsWith(
'Name',
DataCardValue2.Selected.Value
)
)
although that only solves invalid searches.
To display the item from the list in your control - two things need to be present
As it is the Value you want displayed and you are reading from a Table in the source. Your original post alluded to the name of cityrequired - you have now stated it is city, so the DefaultSelectedItems should be actually be
{Value:ThisItem.city.Value}
As a footnote on this you honestly do not need Lookup columns unless you are planning giving users bulk data sheet editing in SharePoint and they cause you more unwanted grief than any other type of field (other than maybe Person) that I know of. This video from Shane Young @Shanescows is worth watching - I stopped using them a long time ago.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |