Once again Microsoft has been rolling out updated and new features at neck breaking speed. While it’s hard to argue with their numbers I cannot help but agree with some of the sentiments put forth by Andrew Connell in his SharePoint Framework Summer 2019 Wish List post on September 4th. If you’re a developer doing any work with the SharePoint Framework the article is a must read. If you’re not, just know that the gist of the article is “New stuff is great but how about we clean up what we already have rolled out”. Again, hard to argue with Microsoft’s results but Andrew’s logic is spot on as usual. With that diatribe out of the way here are some other notable happenings in Office 365 in the past month.
Category Archives: Azure
I attended the Azure Virtual Day Camp put on by the Power Platform Users Group earlier this week. I registered for sessions from two different tracks (Developer and Architect); but in the end, they only registered me for 3 sessions in the Architect track (some of which were sessions for which I had not even registered). I was a bit disappointed, because I really wanted to attend the Developer sessions. The saving grace is that they sent me the recordings from the Developer sessions. Hopefully, I can find some time to watch them.
Developing with PowerApps, Flow and Azure Cognitive Services
My first session by Mariano Gomez was the most interesting. Mariano walked us through developing a Conference Badge Scanner App. The app scans a badge, converts the data to text, and sends an email to the badge owner. This same technology could easily be used to scan business cards and send them to a contacts list/data base. The App uses PowerApps, Flow and the Computer Vision API. Mariano demontrated building the app during the 45-minute session. That is how easy it is to leverage the power of the power platform. Read more
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.