Announcements
I am trying to auto select drop down value based on who is logged in. I have set the DefaultSelectedItems property of the drop down to [EmployeeID] which is a label from the previous screen which holds the Employee ID. The ID gets selected automatically in the drop down but when I submit the form, the ID doesnt update in the sharepoint list. See the pictures attached below. Please help me
Hi Sufiyan,
Slight confusion here are you using Dropdown or combobox.
if you are using Dropdown then Default value has to be set to 'Default' Property and while saving the dropdown value to sharepoint list use "Dropdown1.SelectedText.Value"
If you are using Combobox then Default value has to be set to 'DefaultSelectedItems' Property and while saving combobox value to sharepoint list use "Concat(ComboBox1.SelectedItems, Value1 & ",")" (gets all selected items of combobox)
Hope that solves your issue.
Please mark answer as verified if it helped you.
Regards,
Pavan Kumar Garlapati
@PavanKumarHey Thanks for your reply, Im using a combo box, I didnt understand what you meant though. Can you please explain in a bit more detail.
Hi,
this formulae will help you to get all selected items of the combobox then you can use that in Patch to create/update in sharepoint list.
Mark the answer as verified if it helps.
Dear Pavan,
Is this what you mean? Kindly see the pic below
@PavanKumar
Where exactly do I put this formula - "Concat(ComboBox1.SelectedItems, Value1 & ",")"
Which property? Is it in some property of the Combo box?
@sufiyan_akhtar wrote:Dear Pavan,Is this what you mean? Kindly see the pic below
How are you saving data into sharepoint? Lets say you are using Patch formulae, that's the place where you put this formula to get the selected items of the combo box so that they will be saved in sharepoint.
@PavanKumar Right now the DefaultSelectedItems Property of my Combo Box is set to [EmployeeID]
And I am confused where exactly you want me to put this formula? -"Concat(ComboBox1.SelectedItems, Value1 & ",")"
@PavanKumarWell Im a newbie so dont really know patch functions and all. I created this form through the sharepoint list directly. Any further elaboration you could provide please?
HI Sufiyan,
No problem let me elaborate. There are couple of ways you can save data back to sharepoint. Before me answering your question would like to know how are you saving back the data into sharepoint.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
