New answers tagged

0

When you are trying to read the lookup column value in the workflow, have you tried this other option. This returns the look value text only and not the Ids. This one has served me well as i have been using this option for some time now. Do try this and let me know if it helps.


0

All lookup column choices are sorted alphabetically by default. Apparently you will need to use jQuery for that. I've found an article which is very similar to what I followed a while back: http://sympmarc.com/2012/05/11/using-spfilterdropdown-to-reorder-options-in-a-dropdown-on-a-sharepoint-form/ $().SPServices.SPFilterDropdown({ relationshipWebURL: "/", ...


2

Try rewriting the query using the equals operator. Also note the Query tag is not required if you're not using the client object model: <Where> <Or> <Eq> <FieldRef LookupId='TRUE' Name='BusinessUnit' /> <Value Type='Integer'>62</Value> </Eq> <Eq> ...


0

Try this: string query = "<Where><Eq><FieldRef Name=\"MultiLookupFieldName\" /><Value Type=\"LookupMulti\">" + DisplayValue + "</Value></Eq></Where>"; SPQuery spQuery = new SPQuery(); spQuery.Query = query; SPListItemCollection items = list.GetItems(sp Query);


0

It's not possible by default. But a small Javascript will do the trick... addDefaultValues = function() { $("select[title$='Required Field']").each(function(){ $(this).prepend('<option value="">(none)</option>'); }); }


1

It turns out that the "Created By" field in SharePoint is a lookup column and can display/show a number of different values about the account. If you open the column to edit it, there is a property named "Show Field". In our case, someone had changed this to "Created", which refers to the date the account was created in the user information list. That is why ...


1

I used JSLink in the listview to retrieve this field, which comes back in the context object as an array. I then use the length property to render the count to the field I want. Note that this is only good for view purposes as JS link does not actually update the value of the field itself, unless you explicitly write code to do so. Steps are: Create a js ...


0

I was able to assign a task by following the steps as mentioned in the below image. Set the variable in step-1 to the email address you got from the web service.


0

Sure you can, SharePoint Provide the next method using C# SPWeb.SiteUsers.GetByEmail("jhon@contoso.com") This will return you a SPUser object, so your code should be like SPUser oUser = SPWeb.SiteUsers.GetByEmail("jhon@contoso.com"); :) I Hope it helps you


0

If you are looking to use a lookup column and want to filter the results I would suggest using SPServices. Specifically you would be using $().SPServices.SPFilterDropdown. Description from codeplex: The SPFilterDropdown function allows you to filter the values available in a Lookup column using CAML against the Lookup column's source list. This ...


0

If you are referring to a lookup field (association) on an External Content Type (ECT) then the method I use is... Right Click on the field and go to External Item picker properties Select the 'General' tab In the 'Display Field Name:' field put the name of the target column from the database (in my case sql).


0

Here are the step-by-step instructions on how to do just that. Let me know if you have any questions or need help. Get InfoPath to display lookup column value, not ID



Top 50 recent answers are included