Create multipage SharePoint new item form with PowerApps

SharePoint Online allows you to customise a list forms using PowerApps. Creating a simple form is a piece of cake, but their are a few things you need to do when making a multipage form. Starting with a SharePoint list, choose the PowerApp option at the top of the list view. In PowerApps studio create a Screen for each section and then build your custom … Continue reading Create multipage SharePoint new item form with PowerApps

Azure Storage and SharePoint Migration Tool errors

I’ve used the SharePoint Migration Tool successfully on numerous occasions but this week I had a very unusual issue. In the SharePoint Migration Tool log file from a failed migration we found this error: Scan File Failure: The parent folder was not migrated 0x0111000F Failed to Read the file: Could not retrieve file’s metadata 0x01310007 For some reason the files could not be read, it … Continue reading Azure Storage and SharePoint Migration Tool errors

New Zealand Microsoft User Groups

I’ve collated a list of active Microsoft focused user groups in New Zealand. User Groups are a great way to meet people in the community, learn new things and start a career as a public speaker. These groups are free to attend! (let me know if I’ve missed your group and I’ll update this list) Auckland .NET User Group https://www.meetup.com/AKL-NET/ Auckland Azure User Group https://www.meetup.com/Auckland-Azure-Usergroup/ Auckland … Continue reading New Zealand Microsoft User Groups

Microsoft Flow, linking email to SharePoint List items

Using SharePoint and Microsoft Flow, I built a system for sending emails to external people and then processing the replies, including extracting attachments and linking back to the original SharePoint List Item. Here’s the process: User creates a new List Item with the email address of an external person (can be internal also) Using Flow, send an email to the external person’s email address: Subject … Continue reading Microsoft Flow, linking email to SharePoint List items

Upload files to SharePoint Library Subfolders with PowerShell

There are a number of ways to upload files to SharePoint, but every now and then I get asked to do something a bit different. In this case it was to migrate files from a database into SharePoint. The database had a file path reference with documents stored in a file structure on Windows file share. Success would see over 80,000 documents transferred into just … Continue reading Upload files to SharePoint Library Subfolders with PowerShell

SharePoint Error 401 Listdata.svc

I recently had an interesting issue with an OData connection to SharePoint 2013. The connection that had been working perfectly stopped due to authentication failure (error 401). If I navigated to the URL in the web browser I was prompted for authentication but the credentials weren’t accepted, any other parts of the site worked perfectly OK. To troubleshoot the problem I tried connecting to the … Continue reading SharePoint Error 401 Listdata.svc