Tag Info

New answers tagged

0

Thank you for posting your issue and following it up with a solution. I was having the same issue (Coercion Failed...) when using a Lookup from a calendar of events to a registration table. Using your solution, I am now able to send a Reminder email. My client will be very happy! Thank you, JCrowe


0

This is limitation. The additional fields cannot be of type Currency, Person, Lookup, Calculated, Custom Columns. See here for more information: https://social.msdn.microsoft.com/Forums/en-US/0753df63-8b30-4594-a8bd-ef8ba9514103/content-type-or-lists-lookup-column-cant-show-additional-fields-which-are-choice-or-lookup-columns?forum=sharepointgeneralprevious


0

You can try sp2013filteredlookup.codeplex.com. It can uses views, so you can manage the custom order of the lookup in the view.


2

While not exactly like your accounting structure, you could name them P01, P02, etc and it will sort as you'd expect.


0

Solving this problem in the list view can be done simply and without opening SPD: Make sure the value you want to display for the lookup column is one of the additional fields for that lookup (yes, you can include the most helpful column as both the value for 'In this column' as well as tick it in the additional fields list) (Optional) Edit the display ...


2

Select the option for "Return field as" to Lookup Value, while selecting [%Current Item:Application%] For reference, have a look at screenshot below.Instead of "As String", select Lookup Values,Comma Delimited


2

Via Central Administration: Manage web applications / Select the web application, then from the drop down list 'General Settings' select 'Resource Throttling' / change the value of 'List View Lookup Threshold' Or via PowerShell: $wa = Get-SPWebApplication http://YourSharePointSite $wa.MaxQueryLookupFields = 20 $wa.Update()


0

When the calendar is the leading webpart and the task list is the child webpart, please edit the Task webpart. Expand the "Miscellaneous" area and make sure "Server-Render" is checked. This will connect both webparts as you would expect. Please note: You will lose some functionality. Instant completing a task will no longer work.


0

Try This:- public static void AddLookupField() { string lookupSchema = @"<Field Type='Lookup' DisplayName='mylookup2' Required='FALSE' EnforceUniqueValues='FALSE' List='{70d6098c-6ba0-4e9e-b101-a60b88fc226a}' ShowField='Title' ...


0

The "List" attribute of the <Field> element should specify the list from which you wish to get information. It should be the internal name of a list on the site; the internal name is in the format of a URL fragment, such as "Lists/MyList".


2

Instead of PSI I suggest you to work with the managed object model of Project Server. That is much more developer friendly. Last year I wrote a post about how can you list lookup table entries: using (var projectContext = new ProjectContext(pwaUrl)) { projectContext.Load(projectContext.LookupTables, lts => lts.Include( lt ...


1

That is the limitation with importing a spreadsheet. You could make them choice columns or lookup columns to other Sharepoint lists you'd need to create. Once created, you'd then need to update the data, datasheet view could help speed that up, or you could then try deleting all the content and pasting the Excel data into datasheet view.


0

Instead of Contains you should use <Gt> (Greater than) or Lt (Less than). Contains operator works with String type. Since you are using decimal you should always use arithmetic logic operators.


0

Hi If you are using Looking up Fields you have to use like this &$expand=Engineer/Id& Similarly for other Fields as well. you can try the same.


0

if you have multiple lookup values to add then a slight variation on @jeff Freeman's excellent post. in my case I was required to copy the same lookup values into a column that replace the old one - don't ask! foreach ($item in $list.getItems() ) { # look at what is in the old get lookup values $sourceLookupFieldValues = ...


2

You can either use SharePoint's default people picker column when you assign the tasks. Or you can make a list of all people you want to use, and then make a lookup column to choose from these people when you do the task, and make the column's type of multi selection. Is this what you were asking for? Updated Answer Since you can't do a lookup on a ...



Top 50 recent answers are included