11,684 questions
I have attached the script below. You need to use a script editor to your list new/edit form to insert the script. Do not forget the replace the list/column names with yours.
19132-lookuocolumn.txt
How to bind lookup colum based on condition in SP Online
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 12%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Raj Shekar
21
Reputation points
Hi friends,
I have list List1 with columns CoL1 (Single Line text) and Col2( Person or Group) .
My requirement as below:
When create a new item from other list List2 and with columns Col1( Lookup column) that need to populate only with the items from Col1 of List1 and Col2 of List1 is equal to Current user .
Could you please help to full fill the requirement
Regards
Raj
Microsoft 365 and Office SharePoint For business Windows
{count} votes
-
Jerry Xu-MSFT 7,961 Reputation points2020-08-17T06:44:53.937+00:00 The solution will varies depends whether you are using classic or modern experience. In classic experience, you will need to write a script to edit the New and Edit form, updating the options available in the lookup column. For modern experience, per my knowledge your will have to use Power Apps to edit the look up column. Please let us know your environment and we can provide more help.
-
Raj Shekar 21 Reputation points
2020-08-19T11:30:15.563+00:00 We will use Classic Experience, could you please provide the script code . thank you
Sign in to comment
2 answers
Sort by: Most helpful
-
Jerry Xu 256 Reputation points2020-08-20T10:03:58.69+00:00 -
Raj Shekar 21 Reputation points
2020-08-20T19:35:18.753+00:00 Hi Jerry,
Thank you for sharing the script.
The scriptis not working for custom Person or Group coulmn,its only working for createby (Author column) which is default.
How to write the api with filter with custom Person or Group in Rest API URL. please provide
-
Jerry Xu 256 Reputation points
2020-08-21T01:20:18.663+00:00 Did you use the column internal name depends on your list? I test with a custom person column and it works properly in my end. If you are not clear about internal name, have a check on this. Would you like to provide screenshots of your list and how the script fail to work? It will be helpful if you can provide the script you are using and screenshot of how you set up the two lists.
-
Raj Shekar 21 Reputation points
2020-08-22T06:59:19.82+00:00 Thank you for the response,
Im able to bind, but its binding the title column only from List1, but need to bind the Col1( Lookup column) from List1
for (var i = 0; i < items.length; i++) {
console.log(items[i].Title);Its getting only title , how to change from title to lookup column.
Please help, thanks
-
Jerry Xu-MSFT 7,961 Reputation points
2020-08-26T07:16:44.057+00:00 For the part
Replace title with the internal name of the column you need. Here i use a new column whose internal name is mkmx
-
Jerry Xu-MSFT 7,961 Reputation points
2020-08-31T07:55:56.957+00:00 Hi, have you tried the script? Does it work for you?
Sign in to comment -