#StackBounty: #sharepoint-online #list #lookup-column How to auto-populate specific column items from another list with related item

Bounty: 50

Salute comrades,

So, i have two different lists say, ListUn and Listdeux, the fist one “ListUn” having items Test1 & Test2 under the fist column TestPand second column ColToPopulate ( see attached pic for visuals First List Image ),that has to fetch data from the second list “Listdeux” under column ColToPopulate that has unique items related to fist list’s column TestP items correspondingly ( see attached pic for visuals Second List Image ).

What i am trying to archive is having ListUn‘s second column ColToPopulate to fetch and populate data from Listdeux Automatically and assign the items correponding the specific related item form the second list. The only column that is supposed to be filled is from the second list.

NOTE: What i have managed to do so far is setting up the column type to lookup and assigning the items manually(But what i want is this to happen automatically by looking up what as changed from the Listdeux

I hope i have at least explained the point


Get this bounty!!!

#StackBounty: #2013 #list #javascript #development #list-view Can i eliminate duplicate items which have the same (Title & Created-…

Bounty: 50

I am working on a custom list inside our SharePoint on-premises 2013. i created the custom list to store the users who access a discussion board items, by following this approach:-

1- Inside the discussion board’s flat.aspx page, i entered the following javascript which will add a new item inside the cusotm list, by passing the item title as follow:-



$(function(){

   var itemtitle = document.title; 
   var withoutflatstring = itemtitle.substring(0, itemtitle.length-7);
   var itemType = GetItemTypeForListName("NewsAnnouncementsLogs");
        var item = {
            "__metadata": { "type": itemType },
            "Title": withoutflatstring 
        };

        $.ajax({
            url: _spPageContextInfo.siteAbsoluteUrl + "/_api/web/lists/getbytitle('" + "News and Announcements Logs" + "')/items",
            type: "POST",
            contentType: "application/json;odata=verbose",
            data: JSON.stringify(item),
            headers: {
                "Accept": "application/json;odata=verbose",
                "X-RequestDigest": $("#__REQUESTDIGEST").val()
            },
            success: function (data) {
                            //success(data);
            },
            error: function (data) {

            }
        });
});
// Get List Item Type metadata
    function GetItemTypeForListName(name) {
        return "SP.Data." + name.charAt(0).toUpperCase() + name.split(" ").join("").slice(1) + "ListItem";
    }

2- then i am interested in knowing the number of users who accessed a specific discussion board item. so inside my list view i chose to do the follow 2 settings:-

  • group the item by title
  • show the count

As follow:-

enter image description here

3- so my list view will show the item title + the number of users who accessed the item, as follow:-

enter image description here

but the only issue i am facing with the above appraoch, is that when the same user access the same discussion board item, 2 items will be added inside the custom list, and the 2 items will have the same title & created by.

but i want the counter which is shown beside the title inside my list view, to NOT count any duplicate items. where duplicates in my case, is any item inside the cusotm list which have the same Created-by & title. so is this something i can achieve ?


Get this bounty!!!

#StackBounty: #windows-10 #icons #desktop #windows-10-v1709 #list List view on desktop no longer working in Windows 10 after Fall Creat…

Bounty: 100

Up until the Fall Creators update it used to be possible to show desktop icons in list view, which was awesome. To achieve this you could either use a little tool written in AutoIT or press Ctrl+Shift+5 on the desktop.

My question is whether there is ANY way to achieve this again since the update. Reghack, patching explorer.exe, anything is worth trying. The AutoIT tool sort of works but is semi-broken, making the icons invisible and requiring auto-arrange to not flip out completely.

Here’s what it used to look like (Note: not my screenshot)
Screenshot of desktop icons in list view


Get this bounty!!!

#StackBounty: #c# #multithreading #list #tfs #wiql A list containing 2 more lists works slow in looping can i use Thread to make this f…

Bounty: 50

This is my code in which a list contains 2 more lists where the WorkItem collection contains a large number of records such as 7,000 it takes 10 min. Is there any way to make it faster and in case it’s deciding the workItem type if it’s a bug, task or product backlog item. Please tell me how to make the looping faster. It’s taking 10 min to loop 7,000 records can we use threading to make it faster?

    var workItemList = new List<WorkItemViewModel>();

            for (int i = 0; i < workItemCollection.Count; i++)
            {
                var workItem = workItemCollection[i];

                if (workItem.Type.Name == "Product Backlog Item")
                {
                    var model = new WorkItemViewModel()
                    {


                        FID = (workItem.WorkItemLinks.Count > 0) ? ((workItem.WorkItemLinks[0].LinkTypeEnd.Name.ToString() != "Child") ? workItem.WorkItemLinks[0].TargetId : 0) : 0,

                        ID = workItem.Id,
                        Name = workItem.Title,
                        State = workItem.State,

                        priorty = Convert.ToInt32(workItem.Fields["Priority"].Value),
                        //   Size =(int) workItem.Fields["Size"].Value ,
                        Size = Convert.ToInt32(workItem.Fields["Effort"].Value),

                        StoryPoints = Convert.ToInt32(workItem.Fields["Story Points"].Value),
                        DoneStatus = workItem.Fields["Done Status"].Value.ToString(),
                        StoryOwner = workItem.Fields["Story Owner"].Value.ToString(),
                        Assignedto = workItem.Fields["Assigned To"].Value.ToString(),
                        StoryAuthor = workItem.Fields["Story Author"].Value.ToString(),
                        IterationPath = workItem.IterationPath
                    };

                    workItemList.Add(model);
                }
                else
                {
                    switch (workItem.Type.Name)
                    {
                        case "Task":
                            var task = new TFSTask()
                            {
                                Storyid = (workItem.WorkItemLinks.Count > 0) ? workItem.WorkItemLinks[0].TargetId : 0,
                                ID = workItem.Id,
                                name = workItem.Title,
                                //activity = workItem.Fields["MyCompany.Activity"].Value.ToString(),
                                //start = (DateTime?)workItem.Fields["MyCompany.ActivityStart"].Value,
                                //due = (DateTime?)workItem.Fields["MyCompany.ActivityFinish"].Value,
                                status = workItem.State,
                                IterationPath = workItem.IterationPath,
                                Assignedto = workItem.Fields["Assigned To"].Value.ToString(),

                                priorty = Convert.ToInt32(workItem.Fields["Priority"].Value),
                                effort = Convert.ToInt32(workItem.Fields["effort"].Value),
                                Completed = Convert.ToInt32(workItem.Fields["Completed"].Value)

                            };
                            if (task.Storyid != 0)
                            {
                                workItemList.Last().Tasks.Add(task);
                            }


                            break;
                        case "Bug":
                            var bug = new TFSIssue()
                            {
                                Storyid = (workItem.WorkItemLinks.Count > 0) ? workItem.WorkItemLinks[0].TargetId : 0,
                                ID = workItem.Id,
                                Name = workItem.Title,
                                //start = (DateTime?)workItem.Fields["MyCompany.ActivityStart"].Value,
                                //due = (DateTime?)workItem.Fields["MyCompany.ActivityFinish"].Value,
                                State = workItem.State,
                                IterationPath = workItem.IterationPath,
                                Assignedto = workItem.Fields["Assigned To"].Value.ToString(),

                                priorty = Convert.ToInt32(workItem.Fields["Priority"].Value),
                                effort = Convert.ToInt32(workItem.Fields["effort"].Value),
                                // Completed = Convert.ToInt32(workItem.Fields["Completed"].Value)
                            };
                            if (bug.Storyid != 0)
                            {
                                workItemList.Last().Issues.Add(bug);
                            }
                            break;



                        default:
                            break;
                    }
                }
            }

 public class WorkItemViewModel
    {
        public string Name { get; set; }
        public int ID { get; set; }

        public string State { get; set; }
        // public DateTime? due { get; set; }
        public int priorty { get; set; }
        public int Size { get; set; }
        //  public int effort { get; set; }
        public int StoryPoints { get; set; }
        public string DoneStatus { get; set; }
        public string StoryOwner { get; set; }
        public string Assignedto { get; set; }
        public string StoryAuthor { get; set; }
        public string IterationPath { get; set; }
        public int FID { get; set; }
        public List<TFSIssue> Issues { get; set; }
        public List<TFSTask> Tasks { get; set; }

        public WorkItemViewModel()  // Added a public constructor
        {
            Issues = new List<TFSIssue>();
            Tasks = new List<TFSTask>();

        }

    }


Get this bounty!!!

#StackBounty: #2013 #list #development #administration #auditing "Content type and list modifications" report is showing some…

Bounty: 100

I am working on a team site collection where i have enabled the publishing features inside it. and i have enabled the reporting features inside it as follow (Site Collection Administration >> Site collection audit settings):-

enter image description here

Now i did this last week. today i access the “Content type and list modifications” report, where this report as its description should indicates

This report shows all events that modified content types and lists in
this site.

now since i am the only site admin and the only user who have full control on the sites, and i did not make any changes to the lists and/or content types since last week.so i was expecting that the report will be empty.. but when i have generated the report i have noticed that there are many entries which have the following characteristics:-

All entries which i am referring to share the following values:-

Item Type = List

Event = Schema Change

then for the List i got these 4 values:-

Document Location = Access Requests
OR
Document Location = Relationships List
OR
Document Location = Variation Labels
OR
Document Location = Reports List

First Question. so i am not sure what are these 4 lists ? as i did not add these lists nor i can find them inside the site content.

Second Question. now for all the report entries the username is the system account.. which gives me an indication that these lists get modified as part of other actions within sharepoint itself.
but which makes me worried is that there is a single entry which have its UserID not equal to the system account, and have the following details:-

Item Type = List

Event = Schema Change

Document Location = Reports List

and here is the event data:-

15.0.0.4911.0.0<FieldRef Name="ContentTypeId"/><Field ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Type="Text" Name="Title" DisplayName="Report Title" Required="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Title" FromBaseType="TRUE" ColName="nvarchar1" Version="1" RowOrdinal="0"/><FieldRef Name="_ModerationComments" ColName="ntext1"/><Field ID="{bc91a437-52e7-49e1-8c4e-4698904b2b6d}" ReadOnly="TRUE" Type="Computed" Name="LinkTitleNoMenu" DisplayName="Report Title" Dir="" DisplayNameSrcField="Title" AuthoringInfo="$Resources:core,Linked_Item;" EnableLookup="TRUE" ListItemMenuAllowed="Prohibited" LinkToItemAllowed="Prohibited" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitleNoMenu" FromBaseType="TRUE"><FieldRefs><FieldRef Name="Title"/><FieldRef Name="LinkFilenameNoMenu"/></FieldRefs><DisplayPattern><IfEqual><Expr1><LookupColumn Name="FSObjType"/></Expr1><Expr2>1</Expr2><Then><Field Name="LinkFilenameNoMenu"/></Then><Else><HTML><![CDATA[<a onfocus="OnLink(this)" href="]]></HTML><URL/><HTML><![CDATA[" onclick="EditLink2(this,]]></HTML><Counter Type="View"/><HTML><![CDATA[);return false;" target="_self">]]></HTML><Column HTMLEncode="TRUE" Name="Title" Default="$Resources:core,NoTitle;"/><IfEqual><Expr1><GetVar Name="ShowAccessibleIcon"/></Expr1><Expr2>1</Expr2><Then><HTML><![CDATA[<img src="/_layouts/15/images/blank.gif?rev=23" class="ms-hidden" border="0" width="1" height="1" alt="$Resources:core,OpenMenuKeyAccessible;"/>]]></HTML></Then></IfEqual><HTML><![CDATA[</a>]]></HTML><IfNew><HTML><![CDATA[<img src="/_layouts/[%=System.Threading.Thread.CurrentThread.CurrentUICulture.LCID%]/images/new.gif" alt="]]></HTML><HTML>$Resources:core,new_gif_alttext;</HTML><HTML><![CDATA[" class="ms-newgif" />]]></HTML></IfNew></Else></IfEqual></DisplayPattern></Field><Field ID="{82642ec8-ef9b-478f-acf9-31f7d45fbc31}" ReadOnly="TRUE" Type="Computed" Name="LinkTitle" DisplayName="Report Title" DisplayNameSrcField="Title" ClassInfo="Menu" AuthoringInfo="$Resources:core,Linked_Item_With_Menu;" ListItemMenuAllowed="Required" LinkToItemAllowed="Prohibited" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitle" FromBaseType="TRUE"><FieldRefs><FieldRef Name="Title"/><FieldRef Name="LinkTitleNoMenu"/><FieldRef Name="_EditMenuTableStart2"/><FieldRef Name="_EditMenuTableEnd"/></FieldRefs><DisplayPattern><FieldSwitch><Expr><GetVar Name="FreeForm"/></Expr><Case Value="TRUE"><Field Name="LinkTitleNoMenu"/></Case><Default><HTML><![CDATA[
]]>]]></HTML><HTML><![CDATA[
]]> ]]>]]> ]]>]]></HTML></Default></FieldSwitch></DisplayPattern></Field><Field ID="{5f190d91-3dbc-4489-9878-3c092caf35b6}" Hidden="TRUE" ReadOnly="TRUE" Type="Computed" Name="LinkTitle2" DisplayName="Report Title" DisplayNameSrcField="Title" ClassInfo="Menu" AuthoringInfo="$Resources:core,Linked_Item_With_Menu; (old)" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitle2" FromBaseType="TRUE"><FieldRefs><FieldRef Name="Title"/><FieldRef Name="LinkTitleNoMenu"/><FieldRef Name="_EditMenuTableStart"/><FieldRef Name="_EditMenuTableEnd"/></FieldRefs><DisplayPattern><FieldSwitch><Expr><GetVar Name="FreeForm"/></Expr><Case Value="TRUE"><Field Name="LinkTitleNoMenu"/></Case><Default><Field Name="_EditMenuTableStart"/><SetVar Name="ShowAccessibleIcon" Value="1"/><Field Name="LinkTitleNoMenu"/><SetVar Name="ShowAccessibleIcon" Value="0"/><Field Name="_EditMenuTableEnd"/></Default></FieldSwitch></DisplayPattern></Field><FieldRef Name="File_x0020_Type" ColName="nvarchar2"/><Field ID="{8c4cfe39-587c-45b0-9754-71810a01c5e2}" Type="Text" DisplayName="$Resources:cmscore,ReportsListTitleResourceId" Required="FALSE" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="_x0024_Resources_x003a_cmscore_x" Name="_x0024_Resources_x003a_cmscore_x" ColName="nvarchar3" RowOrdinal="0" Version="1"/><Field ID="{9a0a9832-8bf1-4de4-a809-c97bd256fbe7}" Type="Text" DisplayName="$Resources:cmscore,ReportsListTitleResourceId" Required="FALSE" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="_x0024_Resources_x003a_cmscore_x0" Name="_x0024_Resources_x003a_cmscore_x0" ColName="nvarchar4" RowOrdinal="0" Version="1"/><Field ID="{33254558-5f60-43a1-8c30-f02bee20d03a}" Type="Text" DisplayName="$Resources:cmscore,SmtListType" Required="FALSE" Description="$Resources:cmscore,SmtReportsListTypeDesc" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="_x0024_Resources_x003a_cmscore_x1" Name="_x0024_Resources_x003a_cmscore_x1" ColName="nvarchar5" RowOrdinal="0" Version="1"/><Field ID="{0500c41a-0f80-4b01-9892-7c085eb461ab}" Type="Text" DisplayName="$Resources:cmscore,SmtCamlQuery" Required="TRUE" Description="$Resources:cmscore,SmtReportsQueryDesc" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="_x0024_Resources_x003a_cmscore_x2" Name="_x0024_Resources_x003a_cmscore_x2" ColName="nvarchar6" RowOrdinal="0" Version="1"/><Field ID="{61cbb965-1e04-4273-b658-eedaa662f48d}" Type="TargetTo" Name="Target_x0020_Audiences" DisplayName="Target Audiences" Required="FALSE" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="Target_x0020_Audiences" ColName="ntext2" RowOrdinal="0" Version="2"><Customization><ArrayOfProperty><Property><Name>AllowGlobalAudience</Name><Value xmlns:q1="http://www.w3.org/2001/XMLSchema" p4:type="q1:boolean" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance">true</Value></Property><Property><Name>AllowDL</Name><Value xmlns:q2="http://www.w3.org/2001/XMLSchema" p4:type="q2:boolean" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance">true</Value></Property><Property><Name>AllowSPGroup</Name><Value xmlns:q3="http://www.w3.org/2001/XMLSchema" p4:type="q3:boolean" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance">true</Value></Property></ArrayOfProperty></Customization></Field><Field ID="{9da97a8a-1da5-4a77-98d3-4bc10456e700}" Type="Text" Name="Report_x0020_Description" DisplayName="Report Description" Required="FALSE" SourceID="{128d73ab-33f7-4d9f-84e0-a8ad33898c57}" StaticName="Report_x0020_Description" ColName="nvarchar7" RowOrdinal="0" Version="1"/>

now this user who performed this event have Read permission on the site.. so not sure how he can modify the schema for the Reports list !!

so can anyone advice on my above 2 questions? and am i having problems?


Get this bounty!!!

#StackBounty: #list #authentication #sharepoint-rest-api Sharepoint 2010 get REST API. Fetch Data behind authentication using Javascript

Bounty: 50

I have the SharePoint list url to fetch the data(XML /JSON). To access that url I have username and password.

In IOS native development using nsurl to pass username and password. Able to connect and get the data.

If am use the same in JavaScript HTTP GET or POST. How do authenticate? to get list data

Any one can help me.


Get this bounty!!!

#StackBounty: #list #development #administration #alert #configuration Invitation email when creating an alert on an item will sometime…

Bounty: 50

I was facing an issue reported by our customer. here are the current settings:-

  1. we have team site inside sharepoint on-premises enterprise 2013.
  2. when users creates alters on list items, and they specify other users inside the alert “Send Alerts to” section as follow:-

enter image description here

  1. the users defined inside the “Send Alerts to” will receive and invitation email.
  2. But the PROBLEM is that sometimes this invitation email subject will contain the List Name + Item Title. while on other lists the invitation email will only contain the item title.
    so the subject of the alert invitation email can be:-
An alert for 'ListTitle: ItemTitle' has been created

OR

An alert for 'ItemTitle' has been created

where in the first email subject it will contain the list title followed by the item title. while in the second email subject it will contain the item title only.

now i keep searching for this issue for around 2 days but could not indicate the reason. until today i have capture the first hint. now all our sub-sites facing this problem are created using a site template. where this site template contain 5 lists. now if users set an alert on an item inside the 5 lists which were added as part of the site template then the alert invitation email will contain both the ListTitle+ItemTitle. while if we create a new list specifically under a subsite (in other word the list is not part of the site template), then when users set an alert for an item inside this new list, then the invitation email subject will only include the item title…so can anyone adivce what is causing this confusion ??


Get this bounty!!!

#StackBounty: #list #authentication #sharepoint-rest-api Sharepoint 2010 get REST API. Fetch Data behind authedication Using Javascript

Bounty: 50

I have the SharePoint list url to fetch the data(XML /JSON). To access that url I have username and password.

In IOS native development using nsurl to pass username and password. Able to connect and get the data.

If am use the same in JavaScript HTTP GET or POST. How do authendicate?

How to get data NTLM any one help me, not clear how to approach ( NTLM / Post xml to get token) came across lot of posts not clear.

Any one can help me.


Get this bounty!!!

#StackBounty: #list #workflow #calculated-column Updating a field in a list with a number from a different list

Bounty: 50

I’m working on SharePoint 2010. I have two lists, Devices and Knownissues. In Devices I have the ID column with an item generated number which I want to update in a column in Knownissues called DevicesID.

I already have a Lookup field in Knownissues. I tried updating the field using Nintex Workflow but have been banging my head against a brick wall (the best result I can get is returning ‘1’ and not the actual number in the ID column). Surely there’s a straight forward way of doing this? I was thinking a calculated field, but I am happy to hear suggestions.


Get this bounty!!!