Microsoft 365

Yesterday in #FutureOfSharepoint event I heard about new Microsoft Flow feature. I felt it really interesting and more useful. I would like to highlight more capabilities of Flow here. Microsoft Flow (Preview) offers businesses ways to connect many different services to automate tasks and makes it easy to mash-up two or more dif­ferent services. Microsoft Flow is publicly available and has connections to 35+ different services, including both Microsoft services like OneDrive and SharePoint, and public software services like Slack, Twitter and Salesforce.com, with more being added. Microsoft Flow is a product to help you set up automated workflows between your favorite apps and ser­vices to synchronize files, get notifications, collect data, and more. Mi­crosoft Flow can accelerate your business so you spend less time on mun­dane, repetitive tasks, and more time on what you want to do. Microsoft Flow Capabilities: Add multiple actions to a flow: ¨   Customize a flow by ...

By default, SharePoint 2013 does not wrap the Tiles instead it will show the links horizontally and also enables horizontal scrolls when the tiles are more than screen width. The following script will wrap the Tiles like 4 tiles per row. Wouldn't it be nice to have the option to cause the tiles to "wrap?" An example of useful wrapping would be breaking up the 12 tiles into 3 rows; 1 row for each 4 tiles. This would create the desired aesthetically pleasing display, without going past the edge of smaller screens. With this small JavaScript, the proper wrapping of tiles is possible. Just add a " Script Editor " web part to the page and paste the following code to the snippet.  <style>   .ms-promlink-body {     width: 650px;   }     </style> <script type= "text/javascript" src= " http://code.jquery.com/jquery-1.10.2.min.js " ></script> <script type= "text/javascript" >...

PowerPivot is a business intelligence and data analysis tool built as an extension to Excel and SharePoint’s Excel Services. As the business community continues to expand its use of business intelligence tools. PowerPivot for SharePoint supports Excel 2010/2013 workbooks that contain PowerPivot data and can be publish to a SharePoint site. As a result, other users who do not have the PowerPivot add-in installed can view and interact with the workbook. In addition, PowerPivot for SharePoint has unique features to extend the capabilities of Excel workbooks that contain PowerPivot data. For example, you can do the following: Highlight workbooks and the information that they contain from within SharePoint. Refresh external connections to resources to keep the data current. Schedule times to update the data automatically. Reuse PowerPivot data from one workbook in other workbooks. Download PowerPivot for Excel  How to configure: PowerPivot workbooks are sto...

In my recent post I have talked about how to install and configure Power Pivot for Excel. http://gowritech.blogspot.com/2016/04/download-powerpivot-for-excel.html Now in this post we will learn about how to analyze data using Excel 2013 Power View. I have created a List called Enrollment and added few records. 1. Open the Excel application 2. Go to POWERPIVOT tab and click on the Manage option. 3. It will launch POWERPIVOT window. 4. Now we have to bring SharePoint list data here to analyze. 5. The following feed URL can be used to connect SharePoint list.       http://<SharePoint Site>/_vti_bin/ListData.svc 6. In the PowerPivot window, click on the From Data Service -> From OData Data Feed option and type the data feed URL, test the connection. 7. Select the desired list and click on Finish button. Click on Close button once you see Success message. 8.  You can see the data as below. 9. In the ribbon, you can see Pivot...