Tag Info

New answers tagged

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 = ...


0

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?


0

I figured it out... I just needed to use the "Task outcome" from the previous task. Then the value had a drop down menu which allowed me to select "Extension Approved".


0

I am not sure what errors you see after deploying this codeplex solution developed by me. Anyways, answering your question; custom fields derived from SPLookup Field are not editable in datasheet view.


0

You can only make this whith a list definition, unfortunately you can not make it with the UI. You have to Add your orderby in the View having BaseViewId 0. That worked for me


0

Lookup column data is stored in format ID:#stringvalue. Hence if you do an equal comparison, it will fail. The best option is to use contains


1

You can add additional lookup field or select lookup field as ID in field settings: To Select Lookup Field as ID instead of Title: To Select ID as well as Title


0

Here is an example from this question:Updating Lookup Values with the REST API var call = jQuery.ajax({ url: _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getByTitle('Sales Opportunities')/Items(5)", type: "POST", data: JSON.stringify({ "__metadata": { type: "SP.Data.Sales_x0020_OpportunitiesListItem" ...


0

I ended up finding what i needed with SPServices. I used the filter drop down function, Code below. http://spservices.codeplex.com/wikipage?title=%24%28%29.SPServices.SPFilterDropdown $().SPServices.SPFilterDropdown({ relationshipList: "{*List ID*}", relationshipListColumn: "*column Name*", columnName: "*Column Nam*e", ...


0

Instead of CurrentItem:ID you should need the Task Item ID. For that you need to get the ID of the Workflow Task once its created. You can store that ID in a workflow variable and use that to get the correct Task Item. How do you access task form field data from approval workflows?


1

The next option with you is to create a Workflow using SharePoint Designer. Run the workflow on item create and item update. Change the field FinalDate to a DateTime Create a new workflow and attach it to the List in question In the workflow using DateFunction you can add the value into a variable Use Update Current Item activity and update field ...


0

Instead of PostID you should be updating PostTitle For adding comment you can use below snippet protected void addComment(SPWeb TargetWeb, SPListItem CommentItem, int postID) { SPListItem newCommentItem = Targetweb.Lists["Comments"].Items.Add(); newCommentItem["Created"] = CommentItem["Created"]; newCommentItem["Modified"] = ...


0

You can try using list relationships. Create a new look-up column in List A that references List B, if it returns data you have your match. If all you need to do is report on the data you can also just use Excel. Use PowerPivot and import the two lists as data sources, and do essentially the same thing. With PowerPivot however you have a lot of ...


2

You need to use the substring options available in XSLT to get what you want substring-before and substring-after. Like this: <xsl:value-of select="substring-before("&le;/a&gt;", substring-after("*&quot;&gt;", @Betrieb))"/> Not fully tested, the encodings might be off for the greater than, less than, and double quote characters. ...


2

To setup the additional field from the lookup, you need to add a second lookup field pointing at the same list, but include the FieldRef attribute on the second lookup field. The value of this attribute should be the same as the ID attribute of the first lookup field. <Field ID="{5D184D01-082C-4831-8757-CA2C98F05221}" Name="Title" DisplayName="Title" ...



Top 50 recent answers are included