Follow by Email

Wednesday, December 4, 2019

Create PowerApps for Face Detection using Microsoft Azure Cognitive Services and Power Automate

This article explains how to handle the azure cognitive service APIs within Microsoft Flow(power automate) and use the flow from PowerApps. Microsoft Flow team has released new connectors for Azure cognitive service API which are in preview now. It includes Computer Vision and Face API, still I would go with http connector which is tested one.
Each connector has a different set of actions. We can use those actions by passing the proper input to the connections.
Requirements
  1. Face API URL & Key
  2. On-Premises Data Gateway – SQL Server
  3. Microsoft Flow – Free subscription or O365 subscription
Creating Face API\
To create a Face API, you need an Azure Subscription. If you don’t have a subscription, then you can get a free Azure subscription from here.
Visit portal.azure.com and click “Create a Resource”.
Under new, choose “Ai + Machine Learning” -> Face


Create a new face resource by providing the required details.

Once the resource is created, you need to get the key and URL (EndPoint).
Note down the endpoint and key and we will use it on Microsoft Flow.
PowerApps
Sign in to your PowerApps account and click Canvas App from Blank. Choose the Phone from Factor option and provide a name to your app and then click create


Once you created the app, Click Media under insert tool bar and then Insert the Camera on the screen to take the picture.

You will be able to see the number zero in camera property function bar. Which shows only rear camera.

So in order to use the front camera we need to create a toggle button. Insert toggle button from controls and in OnChange property paste this code UpdateContext({EnableFront:!EnableFront})


Now Click the camera and change its camera property to If(EnableFront=true,1,0) and change the camera OnSelect property to ClearCollect(capturedimage,Camera1.Photo)

We have created the camera and now we need insert the image from media tab so that we can see our captured image. Once image has been inserted change its OnSelect property to First(capturedimage).Url.
Now we need to create a flow so click action tab and click flows you will get a window which will show create a new flow. Click that. A new page will be opened and you can see the flow. Click next step and create SharePoint file to store our input image. you need to add the Site Address, Folder Path, File Name. Moreover, you need to send the actual image file from Power Apps with the name of Create_FileContent

In the next step, we need to pass it to the Compose component for the aim of store it in a variable ands also pass it to the HTTP component.

Here in the ComposeComponent, we have to convert the picture to the binary format using the function dataUriToBinary(triggerBody()[‘Createfile_FileContent’]) to do that, first click on the input then in the Expression search for the function dataUriToBinary then for the input choose the Createfile_FileContent.

In next step, we are going to pass the binary file (picture) to a component named HTTP. This component is responsible for calling any API by passing the Url, Key and the requested fields. Choose a new action, and search for the http and select it

In http component, choose the Post for the Method, Url”https://westcentralus.api.cognitive.microsoft.com/face/v1.0/detect
for headers:
Ocp-Apim-Subscription-Key: put the API key from Azure
Content-Type: application/octet-stream
then we need to provide the Queries: 
the first attribute is
returnFaceAttribute: that need to return below components from a picture:
age,gender,emotion,smile,hair,makeup,accessories,occlusion,exposure,noise

Now we need another component to be able to pass the result to Power Apps, as a result. In the new action search for the response, then for status code select 200, for Body choose the Body, and for the Response Body JSON Schema paste the below codes

Code: {
    “type”: “array”,
    “items”: {
        “type”: “object”,
        “properties”: {
            “faceId”: {
                “type”: “string”
            }
            ,
            “faceRectangle”: {
                “type”: “object”,
                “properties”: {
                    “top”: {
                        “type”: “integer”
                    }
                    ,
                    “left”: {
                        “type”: “integer”
                    }
                    ,
                    “width”: {
                        “type”: “integer”
                    }
                    ,
                    “height”: {
                        “type”: “integer”
                    }
                }
            }
            ,
            “faceAttributes”: {
                “type”: “object”,
                “properties”: {
                    “smile”: {
                        “type”: “number”
                    }
                    ,
                    “gender”: {
                        “type”: “string”
                    }
                    ,
                    “age”: {
                        “type”: “integer”
                    }
                    ,
                    “emotion”: {
                        “type”: “object”,
                        “properties”: {
                            “anger”: {
                                “type”: “integer”
                            }
                            ,
                            “contempt”: {
                                “type”: “number”
                            }
                            ,
                            “disgust”: {
                                “type”: “integer”
                            }
                            ,
                            “fear”: {
                                “type”: “integer”
                            }
                            ,
                            “happiness”: {
                                “type”: “number”
                            }
                            ,
                            “neutral”: {
                                “type”: “number”
                            }
                            ,
                            “sadness”: {
                                “type”: “integer”
                            }
                            ,
                            “surprise”: {
                                “type”: “number”
                            }
                        }
                    }
                    ,
                    “exposure”: {
                        “type”: “object”,
                        “properties”: {
                            “exposureLevel”: {
                                “type”: “string”
                            }
                            ,
                            “value”: {
                                “type”: “number”
                            }
                        }
                    }
                    ,
                    “noise”: {
                        “type”: “object”,
                        “properties”: {
                            “noiseLevel”: {
                                “type”: “string”
                            }
                            ,
                            “value”: {
                                “type”: “number”
                            }
                        }
                    }
                    ,
                    “makeup”: {
                        “type”: “object”,
                        “properties”: {
                            “eyeMakeup”: {
                                “type”: “boolean”
                            }
                            ,
                            “lipMakeup”: {
                                “type”: “boolean”
                            }
                        }
                    }
                    ,
                    “accessories”: {
                        “type”: “array”
                    }
                    ,
                    “occlusion”: {
                        “type”: “object”,
                        “properties”: {
                            “foreheadOccluded”: {
                                “type”: “boolean”
                            }
                            ,
                            “eyeOccluded”: {
                                “type”: “boolean”
                            }
                            ,
                            “mouthOccluded”: {
                                “type”: “boolean”
                            }
                        }
                    }
                    ,
                    “hair”: {
                        “type”: “object”,
                        “properties”: {
                            “bald”: {
                                “type”: “number”
                            }
                            ,
                            “invisible”: {
                                “type”: “boolean”
                            }
                            ,
                            “hairColor”: {
                                “type”: “array”,
                                “items”: {
                                    “type”: “object”,
                                    “properties”: {
                                        “color”: {
                                            “type”: “string”
                                        }
                                        ,
                                        “confidence”: {
                                            “type”: “number”
                                        }
                                    }
                                    ,
                                    “required”: [ “color”,
                                    “confidence”]
                                }
                            }
                        }
                    }
                }
            }
        }
        ,
        “required”: [ “faceId”,
        “faceRectangle”,
        “faceAttributes”]
Now we just need to save the Flow. The flow is created, now we need to connect it to the Power Apps. Go back to PowerApps and Add the button by clicking the        Insert-> Button and connect the created flow by clicking Action -> Flows and select the created flow and paste the below code and ClearCollect(facedata,yourflowname.Run(First(capturedimage).Url)). Enter your flow name in the mentioned place.
Next step is to create a gallery by clicking Insert -> Gallery -> Blank vertical
It adds a big on to the screen, resize it to be fit for the image cover. There are two things we need to do: first, add the data source to it. we want the gallery able to detect the faces, so we need to add the result of face recognition to the gallery. Under properties you can see items which has drop down in that select facedata and we linked the data.
Now we need to insert the rectangle for face detection. Rectangle can be inserted by Insert -> icons -> rectangle. Now, need to change the properties of it and to make it as an unfilled rectangle. click on the rectangle then change the more bored size to be bigger. you also able to change the color and so forth, However, the rectangle still is not dynamic, it always located in the top of the window, and if you run the code by clicking on the top of the page still you not able to see the rectangle. To set a rectangle around the face of the people in the image we need to align it by setting the parameters
first the OnSelect:  as you can see in the picture for Onselect attribute the formula is Select(Parent)
the next parameter  need to set is about the location of the rectangle
click on the Height Parameter then write the below codes
ThisItem.faceRectangle.height*(Image1.Height/Image1.OriginalHeight)
do the same for width
ThisItem.faceRectangle.width*(Image1.Width/Image1.OriginalWidth)
or you can put for X
ThisItem.faceRectangle.left*(Image1.Width/Image1.OriginalWidth)
and for the Y value
ThisItem.faceRectangle.top*(Image1.Height/Image1.OriginalHeight)
To create a interactive app change the image Height, Width, X, Y to Camera1.Height, Camera1.Width, Camera1.X, Camera1.Y respectively and mode the Image1 to top.
Now we are going to put some label into the page to show the age, gender, expression and so forth.
to show this information insert a new lable to the page.
“Age:”& Gallery1.Selected.faceAttributes.age
then now add other attributes like gender, Happiness, Neutral and so forth.
like happiness
“Happiness:”& Gallery1.Selected.faceAttributes.emotion.happiness
“Gender:”& Gallery1.Selected.faceAttributes.gender
To show the hair color we can create a data table by clicking on Insert-> Data Table in the item attribute of Data Table, write the below code
Gallery1.Selected.faceAttributes.hair.hairColor
To delete the photo Insert -> icons -> Trash and change the OnSelect to UpdateContext({conShowPhoto:false})
Now click the preview button and take photo and check the app and delete the photo and play again.

Tuesday, September 24, 2019

Email Enabled lists in Office 365 & SharePoint Online

For many years, users of SharePoint have enjoyed a handy feature known as “Incoming Email”.  This feature allows for assigning email addresses to SharePoint lists.  Emails sent to the assigned email address will process to the list associated to that email address.  However, as organizations begin to migrate to Office 365 they are left with the dilemma of whether to seek alternatives or abandon this functionality all together.  Why you ask?  This is because the incoming email feature is no longer available in SharePoint Online out of the box.


Why is the feature not available in SharePoint Online?

To answer this question, one must first learn how the on-premises “Incoming Email” feature works.  Figure 1-1 below shows the typical flow of an incoming email into SharePoint

  1. The User sends the email to an address like testlist@sp.demo.com
  2. The mail server forwards that email on to an SMTP server that is set up for the SharePoint Farm.
  3. Once this SMTP server receives the email, it places it in a drop folder.
  4. The incoming email timer job runs on a schedule to read in email messages in this folder and process them to the list that matches the email address the message was sent to.
Figure 1-2 below shows one of the reasons why this feature does not work in SharePoint Online


  1. SharePoint Online restricts users to Site collection or below. No more farm level access exists for your SharePoint site.  This means the farm level timer jobs and configuration settings that used to take care of this processing no longer exist.
  2. Since these settings do not exist on the back-end, they have also been removed from the front-end list settings as well.

What are my Options?

Now that we covered reasons why this feature is not available out of the box, we need to address what can be done about it.  In this void of having a solution to for this feature, many players have showed up on the scene.  Below I have listed some of the options, and the advantages and disadvantages to each.

Option 1: Site Mailboxes (This is no more an option as SPO deprecated Site Mailbox feature as of July 2017)

This option allows for setting up an Exchange mailbox used to collaborate between team members.  Emails can be sent to the mailbox to be shared among team members.
Advantages
  • Allows end users to create these mailboxes from the SharePoint online ‘Add an app’ page.
  • Permissions set on the SharePoint site are also applied to the mailbox.
Disadvantages
  • Only one mailbox can be created per site.
  • Mail and documents do not live in SharePoint. Data is accessed through Outlook Web Access.
  • Site Mailbox is chosen for you based on the SharePoint site name.
  • Cannot set up event receivers or workflows on the data.
  • Documents and emails are opened in outlook web access, and not SharePoint.

 Option 2: Office 365 Groups

Uses the Office 365 group functionality to set up a shared work space for collaboration.
Advantages
  • A collaboration space is created to share documents, calendars, conversations.
  • Feature is integrated with your OneDrive for Business site.
Disadvantages
  • Every group creates a new hidden site collection.
  • No workflow options.

Option 3: Azure Logic Apps

Azure Logic Apps can be used to set up connectors between an Office 365 mailbox and a SharePoint list.
Advantages
  • Processes email within a mailbox to the associated SharePoint list.
Disadvantages
  • Must have an Azure subscription.
  • Must pay licensing fee for Logic Apps.
  • Requires setting up a new user and mailbox for each list (requires user to be licensed for Exchange Online and SharePoint Online).

Option 4: Microsoft Flow

Microsoft Flow is a feature offered in Office 365 to allow processing email messages in Office 365 to SharePoint libraries.
Advantages
  • Can process email attachments from an Office 365 mailbox into SharePoint.
  • Can configure to use one mailbox to process to many different lists.
Disadvantages
  • Requires setting up a user to go with a mailbox in Office 365 (requires user to be licensed for Exchange Online and SharePoint Online).
  • Only has template for email attachment. No current offering to save the email itself.
  • Additional cost per user for Microsoft Flow Licensing.

Option 5: 3rd Party Paid Apps

There are many 3rd party paid apps out there that offer similar or replace this out of the box functionality.
Advantages
  • Usually moderately priced.
  • Offers functionality similar in nature to the out of the box solution.
Disadvantages
  • Some of the major players charge based on the number of emails processed.
  • Most also require a mailbox per list to be processed (would require licensing each mailbox)

Option 6: Custom Code

By writing custom code to replace this functionality, you are provided with a customized solution for processing these emails.
Advantages
  • Custom solution.
  • Can use existing infrastructure.
  • Ability to configure the polling schedule.
  • No need for extra licensing.
  • Users allowed to configure the list settings.
Disadvantages
  • Requires an existing SMTP server and a asp.net server for the process to function.

Tuesday, January 15, 2019

SharePoint Server: "The search service is not able to connect to the machine that hosts the administration component"

Issue

The search service is not able to connect to the machine that hosts the administration component. Verify that the administration component ‘GUID’ in search application ‘Search Service Application’ is in a good state and try again
In Farm Search Administration page when you click on “Modify Topology” you get error “An unhandled exception occurred in the user interface.Exception Information: Exception has been thrown by the target of an”

Cause

Search is not able to connect is because of many reasons, In this article I am providing all possible causes and the solutions.

Solutions

Solution 1


In the end it turns out to be that the application pool that hosts the search service application somehow doesn’t have the correct access.

You can simply change the application pool to use SharePoint Web Services System for search service applications and check.
1. Click on Start > Run > Type Inetmgr > Click OK0094 





  1. In IIS > Expand server > Expand sites > Expand “SharePoint Web Services”
    0096
  2. Now check all the GUID 1 by 1 in content view unless you find searchadmin.svc and searchservice.svc
    0095 
  3. Right click GUID go to advance settings
    0097 
  4. Change the application to “SharePoint Web Services” > Click OK
    0098 

Solution 2

Enable the timer job and do IIS reset:
1. Run below PS command to know the status of timer job
Get-SPTimerJob job-application-server-admin-service
Result ==> Is Disabled: True
  1. Run below PS command to enable the service.
    Enable-SPTimerJob job-application-server-admin-service
    Result ==> IsDisabled: False
  2. Do Net Stop sptimerv4
  3. Do Net start sptimerv4
  4. Do iisreset

Solution 3




Ensure the account has full control permissions on the Search service application and IIS account used by this service application
Follow below steps
1. Open Central Admin  > Select Security > Select “Configure service accounts”
 














  1. Select the search service application
     
  2. For “select account for this component” Select a account which has full permission

SharePoint 2013 "The search service is not able to connect to the machine that hosts the administration component"

Issue

SharePoint Server: 

"The search service is not able to connect to the machine that hosts the administration component" after August 2018 CU


Cause

You need to check the EventViewer after installing August 2018 CU binaries and you can see there is a backward compatibility issue for the Search database if you are applying the patch directly after SP1.

EventViewer Log
"The synchronization operation of the search component: 5a44ee64-4c85-4c9e-a5f6-6098cf079cb1 associated to the search application: Search Service Application on server: DXXXXXV has failed. The component version is not compatible with the search database: SharePoint_Search_AdminDB_CrawlStore on server: DBPROD. The possible cause for this failure is The database schema version is less than the minimum backwards compatibility schema version that is supported for this component. To resolve this problem upgrade this database.."

Resolution

Run the PSConfig and it will upgrade Search databases Schema and which will bring the search up and running.

Monday, July 9, 2018

AppFabric (Distributed Cache)- Patched on its own in SharePoint 2013

Patching SharePoint is one of those things I enjoy. The excitement of unwrapping a brand new SharePoint patch is second only to getting a new tie or socks on Christmas morning. When I heard this news I just had to share it with you all. We get to patch AppFabric now! Hurray!
SharePoint 2013 introduced some new functionality, the Distributed Cache. Simply put, the Distributed Cache is a service that caches things like authentication tokens and social newsfeeds, stuff like that. The whole list is in this TechNet article. The process that does this is a product called AppFabric, and it’s installed and configured when you run the SharePoint 2013 Prereq installer. AppFabric is a standalone product, but it’s best to let SharePoint handle the installation and configuration. The Distributed Cache took a page out of the User Profile Service’s book. It can be very fussy when it’s angry.
When SharePoint 2013 first came out we were given strict instructions by Microsoft not to fool with the AppFabric pieces of the Distributed Cache. We might fancy ourselves AppFabric experts, but SharePoint wants it a very particular way, so we should use SharePoint tools to interact with that. That included patching. We were told even if an AppFabric patch knocked on our door and asked us nicely to install it, even if it used Sir or Ma’am, we were to say no. We were to let the SharePoint patches take care of patching AppFabric and the Distributed Cache.
Until now.
Recently Microsoft reversed its position on SharePoint administrators patching AppFabric. Not only are we now allowed to patch AppFabric, it’s actually recommended that we patch it to at least CU4.

SharePoint 2013 Build Numbers - Versions

To see which build your farm is, go to Central Administration > System Settings > Manage servers in your farm (/_admin/FarmServers.aspx)
Or using Windows PowerShell: (get-spfarm).buildversion
To see which build your farm is at with Fiddler, open the site in question and view Inspectors > Headers and under Miscellaneous check the build under MicrosoftSharePointTeamServices header.
To see which build your products are, go to Central Administration > Upgrade and Migration > Check Product and patch installation status. (/_admin/PatchStatus.aspx)
To greatly reduce the time it takes to patch a SharePoint 2013 server, read this blog post by Russ Maxwell, Why SharePoint 2013 Cumulative Update takes 5 hours to install? It explains why the process takes so long and provides a handy script that makes the patch install much more quickly. Do yourself a favor and check it out.

Build Number
Build Name
Component
Information Link
Download Link
Notes
15.0.4128.1014BetaSharePoint Foundation 2013Download
15.0.4128.1014BetaSharePoint Server 2013Download
15.0.4128.1014BetaProject Server 2013Download
​15.0.4420.1017​RTM​​SharePoint Foundation 2013Download
​​15.0.4420.1017​RTM​SharePoint Server 2013Download
​​15.0.4420.1017​RTM​Project Server 2013Download
​15.0.4433.1506​December 2012 Hotfix​SharePoint Server 2013KB2752058Download
​15.0.4433.1506​December 2012 Hotfix​SharePoint Server 2013 (coreserver)KB2752001Download
​15.0.4481.1005​March 2013 Public Update​SharePoint Foundation 2013KB2768000Download
​​15.0.4481.1005​​March 2013 Public Update​SharePoint Server 2013KB2767999Download
​​15.0.4481.1005​​March 2013 Public Update​Project Server 2013KB2768001Download
​15.0.4505.1002​April 2013 CU​​SharePoint Foundation 2013KB2751999Download
​15.0.4505.1005​​April 2013 CU​SharePoint Server 2013KB2726992Download
​15.0.4505.1005​April 2013 CU​Project Server 2013KB775426Download
​15.0.4517.1003​June 2013 CU​SharePoint Foundation 2013KB2817346Download
​15.0.4517.1005​June 2013 CU​​SharePoint Server 2013KB2817414Download
​June 2013 CU​Project Server 2013KB2817415Download
​15.0.4535.1000​August 2013 CU​​SharePoint Foundation 2013KB2817517Download
​​August 2013 CU​SharePoint Server 2013KB2817616Download
​​August 2013 CU​Project Server 2013KB2817615Download
​15.0.4551.1001​October 2013 CU​SharePoint Foundation 2013KB2825674Download
​15.0.4551.1005​October 2013 CU​SharePoint Server 2013KB2825647Download
​October 2013 CU​Project Server 2013
​15.0.4551.1508​December 2013 CU​SharePoint Foundation 2013KB2849961Download​Bugs, Notes, and Regressions
​15.0.4551.1511​SharePoint Server 2013KB2850024Download
​15.0.4551.1508​Project Server 2013KB2837668Download
​15.0.4569.1000*​Service Pack 1​SharePoint Foundation 2013KB2817439Download
​SharePoint Server 2013KB2817429Download
​Project Server 2013KB2817434Download
​15.0.4571.1502*​Service Pack 1 Mark 2​SharePoint Foundation 2013KB2880551Download

​​​SharePoint Server 2013KB2880552Download

​​​Project Server 2013KB2880553Download
​​15.0.4605.1000​April 2014 CU​​SharePoint Foundation 2013KB2863892Download​​
​​SharePoint Server 2013KB2878240Download
​Project Server 2013KB2880484Download
​15.0.4615.1001​MS14-022​SharePoint Foundation 2013KB2952166​Links in KB
​SharePoint Server 2013KB2952166​Links in KB
​Project Server 2013KB2952166​Links in KB
15.0.4617.1000​June 2014 CUSharePoint Foundation 2013KB2881063Download
​SharePoint Server 2013KB2881061Download
​Project Server 2013KB2881062Download
​ 15.0.4631.1001​July 2014 CU​SharePoint Foundation 2013KB2882999Download​​
​​SharePoint Server 2013KB2882989Download
​Project Server 2013KB2882990Download
​15.0.4641.1001​August 2014 CU​SharePoint Foundation 2013KB2883081Download
​SharePoint Server 2013 (1/5)KB2760213Download
​​SharePoint Server 2013 (2/5)KB2880559Download
​​SharePoint Server 2013 (3/5)KB2883078Download
​​SharePoint Server 2013 (4/5)KB2883085Download
​​SharePoint Server 2013 (5/5)KB2883086Download
​Project Server 2013KB2883083Download
​15.0.4649.1001​September 2014 CU​SharePoint Foundation 2013KB2883087Download
​SharePoint Server 2013KB2883068Download
​Project Server 2013KB2883072Download
​15.0.4659.1001​October 2014 CU​SharePoint Foundation 2013KB2889946Download​​
​SharePoint Server 2013 (1/3)KB2899469Download
​SharePoint Server 2013 (2/3)KB2880962Download
​SharePoint Server 2013 (3/3)KB2880485Download
​Documentum ConnectorKB2752098Download
​Project Server 2013KB2889959Download
​15.0.4667.1000​November 2014 CU​SharePoint Foundation 2013KB2899468Download
​​SharePoint Server 2013KB2889944Download
​Project Server 2013KB2889949Download
​15.0.4675.1000​December 2014 CU​SharePoint Foundation 2013KB2910945Download
​SharePoint Server 2013KB2910938Download
​Project Server 2013KB2910911Download
​15.0.4693.1001​February 2015 CU​​SharePoint Foundation 2013KB2920801Download
​​SharePoint Server 2013KB2920804Download
​​Project Server 2013KB2920796Download
​15.0.4701.1001​March 2015 CU​SharePoint Foundation 2013KB2956159Download
​SharePoint Server 2013KB2956166Download
​Project Server 2013KB2956162Download
​15.0.4711.1000​April 2015 CU​SharePoint Foundation 2013KB2965261Download
​​SharePoint Server 2013KB2965266Download
​Project Server 2013KB2965263Download
​15.0.4719.1002​May 2015 CU​SharePoint Foundation 2013 ​​
​SharePoint Server 2013KB3039780
​Project Server 2013KB3039753
​15.0.4727.1001​June 2015 CU​SharePoint Foundation 2013KB3054864Download
​SharePoint Server 2013KB3054866Download
​Project Server 2013KB3054865Download
​​15.0.4737.1001​July 2015 CU​SharePoint Foundation 2013
​SharePoint Server 2013
​Project Server 2013
​​​15.0.4745.1001​August 2015 CU​​SharePoint Foundation 2013KB3055004 ​​
​SharePoint Server 2013
​​Project Server 2013 Download
​15.0.4753.1000​September 2015 CU
SharePoint Foundation 2013
KB2975894
​SharePoint Server 2013
​Project Server 2013
​15.0.4763.1000​October 2015 CU​SharePoint Foundation 2013KB3085488Download​​
​SharePoint Server 2013KB3085492Download
​Project Server 2013KB3085489Download
​15.0.4771.1000​November 2015 CU​SharePoint Foundation 2013KB3101368Download
​SharePoint Server 2013KB3101373Download
​Project Server 2013KB3101369Download
​15.0.4779.1000​​December 2015 CU​SharePoint Foundation 2013KB3114339Download​​
​SharePoint Server 2013KB3114345Download
​​Project Server 2013KB3114341Download
​15.0.4787.1000​January 2016 CU​SharePoint Foundation 2013KB3114492Download
​SharePoint Server 2013KB3114497Download​
​Project Server 2013KB3114493Download
​15.0.4797.1000​February 2016 CU​SharePoint Foundation 2013KB3114722Download
​​SharePoint Server 2013KB3114726Download
​Project Server 2013KB3114723Download
​15.0.4805.1000​March 2016 CU​SharePoint Foundation 2013KB3114822Download​​
​SharePoint Server 2013KB3114827Download
​Project Server 2013KB3114823Download
​15.0.4815.1000​April 2016 CU​SharePoint Foundation 2013KB3114935Download
​​SharePoint Server 2013KB3114938Download
​​Project Server 2013KB3114936Download
​15.0.4823.1003​May 2016 CU​SharePoint Foundation 2013KB3115023Download
​SharePoint Server 2013KB3115029Download
​Project Server 2013KB3115024Download
​15.0.4833.1003​June 2016 CU​SharePoint Foundation 2013KB3115171Download
​SharePoint Server 2013KB3115174Download
​Project Server 2013KB3115172Download
​15.0.4841.1000​July 2016 CU​SharePoint Foundation 2013KB3115290Download
​SharePoint Server 2013KB3115293Download
​Project Server 2013KB3115291Download
​15.0.4849.1000​August 2016 CU​SharePoint Foundation 2013KB3115447Download
​SharePoint Server 2013KB3115450Download
​Project Server 2013KB3115448Download
​15.0.4859.1000​September 2016 CU​SharePoint Foundation 2013KB3118271Download​​
​SharePoint Server 2013KB3118279Download
​Project Server 2013KB3118274Download
​15.0.4867.1002​October 2016 CU​SharePoint Foundation 2013KB3118361Download​​​
​​SharePoint Server 2013KB3118366Download
​Project Server 2013KB3118365Download
​15.0.4875.1000​November 2016 CU​SharePoint Foundation 2013KB3127930Download​​​​
​SharePoint Server 2013KB3127933Download
​Project Server 2013KB3127931Download
​15.0.4885.1000​December 2016 CU​SharePoint Foundation 2013KB3128001Download
​SharePoint Server 2013KB3128005Download
​Project Server 2013KB3128003Download
​15.0.4893.1001​January 2017 CU​SharePoint Foundation 2013KB3141479Download
​​SharePoint Server 2013KB3141481Download
​Project Server 2013KB3141480Download
​February 2017​No Updates
​15.0.4911.1001​March 2017 CU​SharePoint Foundation 2013KB3172456Download
​SharePoint Server 2013KB3172497Download
​Project Server 2013KB3172462Download
​15.0.4919.1003​April 2017 CU​​SharePoint Foundation 2013​KB3178727Download
​SharePoint Server 2013KB3178730Download
​Project Server 2013KB3178725Download
​15.0.4927.1001​May 2017 CU​​​SharePoint Foundation 2013​KB3191911Download
​SharePoint Server 2013KB3191913Download
​​Project Server 2013KB3191912Download
​15.0.4937.1001​​June 2017 CU​​​SharePoint Foundation 2013​KB3203428Download​​
​​SharePoint Server 2013​KB3203430Download
​​​Project Server 2013KB3203429Download
​15.0.4945.1000​July 2017 CU​SharePoint Foundation 2013​KB3213563Download
​SharePoint Server 2013​KB3213569Download
​Project Server 2013KB3213566Download
​15.0.4953.1000​August 2017 CU​​SharePoint Foundation 2013​KB4011073Download
​​SharePoint Server 2013​​KB4011076Download
​Project Server 2013KB4011074Download
​15.0.4963.1000​September 2017 CU​​​SharePoint Foundation 2013​KB4011132Download
​​​SharePoint Server 2013​​​KB4011116Download
​​Project Server 2013KB4011115Download
​15.0.4971.1000​October 2017 CU​SharePoint Foundation 2013​KB4011173Download
​SharePoint Server 2013​​​KB4011177Download
​Project Server 2013KB4011175Download
​15.0.4981.1002​November 2017 CU​​SharePoint Foundation 2013​KB4011248Download
​​SharePoint Server 2013​​​KB4011251Download
​Project Server 2013KB4011249Download
​15.0.4989.1001​December 2017 CU​​​SharePoint Foundation 2013​KB4011588Download​​
​​​SharePoint Server 2013​​​KB4011593Download
​Project Server 2013KB4011589Download
​15.0.4997.1001​January 2018 CU​​​​SharePoint Foundation 2013​KB4011649Download
​SharePoint Server 2013​​​KB4011652Download
​Project Server 2013KB4011650Download
​15.0.5007.1000​February 2018 CU​​​​​SharePoint Foundation 2013​KB4011693Download
​SharePoint Server 2013​​​KB4011696Download
​​Project Server 2013KB4011694Download
​15.0.5015.1000​March 2018 CU​SharePoint Foundation 2013​KB4018299Download
​SharePoint Server 2013​​​KB4018302 Download
​Project Server 2013KB4018301Download
​15.0.5023.1001​April 2018 CU​​SharePoint Foundation 2013​KB4018345Download​​
​​SharePoint Server 2013​​​KB4018348Download
​Project Server 2013KB4018346​Download
​15.0.5031.1001​May 2018 CU​SharePoint Foundation 2013​KB4018394Download
​​​SharePoint Server 2013​​​KB4018397Download
​​Project Server 2013KB4018395Download
​15.0.5041.1000​June 2018 CU​​SharePoint Foundation 2013​KB4022184​Download
​15.0.5049.1001​July 2018 CU​​SharePoint Foundation 2013​KB4022239Download
​SharePoint Server 2013​​​KB4022241Download
​Project Server 2013KB4022240Download​
15.0.5059.1000
August 2018 CU
​​SharePoint Foundation 2013
SharePoint Server 2013​​​
Project Server 2013
15.0.5067.1000
September 2018 CU
SharePoint Foundation 2013
SharePoint Server 2013​​​
Project Server 2013
15.0.5075.1000​October 2018​SharePoint Foundation 2013​KB4461455​Download
​SharePoint Server 2013​​​KB4461458Download
​Project Server 2013KB4461456Download
​15.0.5085.1000​November 2018​​SharePoint Foundation 2013​KB4461508Download
​SharePoint Server 2013​​​KB4461510Download
​Project Server 2013KB4461509Download
​15.0.5093.1000​December 2018​​​SharePoint Foundation 2013​KB4461552Download​​
​​SharePoint Server 2013​​​KB4461555Download
​Project Server 2013KB4461553Download
​15.0.5101.1000​January 2019​SharePoint Foundation 2013​KB4461603Download​​
​SharePoint Server 2013​​​KB4461605Download
​​Project Server 2013KB4461604Download
​15.0.5111.1000​February 2019​​SharePoint Foundation 2013​KB4462150Download
​SharePoint Server 2013​​​KB4462152Download
​Project Server 2013KB4462151Download
​15.0.5119.1001​March 2019​SharePoint Foundation 2013​KB4462217Download​​
​SharePoint Server 2013​​​KB4462219Download
​​Project Server 2013KB4462218​​​Download
​15.0.5127.1001​April 2019​​SharePoint Foundation 2013​KB4464512Download
​SharePoint Server 2013​​​KB4464514Download
​​​Project Server 2013​KB4464513​​​Download​
​15.0.5137.1000​May 2019​​​SharePoint Foundation 2013​KB4464560Download​​
​​SharePoint Server 2013​​​KB4464563Download
​Project Server 2013​KB4464562Download
​15.0.5145.1000​June 2019​SharePoint Foundation 2013​KB4464598Download
​​​SharePoint Server 2013​​​KB4464601Download
​Project Server 2013​KB4464600Download
​15.0.5153.1000​July 2019​SharePoint Foundation 2013​KB4475523Download
​SharePoint Server 2013​​​KB4475526Download
​Project Server 2013​KB4475524Download
​15.0.5163.1000​August 2019​SharePoint Foundation 2013​KB4475559Download
​SharePoint Server 2013​​​KB4475561Download
​Project Server 2013​KB4475560Download​
​15.0.5172.1000 ​September 2019​SharePoint Foundation 2013​KB4475610Download
​SharePoint Server 2013​​​KB4484095Download
​Project Server 2013KB4484093Download
​15.0.5179.1000​October 2019​SharePoint Foundation 2013​KB4484118Download
​SharePoint Server 2013​​​KB4484121Download
​Project Server 2013KB4484120Download
​15.0.5189.1000​November 2019​​SharePoint Foundation 2013​KB4484153Download
​SharePoint Server 2013​​​KB4484155Download
​Project Server 2013KB4484154Download
Back to Top


Office Web App 2013

To see which version of the OWA (also called the "Web Access Components" or "WAC") use the following PowerShell:  
(Invoke-WebRequest http://owa.contoso.com/m/met/participant.svc/jsonAnonymous/BroadcastPing).Headers["X-OfficeVersion"]

Build Number
Build Name
Information Link
Download Link
15.0.4420.1007
RTM
March 2013 PU whoops
KB2760486
15.0.4481.1005
March 2013 PU
15.0.4481.1508
April 2013 CU
15.0.4505.1001
April 2013 Hotfix
15.0.4517.1003
June 2013 CU
15.0.4535.1000
August 2013 CU
15.0.4551.1003
October 2013 CU
15.0.4551.1508
December 2013 CU
15.0.4551.1515
MS14-001 Security Update
15.0.4569.1000
Service Pack 1
15.0.4569.1000
Service Pack 1 - Mark 2
15.0.4605.1001
April 2014 CU
15.0.4615.1001
MS14-022
Links in KB
15.0.4623.1001
June 2014 CU
15.0.4631.1000
July 2014 CU
15.0.4641.1001
August 2014 CU
15.0.4659.1001
October 2014 CU
November 2014 CU
None
None
15.0.4673.1000
December 2014 CU
January 2015 CU
None
None
15.0.4693.1001
February 2015 CU
15.0.4701.1001
March 2015 CU
15.0.4711.1000
April 2015 CU
​​KB2965306
15.0.4719.1002
May 2015 CU
15.0.4727.1001
June 2015 CU
15.0.4737.1001
July 2015 CU
15.0.4745.1001
August 2015 CU
15.0.4753.1001
September 2015 CU
15.0.4763.1000
October 2015 CU
November 2015 CU
No Updates
December 2015 CU
No Updates
January 2016 CU
No Updates
15.0.4797.1001
February 2016 CU
15.0.4805.1000
March 2016 CU
15.0.4815.1000
April 2016 CU
15.0.4823.1003
May 2016 CU
15.0.4833.1003
June 2016 CU
15.0.4841.1000
July 2016 CU
​​15.0.4849.1000
August 2016 CU
​​KB3115446
15.0.4859.1000
September 2016 CU
15.0.4867.1000
October 2016 CU
15.0.4875.1000
November 2016 CU
December 2016 CU
No Updates
January 2017 CU
No Updates
February 2017 CU
No Updates
15.0.4911.1001
March 2017 CU
15.0.4919.1001
April 2017 CU
​​KB3178725
15.0.4927.1001
May 2017 CU
15.0.4937.1001
June 2017 CU
July 2017 CU
No Updates
August 2017 CU
​​No Updates
15.0.4963.1001
September 2017 CU
​15.0.4971.1000KB4011231Download​
​15.0.4981.1002​November 2017 CUKB4011247Download
​15.0.4989.1001​December 2017 CUKB4011587Download​
​15.0.4997.1001​January 2018 CUKB4011648Download​
​February 2018 CU​​No updates
​15.0.5017.1001​March 2018 CUKB4011692Download
​15.0.5023.1001​April 2018 CUKB4018344Download​
​15.0.5031.1001​May 2018 CUKB4018393Download​
​15.0.5041.1000​June 2018 CUKB4022183​Download​

Workflow Manager 2013
To see which version of Workflow Manager and Service Bus are installed, use the following PowerShell:
(Get-ChildItem -Path "C:\Program Files\Workflow Manager\1.0\Workflow\Artifacts\Microsoft.Workflow.Service.dll").VersionInfo
(Get-ChildItem -Path "C:\Program Files\Service Bus\1.0\Microsoft.ServiceBus.dll").VersionInfo
or
(Get-ChildItem -Path "C:\Program Files\Service Bus\1.1\Microsoft.ServiceBus.dll").VersionInfo
When you install Workflow Manager CU 1 you also have to install Service Bus CU1. Also make sure you patch the Workflow Manager client on SharePoint servers that are not running the Workflow Manager service. See more details on how to patch Workflow Manager on Andrew Connell's blog.

Build Number
Build Name
Information Link
Download Link
1.0.20922.0 (2.0.20922.0)
RTM - Service Bus 1.0 and Workflow Manager 1.0
1.0.30207.2 (2.0.30207.2)
CU 1 - Service Bus 1.0
1.0.30207.2 (2.0.30207.2)
CU 1 - Workflow Manager 1.0
1.0.40131.0 (2.1.30904.0)​
CU 2 - Workflow Manager 1.0
​1.0.51113.2 (2.1.40512.2)​CU 3 - Workflow Manager 1.0KB3104066Download​



AppFabric (Distributed Cache)

​It's okay to patch AppFabric.
DateBuild Name​​
Information Link
Download Link​
​3/27/2012CU 1​KB2671763Download
6/27/2012
​​CU 2 (1.1.2116.2)
KB2716015​​Download
​12/12/2012CU 3​ (1.1.2118.2)KB2787717​​Download
4/12/2013​​CU 4 (1.1.2124.2)KB2800726​​Download
3/25/2014​CU 5​KB2932678​​Download
​4/21/2015CU 6​KB3042099​​Download
11/10/2015​​CU 7​KB3092423​​Download