I’ve been working on a solution for a customer that utilizes SharePoint Online lists and libraries, PowerApps, Logic Apps, and Azure Functions. The solution works something like this: Project documents are stored and updated in a SharePoint Library by office staff. The shop floor needs to access the documents and know at a glance when documents have been updated. The PowerApp displays a count of the most recently updated documents by project and document type, and also displays the documents. A SharePoint List is used to store the counts of the most recently updated documents. The Logic App and Azure Function work together to update the SharePoint List with the counts from the SharePoint Library.
As part of the solution, we wanted a way to be notified if the Azure Function threw an error. This is where SendGrid comes in. SendGrid is a third-party email delivery service. Azure Functions support an output binding for SendGrid, which makes it very easy to integrate into your solution.Here is a grand overview of how my solution (just the Azure Function and SendGrid piece) will work – If my Azure Function throws an error, it will send the error message to Azure Queue Storage. The error message will be stored in Azure Queue Storage until another Azure Function (2) comes and picks it up. Azure Function (2) will use SendGrid to send an email containing the error message. Easy-peasy. You can use SendGrid to send emails for all kinds of reasons – when a customer places an order, you can send a confirmation email with the details of the order; when someone clicks a button on your site to request information, you can send an email with the requested information; the options are endless.
Continue reading “Using SendGrid with Azure Functions to Send Email”
Happy New Year! January is here – new year, new you, right? Personally, I don’t believe in all that new year’s resolution stuff. Every day is a new opportunity to live your best life. How about we stick to new year, new updates for Office 365? There are some changes that will increase security, a change that may affect network traffic, best practice guidelines, and as always, an exciting new feature to highlight. Regarding security, Microsoft is retiring 3DES in Office 365, and sharing links that block download have begun rolling out. If you have configured your network to restrict resource access to Azure AD IP address ranges, make sure to read the piece on Azure AD updating IP Addresses. PowerApps users will be happy to see the release of a white paper on coding guidelines and standards. And finally, the exciting new feature we are highlighting this month is reminders in SharePoint.
Continue reading “What’s New in Office 365 (January 2019)”
As we start a new year it’s always good to reflect on what we’ve accomplished but the real fun is in trying to figure out where we are going😉. Disclaimer: I am in no way, shape or form privy to the inner workings of the various product teams at Microsoft and the views expressed within this post are my own. With that out of the way, here are my not so bold predictions for Office 365 in 2019. Continue reading “Not So Bold Predictions for Office 365 in 2019”
December is upon us – the lights, the music, the shopping; but don’t let that distract you from the exciting things happening in the world of Office 365! There is something for everyone – new options for site branding in SharePoint, the ability to manage MS Teams in the Teams & Skype Admin Center, new MS Teams Administrator roles, licensing updates for PowerApps/MS Flow, and a way to restrict users from creating Office 365 groups. Continue reading “WHAT’S NEW IN OFFICE 365 (DECEMBER 2018)”
Microsoft is very permissive when it comes to creating Office 365 groups. The default is that everyone can create Office 365 groups. Users can create groups from several different applications, and each user can create up to 250 groups. With this kind of freedom, things can get out of control pretty quickly. Before you know it, your environment can have a plethora of Office 365 Groups that may not be useful or even used. Sometimes the old adage is true – just because they can, doesn’t always mean they should.
Continue reading “Restricting Users from Creating Office 365 Groups”
October was a great month for those of us in the IT Pro space in Office 365, especially with the SharePoint Online Admin center enhancements. Unfortunately, we have yet to see the Teams Administration Dashboard in our tenant or any of our customers tenants but hopefully by typing this up we will assure ourselves of sticking our foot in out mouth and it will pop up. While many of the “big” developments from October are geared towards IT folks, there were still a couple noteworthy updates for the user base as well.
Side-note: If you plan to be in or around Chicago, IL in the beginning of December and want to increase your knowledge on Office 365/SharePoint head over to the SharePoint Fest Chicago event being held 12/3/2018 – 12/7/2018. Don’t let the name mislead you, they cover a lot of SharePoint items, but you will also see many other Office 365 applications covered as well as Azure topics. The event has different levels of sessions for end users, power users, IT professionals and developers so it really is for everyone. Continue reading “WHAT’S NEW IN OFFICE 365 (NOVEMBER 2018)”
I’ve been working in SharePoint for an eternity and in Office 365 long enough to know better yet here we are. We had a customer request a dirt simple MS Flow to dump an Excel from SharePoint to a local file share on their network so that it could be pulled into a 3rd party tool. We had just done something far more complex for a similar size/type of customer, so I just glanced at the Flow Pricing page to make sure the on-premises data gateway was listed for Office 365 as I’m always paranoid about licensing, sure enough it was there. Verified permissions were good to go and I was confident we could knock this thing out in an hour…wrong! Continue reading “Office 365 Licensing Finally Got Me”