Skip to main content

Expert Insights

blog

Office 365


Exporting SharePoint Group Members to Excel Without PowerShell

I was at a client recently and was not allowed to run any powershell commands but needed a list of accounts that existed in a SharePoint Group in a table format.  I also was not allowed site collection administration permission.  I tried a few different options in which trying to manipulate the list view of the group and using Excel data connections to get back to SharePoint but no option worked very cleanly.  

What I ended up using was a REST call to get the users and then downloading the XML response and opening it with Excel.  Use this link to learn about the available REST api’s for users & groups

Here are the steps….

Drew Madelung by Drew Madelung

InfoPath 2013 for Office 365 ProPlus

InfoPath 2013 is sticking true to the continuing support statements that were made about the software by releasing a standalone version.  For anyone who was running the Office 365 ProPlus edition of Microsoft Office, it was not possible to also run InfoPath.  Thankfully this has now changed and the standalone version can run side-by-side with Office and is now available to download from Microsoft.

Drew Madelung by Drew Madelung

SharePoint Summit 2015 Materials

I had the chance to participate in Concurrency's first ever SharePoint Summit that crossed multiple cities in the Midwest.  There was awesome audience participation with some great questions. It was ...

Drew Madelung by Drew Madelung

Azure AD Connect General Availability Announced

Last week Microsoft announced the General Availability of Azure AD Connect. With this release all existing Azure AD and Office 365 customers should start planning their upgrade of their existing directory synchronization tools to Azure AD Connect.

Bill Hughes by Bill Hughes