Tag Info

New answers tagged

1

Why would you go to the categories list to see foods? Your list architecture is backwards. Foods should contain a lookup to Categories, not the other way around. Suppose you add a new food, "orange". In your scenario you have a create a list item in Foods, then go into the categories list to add the new food to the category. This is messy and error-prone. ...


1

These additional columns work exactly as if they were lookups themselves, but instead of creating them separately, you can do it in same operation. So, for example, if you create 'LookupCol1' and bring additional fields from parent list 'Title' & 'Created', these will be stored in the child list as 'LookupCol1_x003a_Title' and 'LookupCol1_x003a_Created'. ...


0

It is failing because you are deploying the lookup field before the lookup list. The relevant quote from the blog you referenced states: The trick to doing this right is understanding that the order in which the package deploys the artifacts is important. Look inside your feature designer, and I bet the element that provisions the lookup field occurs ...


0

If the List Item (objItem in this example) is populated: string s = new SPFieldLookupValue(objItem["MyField"].ToString()).LookupValue;


0

You need to create a new SPFieldLookUp http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfieldlookup.aspx and cast the context item to that object. Then you will have the SPFieldLookupValue object available to work with and you can get the value of that field in multiple contexts. Something like this should work ...


1

couple of things to check. Permission of Users on that list/library create some test alerts on that list check if it is working. Email addresses are on network or off network i.e gmail Check if Timer job for email alerts working? check this guide for detailed troubleshooting steps: http://sharepointalert.info/troubleshooting-sharepoint-alerts/ ...


0

You have the workflow set to start on change, and something in that workflow changes that list item. This would create a loop which SharePoint does not allow. See if your logic allows you to use only "start on creation" instead. If not, you can work around this by bouncing workflows between two lists.


0

Fetch additional lookup columns values in REST lookupList -- List1 : col1, col2 List2: col3(lookupof col1) template: $select=LookupColName/LookupListcolName1,LookupColName/LookupListcolName2&$expand=LookupColName/LookupListcolName1,LookupColName/LookupListcolName2 Example $select=col3/col1,col3/col2&$expand=col3/col1,col3/col2


0

Test1 The List, whose column I will use a Lookup column say Test1 Test2 The List which will use the Test1's country column as lookup column is as follows: WorkFlow Now the workflow I have created is associated with Test2 Now check the condition I have put in the Workflow. I checked Current Item:Coountry2 contains India Now If I run the workflow ...


2

You need to change the type of column colour in List#1 to LookUp. When you will select the LookUp column, you can select the List#2 in source and column colour Now your column in List#1 will be connected to List#2's colour column. Please let me know if you want further explanation. Help Link


0

Or You can try this: $w=get-spweb http://site/ $f=$w.fields["field_name"] $f.schemaXml = "schema xml with another list ID" $f.update()


0

Yes. There are two things you have to take care of: The user/group will need atleast read permission to the Look-up List. The number of look-up columns in your list should ideally be less than 8. If there are more than 8, then you will again end up with issues.


1

I fixed it by removing the "multiple values" check! Who knew?


2

you should use the itemupdating afterproperties for this: if(properties.AfterProperties["Service box"] == null) { //Cancel event properties.Cancel = true; properties.ErrorMessage = "value cannot be null"; } EDIT its todo with the current condition of the item. Your using the event itemUpdating what means that it still hasnt ...


0

their is no OOTB way to filter the LookUp. Their are couple of options you can try. Use SharePoint designer with a text column to get this Applying Filters to Lookup Fields with the SharePoint 2013 REST API their is codePlex solution for this


2

As Cameron pointed out, it's because of performance reason. Administrators got permission to query above the default 8 columns, standard user's do not. Microsoft states the following on their site about list performance. See the part Lookup columns and list views in the article. There's some good graphs showing what happens with the SQL performance as ...


0

If i understand properly, you need to sync the two given lists. If there are any changes done on list1 one it should be reflected to list2. I am not sure about any OOB(Out of the box) solution. But you can write a Event Receiver and in custom code you can update the changes in either of the list. So you need to write Event Receivers for both of the lists. ...


0

Check my answer on the other questions in the forum. I am sure you want the same thing: Relational List fields


0

Since you have to reference two lists, your only option that I see is to use a script to handle it (I originally thought you wanted to filter the color column, and not the Cars column. I don't know of an easy work around, besides creating a new field and using workflows to get it done). Here is a sharepoint script that could possibly get it done. I can't ...


0

I used jQuery to remove the links by selecting all anchor tags pointing to the look up list (check the href for each of the look up values and they should all start pointing to some list and have an "ID=" at the end). I then unwrapped it from the tags to just return the text. Here is the code line for my list, but you will of course need to change it to the ...


1

Lookups cannot consume all types of columns, so you need to build a column that the lookup can use. You could add a text column to your initial list and let a workflow copy the text of the ContentType field into that new column when the item is created. Then you can use a lookup to that text column.



Top 50 recent answers are included