Microsoft SharePoint
--
Questions
--
Followers
Top Experts
I have a custom list with a column that has a look-up field. I need to populate what is chosen there to populate another column in that same list.
So for example, I have a pull-down list called "Sandwich" and "Big-Mac" is chosen it would populate a "Sandwich Text" field.
Other info.
I'm a SharePoint consultant and the farm is a Dev so I can I have all of tools available to me, SharePoint Designer 2013, Visual Studio, etc. :)
This would need to go into a workflow or into Visual Studio solution that I will deploy.
Eventually, this will be used to create an item in another list and populate "Big-Mac" in a column on that list but didn't want to confuse things here ;p
Thanks!
-Scott
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
If this were a choice column, you could use a calculated column to pull the text into another field. But that does not work with a lookup column.
The choice column scenario is like this:
One column is called "Sandwich Text". You want to populate that column with the value chosen in another field, which is a Choice column called "Sandwich". So you make the "Sandwich Text" column a calculated column and set it to the "Sandwich" column.
Then you create a new item in the list, select a value in the "Sandwich" column and save. The "Sandwich Text" column will display just that value.
But if the "Sandwich" is a lookup field to another list in the Sharepoint site, this will not work, since lookup columns cannot be used in calculated columns.
So, as an alternative to a calculated column you may want to use a workflow to update the "Sandwich Text" column.
Give me a moment while I fire up SharePoint Designer 2013. I'll report back.
cheers, teylyn
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
I had another InfoPath issue and didn't know I could only have two open so I hurried up and closed them. If you know anything about the following https://www.experts-exchange.com/questions/28385997/InfoPath-2013-and-querying-repeating-tables.html I would be eternally grateful!!!!!
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft SharePoint
--
Questions
--
Followers
Top Experts
Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.