Slides from M365 Twin Cities 2023

A huge thank you to the attendees, organizers, volunteers, sponsors, and anyone else involved with M365 Twin Cities. This was my first community conference in 3+ years but it was amazing to share more about Microsoft Graph in my two sessions. I appreciate all of the attendees who joined and had great questions and engagement.

Below are PDF copies of the slides I presented. If you have any questions, feel free to ask in the comments here or reach out to me. Look forward to presenting at more events later this year as opportunities arise.

Getting Up to Speed with Microsoft Graph Development

How to Use Power Automate and Microsoft Graph in Daily Work

-Frog Out

Resources (see more in Resources on this blog)

Microsoft Graph developer center

Microsoft Graph Explorer

Microsoft Graph Postman collection

Microsoft Graph extension for Polyglot Notebooks

Microsoft 365 platform community call (series invite)

Microsoft Graph team on the Hello World show

Last week, a number of my fellow teammates (Darrel Miller, Fabian Williams, Sebastian Levert, Beth Pan, Vincent Biret, and Walkdek Mastykarz) from the Microsoft Graph team joined the Hello World show for a special episode. We covered a number of great topics like getting started with Microsoft Graph, using Microsoft Graph Toolkit, and learning about SDK support. Check out the recording or jump to specific segments of the show!

Generic Image

Hello World: Microsoft Graph (recorded 2021-09-16)

Generic Image

-Frog Out

Presenting at Collab365 GlobalCon3

I have the privilege of presenting “Introduction to Microsoft Graph Development” at the upcoming Collab365 GlobalCon3 taking place Sept 8-11, 2020.  This is a free online conference with MVPs and experts from around the world presenting on developer, IT Pro, and adoption topics.

Title: Introduction to Microsoft Graph Development

Abstract: “I hear that I need to use Microsoft Graph for developing against Office 365 but I have no clue where to start.” “I want to grant access to company data without throwing in the entire kitchen sink.” Fear not fellow developers and admins. This session we will ramp you up to a 200 level knowledge on the pertinent parts of Microsoft Graph including endpoints available, syntax, authentication flows, and more. We will also cover useful examples of what can be accomplished using these APIs. Prior experience with Microsoft Graph is not required but can be helpful.

You can also purchase an all-access pass which includes lifetime access to the videos, additional e-books, and more.  Looking forward to participating in this great event.

How To Print QR Code Stickers


As Registration Chairperson for Stir Trek Conference, this year I was in charge with coming up with a way to print QR code stickers for 2,100+ attendees.  The QR codes would contain name and email address for a registered attendee so that sponsors could have a quicker / easier way to capture contact information for giveaway prizes or sending follow up communications.  Since we care about attendee privacy we also planned for “opt-out” stickers that could cover over the QR code stickers if attendees chose.  In this post I’ll walk through the highlights of how we designed, created, and printed the QR codes stickers.


Designing QR Codes

Before starting this project I was familiar with QR codes, but I never knew the amount of data (or what type) could be encoded in a QR code.  Even more interesting (at least to me) is the science behind how to size the QR code relative to the distance at which the QR code will be scanned.  The following article is from 2011 but gives some insight into scaling the number of characters encoded with the scanning distance.

QR Code minimum size

QR Code Minimum Size
Modules Characters Scan Distance
150mm (6″) 300mm (12″) 450mm (18″)
25 26 15mm (0.6″) 30mm (1.2″) 46mm (1.8″)
30 49 18mm (0.7″) 36mm (1.4″) 55mm (2.1″)
35 72 21mm (0.8″) 42mm (1.7″) 64mm (2.5″)
40 98 24mm (0.9″) 48mm (1.9″) 73mm (2.9″)
45 125 27mm (1.1″) 54mm (2.1″) 82mm (3.2″)
50 163 30mm (1.2″) 60mm (2.4″) 91mm (3.6″)
55 203 33mm (1.3″) 66mm (2.6″) 100mm (3.9″)
60 249 36mm (1.4″) 72mm (2.8″) 109mm (4.3″)
65 298 39mm (1.5″) 78mm (3.1″) 118mm (4.7″)
70 351 42mm (1.7″) 84mm (3.3″) 127mm (5.0″)
75 407 45mm (1.8″) 90mm (3.5″) 137mm (5.4″)
80 468 48mm (1.9″) 96mm (3.8″) 146mm (5.7″)
85 534 51mm (2.0″) 102mm (4.0″) 155mm (6.1″)
90 601 54mm (2.1″) 108mm (4.3″) 164mm (6.4″)
95 669 57mm (2.2″) 114mm (4.5″) 173mm (6.8″)
100 739 60mm (2.4″) 120mm (4.7″) 182mm (7.2″)

We needed to encode attendee first name, last name, and email address.  After analyzing our registration data the longest combination of those fields was under 125 characters so we could safely scan a 1″ x 1″ sticker from 6″ away.  Since the QR code stickers are put on the attendee badge, the smaller the sticker size the better so that we didn’t take up too much space (or cover the great artwork from Nate Lovett and badge design from Carey Payette).

Label Stickers

Since the stickers needed to be 1″ x 1″ I purchased 100 sheets (80 per sheet / 8,000 total) of the following label stickers for less than $20 USD.  This allowed for many sample prints to ensure images and other information was lined up on the stickers for the final product.

OL5425 – 1″ x 1″ One Inch Square Labels

Label template

The stickers came with free downloadable Microsoft Word template for the exact dimensions and layout needed.  One wrinkle to the plan was that our shipping vendor (great folks at Markt custom apparel) would be applying the stickers to the badges as they packed attendee boxes.  As such we needed to print not only the QR code but also a “verification” sticker with attendee name and registration ID number to ensure the right QR code went to the right box.  More on that later using Word’s mail merge to accomplish that challenge.

Generating QR Codes

My primary laptop runs Windows 10 and I was able to find an app in the Microsoft Store called “QR-Code Generator Pro”.  There is a QR code bulk creation functionality in the paid “pro” version.  I exported our registration data (name + email address) from Eventbrite to a suitable CSV format that this app could then encode.

QR-Code Generator Pro

Importing QR Codes

For many years I’ve “known” about mail merge but I had honestly never used it for more than 5 mins at a time.  Working with 2,100+ attendees made mail merge a necessity for the scale and complexity of what I needed.  I found the following online article that walks through creating the placeholders in the mail merge template and then linking fields from attendee registration spreadsheet to those placeholders.

2 Ways to Batch Insert Multiple Pictures into Your Word Document via Mail Merge

This took much longer than expected due to the sometimes one-way changes that were applied which required starting over from scratch.  I settled on a template that I can now re-use in future years by simply importing the newest attendee data spreadsheet and applying the mail merge.  As mentioned previously needing to print not only the QR code but also attendee verification data meant that the “next record” tag had to appear on every other label in the template.

Printing QR Codes

Printing the QR codes on the label stickers took a number of sample runs before I got them working properly.  At first the QR codes printed slightly off center.  Attempting to adjust the margins on the QR code images proved unsuccessful.  In the future I may look at increasing the (pixel) size of the generated QR codes to compensate for the printing issue.


Overall I’m very happy with the final results and the fact that this is a fairly automated and reusable process.  As always we’ll continue to tweak and refine the process to continue delivering the best we can for our attendees.  If this overview helped save you time, effort, etc. please let me know in the comments or share back improvements.


-Frog Out