The Stack Overflow podcast is back! Listen to an interview with our new CEO.

New answers tagged

0

Unfortunately this still an open issue in SP API: https://github.com/SharePoint/sp-dev-docs/issues/4478. But there is an workaround, using RenderListDataAsStream. This way the call is going to return all the data, including the lookup values. Javascript example (Thanks to Gautam Sheth answer): Field1 and Field2 are single line of text column and Field3 is ...


0

Per my knowledge, that will be hard to accomplish your goal. We cannot directly get the parent list value and send to the new item form window.


2

You can open the form page (ASPX-file) in the SharePoint Designer and add as many web part zones as you need. Also, I'd recommend you truing Plumsail Forms Designer for creating a form with related items without coding. The software itself is not free but saves a lot of time so finally it will cost less than if you'd implement the same by yourself.


1

Can it be the case that someone has reduced the lookup threshold value for the farm to 8 (From larger number before?) If some inexperienced admin would run health test that might have been flagged up; he corrected it not knowing it will affect some of your sites? Re: "a different farm administrator to me could still edit items, while I could not (despite us ...


1

This can help you. Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue $mySiteUrl = "https://some_portal/sites/yoursite" $myList = "Some Library" #lookup list name $myListLU = "Lookup List" $spSite = Get-SPSite -Identity $mySiteUrl $web = $spSite.OpenWeb() # Retrieve the lists $list = $web.GetList($myList) $listLU = $web.GetList($myListLU) ...


0

You can only get the IMMEDIATE lookup values in rest api. The workaround would be to extend your 2nd lookup in list1 and get all the values you want (which will be added to list1 as text fields). You can get these values using Rest on lookup of list2


1

You can use your RESTful URL something like below: /_api/web/lists/GetByTitle('<Display name of #List2>')/items?$select=Title,Country/ID,Country/Title&$expand=Country Where, Country: Lookup column in #List2 which is referencing data in #List1. Country/ID and Country/Title: Gives the ID and Title for selected Item from #List1. Note: If you are ...


0

You can achieve this using select and expand. Here is the sample REST URL. _api/web/lists/GetByTitle('ListName')/items$select=ColumnNamein#list2/ColumnNamein#list1&$expand=ColumnNamein#list2


0

following snippet should help you a lot. It expands data from List2 with the information from lookUp in List1 this.web.lists.getByTitle('LIST2NAME').items.select(['Column','Column/Id']).expand('Column').get().then(result => { return result });


1

I don’t think there is any OOB solution to sort lookup column in modern list view. You need to consider custom solutions with SPFx extension. Reference: Migrating from JSLink to SharePoint Framework Extensions.


1

I changed the List View Lookup Threshold to 12. The list now works again for everyone. I'm puzzled why it didn't work before, I've read some conflicting info on this - some things I've read explain that any value over 12 consumes more 'system resource' (SQL has to perform a join query - more info here). My item content type only had 9 lookup/person or ...


-1

In SP 2010 & 2013 it's not possible to sort by multi-value lookup columns, I don't know about Sharepoint Online. But presumably it's not possible. Other Notes In your lookup column, if you go to Edit Column there is a section titled Add a column to show each of these additional fields: - you can select additional columns to bring to your destination ...


Top 50 recent answers are included