The title of this post is a little silly, but I will be speaking at the Minnesota SharePoint Users Group and the Minnesota Office 365 User Group in February!
First up on February 14th, I will be presenting an intro session on Microsoft Flow and discussing the Flow road-map. You can find more details and register here: MN SharePoint User Group February
The second session will be on February 15th at the Minnesota Office 365 user group. This session will focus on Power BI – with an extra focus on how to administer the service. Details and register here: MN O365 User Group February
It was a great week in San Francisco! The #ITDEVConnections conference is a high-quality event that focuses on real-world technical sessions and the conference delivered. Both of my sessions had good participation from attendees – I enjoyed answering questions and getting to know everyone.
In my second session we looked at the business intelligence options in SharePoint, as well as Power BI. One of the great BI additions in SharePoint Online capabilities is column formatting that is currently rolling out. I demonstrated how you can easily use JSON code to style and enhance list views and how that can make a huge difference for your users.
[ORIGINAL POST BELOW]
Please join me in San Fransisco for IT/Dev Connections! I will be speaking on October 24th and 25th – I would love to have you join me.
On October 2ad4th, I will be presenting Transition Your SharePoint Designer Workflows to Microsoft Flow and on the 25th my presentation will be all about Business Intelligence Using SharePoint and Power BI.
If you plan to be at the conference, please let me know so we can meet up!
I sat down with Cory Williams [Twitter] at SharePoint Saturday (SPS) Charlotte to get his thoughts on Office 365 administration. Cory is one of the organizers of SPS Charlotte and was a speaker as well!
00:44 Pay attention to the Office 365 Message Center 01:17 Shameless plug for the REgarding 365 web show Office 365 Message Center: The week that was 01:47 New SharePoint Console 02:04 More dates please! 02:35 Release schedule – when are new features showing up in my Office 365 tenant 02:44 Reminders for new features and changes 03:36 Let’s tie Microsoft Flow into the Office 365 Message Center
When Adding a Power BI report to a modern SharePoint page, are filters and options taken into account when show on the page? Yes they are!
Is the Power BI report show on a modern SharePoint page a snapshot of the visuals or live data? If live, how is the data refreshed? The visuals shown are ‘live’ and will be refreshed when the report is changed or data is refreshed (scheduled within the Power BI service).
I will once again be joining the Nashville Modern Excel User group to speak. On August 17th I will be speaking on “Using Your On-prem Data in a Cloud World” – walking through the benefits of using your on-premises data with cloud-based tools such as Power BI, Microsoft Flow, and PowerApps.
On June 22nd 2017, I will again be speaking to the Cincinnati SharePoint User Group and this time around we will be discussing workflow. I will present the options for creating workflows in SharePoint and Office 365, as well as look at the process (and potential pitfalls) for upgrading your SharePoint Designer workflows to Microsoft Flow.
I am excited to be speaking once again at the Nashville SharePoint Users Group. The meeting on May 9th 2017 is in-person and via online meeting and the topic is “Creating & Upgrading SharePoint Workflows”. The details of my presentation are below.
For a long time, we have used workflow for automating business processes in every version of SharePoint, while using various tools to create them: out of the box workflows, SharePoint Designer, Visual Studio, & third-party applications like Nintex and K2.
Now that SharePoint Designer will no longer updated and there is a push to move to the cloud, what are we supposed to do now to automate tasks and business workflow?
What if you aren’t moving to Office 365 and just want to know what tool you should use to create workflows moving forward?
Should you migrate your existing SharePoint Designer workflows to Microsoft Flow or a third-party tool? What would that process look like?
Should you continue to build workflows using SharePoint Designer in SharePoint 2010, 2013, 2016?In our time together, we will review those questions and more so you can be confident in your path forward with process automation, no matter what version of SharePoint you are using or where it is hosted!
[UPDATE] I had a great time with the group tonight. There were some great conversation concerning the gaps between SharePoint Designer workflows and Microsoft Flow. Everyone stay tuned to this space and make sure you register for the May 16th Microsoft Virtual Summit.
The fourth #SPSNashville will take place on April 8, 2017. I am honored to be working with a great leadership team and this year some of the most talented Office 365 and SharePoint technologists from the around the USA will be joining us for a FREE day of training.
We also have great sponsors who are delivering huge value in the community and will be showcasing their capabilities at our event. Check out our sponsors here.
This year, I will be co-presenting a session with Dan Evans, Microsoft Senior Technical Solutions Architect. Our session will highlight business intelligence (BI) options in SharePoint and Office 365. From Power BI, PowerApps, & Microsoft Flow, we will show you how all of it fits in with SharePoint to make a great BI solution. Our presentation is at 11:15am – join us! Register for SharePoint Saturday Nashville 2017!
Microsoft Flow is a new product from Microsoft and I am finding it to be a very useful tool. Flow can be a very convenient resource for sending email alerts when something I set as a ‘trigger’ happens. It is also a superior product to ‘IF This Then That’ products because of Flow’s ability to have many steps and conditions. Flow can be used to send email in several ways, but today I will cover how to set up a custom SMTP connection. Flow is in Preview, so some screens or options shown on this post may change.
NOTE: I am going to show how to set up an SMTP connection to GoDaddy’s email service, but any SMTP service that allows connections will work.
First, go to the GoDaddy website and log into your account. Then, click on your name (#1 below) and then select the Visit My Account link (#2 below).
Once you are on your account page, click on the Manage link next to the email listing.
Next, find the account you will be using for your email relay. Select the drop-down menu (#1 below) and then click the Email Setup Center link on the menu (#2 below).
When the Email Setup Center page loads, make note of the Outgoing server (SMTP) settings.
Then head over to the Microsoft Flow website and login. Once you have logged in, click on the person image in the top-right corner (#1 below) and then select My connections in the menu (#2 below).
Select the Add a connection link at the top of the Connections page.
When the connection types load, select the SMTP link.
Then fill out the SMTP connection settings with the information you noted earlier from the GoDaddy Email Setup Center. I am using port 80 and not using SSL encryption in the example below, but you should use security best practices when configuring your service. Click the Create connection link when finished.
Once the connection is created, create a new Flow. Create a trigger, in the example below I am checking for a Tweet. Then Add an action, and type email (#1 below). This will filter the list of actions to only show email items. Then select the SMTP – Send Email action (#2 below).
Then enter the required information for the email. In the example below, I am sending an email to firstname.lastname@example.org, with an email subject of “New Tweet Appears – [The Tweet text]”, and an email body of “There is a new Tweet by [who created the tweet]!”.
Finally save your Flow and give it a test. I have found that it might take a minute for the Flow to start checking Twitter, but you should receive an email any time the condition you set is met!