In another post I reviewed how we can integrate a Form with Excel, letting all of that beautiful data be saved directly into an Excel file. This solution works really well if you are creating a new form. What if we have an existing form and we want it to write to Excel? Unfortunately, there... Continue Reading →
Microsoft Teams, Forms and Flow on the go!
This is the final post in this mini series where we looked at the simplicity and easy of integrating within the Office 365 stack. Create a Form and have the data save directly in Excel Add the Form to Microsoft Teams Notify the Team a submission was made How does this look like on the... Continue Reading →
Collect Survey Results Seamlessly in Microsoft Teams with Forms
This post is the the second post in this mini series as we look at how easy the Office 365 stack integrates. In this series, we will: Create a Form and have the data save directly in Excel Add the Form to Microsoft Teams (this post) Notify the Team a submission was made How does this... Continue Reading →
Use Microsoft Forms to collect data right into your Excel file
This post is the first of a few where we look at how easy the Office 365 stack integrates. In this series, we will: Create a Form and have the data save directly in Excel (this post)Add the Form to Microsoft TeamsNotify the Team a submission was madeHow does this look like on the phone I... Continue Reading →
Overview of SharePoint 2013’s Services
With the new version, we get new features and functionality. The following lists off the services available with SharePoint 2013 Enterprise, and briefly explains what they do. I made this for my own reference, but thought I'd share. I've also added links to TechNet articles on how to install/configure. There is a great article which covers these... Continue Reading →
More iPad support for SharePoint: Dashboards, PowerPivot, & Excel!
It's nice to see Microsoft playing nice with others. The cumulative update 2011-12 (CU Dec 2011, or Feb 2012) includes improvements around the iPad. Specifically, users can now access dashboards, Excel services, and PowerPivot services via their iPad! For complete details, check out http://technet.microsoft.com/en-us/library/hh697482.aspx. There's a great video on that page that walks through how well... Continue Reading →
Loading SharePoint lists from Excel using PowerShell
One of my biggest headaches with developing and testing in SharePoint is my lack of test data to work with. Sometimes I need to generate a load of test data so I can perform searches or test performance on custom code. Like in this blog post, I needed to load up a bunch of fake... Continue Reading →
PowerPivot Walkthrough Using SharePoint Lists
Before we can just walk through using PowerPivot and SharePoint, we need to make sure things are in order. Some prerequisites PowerPivot has been installed and properly configured on your farm. Download PowerPivot for Excel 2010, SQL Server 2008 R2 version (SQL 2012 version WILL NOT WORK!) for free at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609. I am using the Northwind sample... Continue Reading →