Announcements
I am new to sharepoint, and can't find a solution to this problem. I want the user to save info using a dropdown menu which is a lookup from a sharepoint list which needs to be saved on another list. But I can't seem to find the appropriate code to save the dropdown list. Most solutions point towards using '.Selected.Value' to save the dropdown but this doesn't seem to work for me.
Hi @Anonymous ,
Please move your mouse to red underline to see details of error.
"Selected.Value" returns text. We need to make sure the type of column in patch formula expects a text value.
Could you please tell me the type of column in your formula and Items of drop down?
Best regards,
Rimmon
The type of column is the single line type, I hope that is what you're referring to.
I have attached screenshots for the items and error underline.
I'm afraid that workstation is not text type. I think it maybe Choice or lookup column because the error shows workstation expects a record.
Please come back to listZones and check the type of workstation column. Try the below formula if it is lookup column:
Items of drop down:
Choices([@listZones].Workstation)
Patch function:
Patch(listZones,Defaults(listZones),{ZoneName:zonInput.Text,Workstation:dropWork.Selected})
That seems to have done it. It was indeed a lookup column, I guess that's what you meant by column type.
Thanks a bunch Rimmon 😊.
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.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
