Microsoft 365 update for January 2020

In this month’s update:

SharePoint page version history, custom search pages, resize images, team site next steps panel,

Teamsread receipts, colleague joined team notifications, voice admin, Lenovo ThinkSmart, Poly CCX, Teams installed in semi-annual channel, safe links, cloud communications API, class insights, website tab for GCC & DOD, 3rd party apps in GCC

Power Appscenter of excellence starter kit, deprecation of regional discovery service, SAP ERP connector, test studio, Stream inside canvas apps

Power Automatesimplified AI Builder, UI Flows Jan 2020 update, adaptive cards actions, simplified number formatting, Flow cookbook

Power BIexport data from visual, table column/ matrix value custom URL, KPI visual formatting, conditional formatting for buttons, load more for analytics insights, DAX quarter function, data profiling, .pbids, modeling operations improvements

Relatedend of O365 video, O365 & Office.com updates, Win7 end of support

SharePoint

SharePoint page version history

This feature will allow page editors to access the version history by clicking into page details. There, they have the option to:

  • Highlight changes between the current and previous version
  • Delete older versions
  • Restore from older versions
View SharePoint page version history in modern SharePoint

Find out more:

back to top

This feature gives admins or site owners the ability to build a custom search results page. Custom search results pages can be built using  open-source search web parts from the SharePoint Patterns and Practices community or any custom web parts developed using the SharePoint Framework (SPFx).

Custom search results pages in SharePoint Online.

Find out more:

back to top

Resize images within the image web part

This is one I am particularly excited about. It really bugs me that you need some sort of Ouija board to work out what size images need to be when you are designing modern SharePoint sites.

However, you will soon be able to resize an image in the modern SharePoint experience. Images can be uploaded from SharePoint sites, their computer or an external web location.

You will soon be able to resize images from the image web part in SharePoint.

Find out more:

back to top

Next steps panel improvements for SharePoint team sites

SharePoint’s in-product help is being improved to make peoples first-run experience with SharePoint easier and actionable.

that appears at the top-right of your SharePoint team sites – to make people’s first-run experiences with SharePoint sites that much easier and actionable.

Find out more:

back to top

Teams

Read receipts in private chats

Read receipts in private chats allow senders to know when their message was read by the recipient. Read receipts are powerful, because they also allow the recipient to communicate implicitly that they are not ignoring the sender, they may just be busy and haven’t gotten a chance to read their message.

Read receipts in Microsoft Teams chats.

Find out more:

back to top

Colleague joined Team notification

You can now connect with new team members faster as you will receive a notification in the activity feed when a new colleague joins teams for the first time.

Find out more:

back to top

Voice administration in Teams admin center

Voice Administration has been added to the Teams Admin Center. If you have a Microsoft Calling Plan you will be able to search, acquire, and assign phone numbers to users. Admins will also be able to set the emergency addresses for those end-users.

Find out more:

back to top

Lenovo ThinkSmart View Joins Teams phones

Lenovo ThinkSmart View is a dedicated personal business communications device that allows users to manage their audio and video calls through a dedicated desktop device. It will now allow for conducting Microsoft Teams audio and video calls.

Find out more:

back to top

Poly CCX for Teams phones

The Poly CCS Series is a new range of native Teams phones to help users transform the way they communicate.

Find out more:

back to top

Teams installed as part of Office 365 ProPlus for customers on the semi-annual channel

The desktop Teams client will be downloaded by default for existing users with Office 365 ProPlus, Microsoft 365 Business, and Microsoft 365 Business Premium apps for customers on the semi-annual channel. With this change your users will no longer need to do a separate installation of Microsoft Teams.

Find out more:

back to top

Office 365 ATP Safe Links is now available in Teams to help protect you from accidental or malicious unsafe links by providing time-of-click verification of web addresses (URLs) in email messages and Office documents.

Office 365 ATP Safe Links is now available in Teams.

Find out more:

back to top

Cloud Communications APIs now available

Last month Microsoft announced that the MS Graph Cloud Communications APIs are now available, enabling calling and online meeting capabilities.

Find out more:

back to top

Class Insights in Teams for Education

Class insights is a new experience that allows educators to gain insight into student performance. By adding the new Class Insights tab

They can see average grades, on-time assignments, average return time, and conversation activity for their class over time.

Class Insights in Teams for Education.

back to top

Website Tab available in GCC High & DOD

Users in the GCC High and DOD tenants can now add a website tab in Teams. Leveraging this tab, users will have the ability to pin URLs as well as SharePoint links etc. for easy access to their content.

Find out more:

back to top

3rd Party Apps now in GCC

GCC customers can now use 3rd party apps in Microsoft Teams – check out the library to see if apps you already use are available to integrate. By default access to 3rd party apps is turned off.

Find out more:

back to top

Power Apps

Power Platform Center of Excellence starter kit update

Updates have been announced for the Center of Excellence (CoE) Starter Kit – a set of templates that are designed to help get started with developing a strategy for adopting and supporting the Power Platform, with a focus on Power Apps and Power Automate.

The starter kit is now split into three components: Core Components, Compliance (Audit and Report) Components and Nurture Components.

Microsoft PowerApps: Tried and tested techniques for establishing a Center of Excellence.

Find out more:

back to top

Deprecation of the regional Discovery Service

Microsoft have announced that all regional endpoints for the Discovery Service and the Discovery APIs in the Organization Service (SOAP endpoint) will be deprecated and shut down. They are replaced by a single global discovery service accessed through the existing ‘discovery’ OData V4 RESTful endpoint. 

Find out more:

back to top

SAP ERP connector (public preview)

A new SAP ERP connector for Power Apps and Power Automate is now in public preview. It allows you to connect your flows and apps to an SAP ERP system – either SAP ECC or SAP S/4HANA.

NOTE: The SAP ERP connector for Microsoft Flow and PowerApps requires the on-premise data gateway as well as the SAP .NET Connector 3.0 SDK from SAP.

Overview of the SAP ERP Connector.

Find out more:

back to top

Test Studio

Test Studio provides a way to add and manage test cases, organize them into test suites, and run them to validate that changes in the apps did not break the expected functionality described in the tests. Tests can also be run outside of the test studio in a web browser which allows you to build the automated tests into your app deployment processes.

Find out more:

back to top

Microsoft Stream videos/ channels in canvas apps

You can now showcase Microsoft Stream videos and channels, all inside canvas apps. Note, the Stream content is authenticated, so the users will need to have had the videos shared before being able to view them inside the canvas app.

Microsoft Stream videos inside canvas apps.

Find out more:

back to top

Power Automate

Simplified AI Builder in Power Automate

Released in January, AI Builder introduced a new and simplified way to use AI Models in Power Automate. It is now easier to provide your data to the AI Model, and to use the output without the need to manually transform data.

Form processing example with AI Builder.

Find out more:

back to top

UI Flows January 2020 update now available

The January 2020 update for Power Automate UI flows (preview) is now available. This is the 2nd monthly update focusing on reliability improvements that addresses feedback from the preview.

Find out more:

Adaptive cards actions update

The second iteration of Adaptive Cards actions was introduced last month, which enables you to post adaptive cards as forms, and also to wait for a response which you can use dynamically in subsequent actions. 

Next generation Adaptive Cards for Power Automate.

Find out more:

back to top

Simplified number formatting

The format number action enables you to perform a variety of number formatting options painlessly, and by leveraging number formatting patterns which exist across Power Platform services.

Simplified number formatting in Power Automate.

Find out more:

back to top

New Power Automate Cookbook!

There is a new gallery available in the Power Automate Community where you can download flows that other people have built. Similar to the Power Apps App Gallery, the Power Automate Cookbook allows you to upload a .zip file of your flow, with screenshots and extra information.

Find out more:

back to top

Power BI

Export data from a visual

The Power BI team announced last month that you will be able to export data from a visual the same way you can do it today in the Power BI service. To export the data, just like in Power BI, select More options (…) from the upper right corner of the visualization and then choose Export data.

Exporting data from a visual in Power BI.

Find out more:

back to top

Setting a table column or matrix value as a custom URL

A new conditional formatting option that allows you set a table’s column or matrix’s value as a custom URL. You’ll find this new option under the conditional formatting card in the formatting pane.

Setting a table column or matrix value as a custom URL.

Find out more:

back to top

KPI visual formatting settings

Several new formatting options have been released for the KPI visual including

  • Indicator text formatting (font family, color, and alignment)
  • Trend axis transparency
  • Goal and distance text formatting (label text, font family, color, and size)
  • Distance text formatting (label text, positive direction, font family, color, and size)
  • Adding a date label with formatting (font family, color, and size)

Find out more:

back to top

Conditional formatting for buttons

You can now dynamically set formatting for the following button properties:

  • Button text font color
  • Button text
  • Icon line color
  • Outline color
  • Fill Color
  • Button tooltip (under the action card)

Find out more:

back to top

Load more for analytics insights

When running the Analyze feature to find insights in your data, such as Explain the increase, we only run the ML models for a period of time to show you insights in a timely manner.

Load more for analytics insights.

Find out more:

back to top

New DAX function: Quarter

There is a new DAX function: Quarter. The Quarter function returns the quarter corresponding to a specified date.

Find out more:

back to top

Data profiling enhancements

Some significant enhancements to the data profiling capabilities in the power query editor, such as:

  • Multiple grouping options for the column profile pane value distriction visual
  • Filtering options within callouts for each distribution chart value

Find out more:

back to top

.pbids file format

Microsoft are releasing a new file format: PBIDS, to streamline the “Get Data” experience for report creators in your organization.

Find out more:

back to top

Performance improvements for modeling operations

Performance improvements have been made to the Analysis Services engine to speed up modeling operations such as adding measures or calculated columns and creating relationships.

Find out more:

back to top

Related

Office 365 Video retirement

O365 video is being retired with the iOS video app retiring on April 1 2020 for customers in all regions, then the web portal for all regions (except Government Community Cloud, & national cloud regions Germany & China) will be retired on March 1, 2021.

Microsoft confirm that most regions can migrate O365 video to Stream using the administration tool, find out which regions can migrate below.

Find out more:

back to top

Office 365 app launcher and Office.com updates

Currently, when people go into the Office 365 app launcher, pinned apps can be managed on an individual basis. However, these apps will not necessarily be the same from Office.com. This change unifies this, meaning users will see the same set of apps through both the app launcher and Office.com.

Find out more:

back to top

Windows 7 End of Support and Office 365 ProPlus

Windows 7 is now out of support as of January 14, 2020. Because Office 365 is governed by the Modern Lifecycle Policy, customers are required to stay current as per the servicing and system requirements for the product or service. This includes using Office 365 ProPlus on a Windows operating system that is currently in support.

Using Office 365 ProPlus on older, unsupported operating systems may cause performance and reliability issues over time. If your organization is using Office 365 ProPlus on devices running Windows 7, it’s recommend your organization move those devices to Windows 10.

Find out more:

back to top

Resources

Microsoft 365 update for August 2019

In this month’s update:

SharePointSite swap, site owners can join to hub sites, activity highlights in file hover card
OneDrivePopular around me, comments on non-office files, Samsung + OneDrive
TeamsFocus time, content cameras, meetings first, share audio, partner provided calling plans for Japan, audio conferenceing via direct routing GCC High & GCC DoD, Personal apps (developer preview), enhanced assignments Teams for Education
PoweAppsOctober PowerApps release wave videos, publishing changes to Portals, PowerApps CLI, new functions, provisioning/ admin updates, inline navigate, SharePoint declaration improvents, data source experience & CDS views, share canvas apps with guests
RelatedWork-in-progress slides in PowerPoint, direct links to PowerPoint slides, enhanced Yammer mobile experience

SharePoint

Site swap

Finally, you can make your root site a modern communication site or a modern team site! Using the new PowerShell cmdlet: Invoke-SPOSiteSwap, switches the location of a source site with another target site.

Note: the source or target sites cannot be “associated” with an Office 365 group or connected to a hub site.

Invoke-SPOSiteSwap
         -SourceUrl <string>
         -TargetUrl <string>
         -ArchiveUrl <string>   
      [<CommonParameters>]
Find out more:

Site owners can assoicate sites to a hub

Site owners can now associate their sites to a hub they have permissions to join. Previously this ability required site collection level admin privileges.

Find out more:

Activity highlights in the File Hover Card

The activity highlights shows you if someone you work with edits, comments, or @mentions you on files you’re working on. This is displayed in the File Hover Card, with a link to the relevant activity.

Recent activity in the File Hover Card
Find out more:

OneDrive

Now you can find relevant content at the top of the Shared with me view in OneDrive. Files which are recommended based on your working relationships will surface to help you find trending information faster and discover new content.

The new popular around me view in OneDrive
Find out more:

Comments on non-Office files

You can already comment on Office docs in Office on the web, but now you can comment on other file types in OneDrive on the web such as PNGs, JPGs, or PDFs. You can also comment while using the viewer in OneDrive.

Comments on non-Office files in OneDrive
Find out more:

Samsung + OneDrive

OneDrive will be natively integrated into the Samsung Gallery app, providing automatic syncing of your photos and videos and enabling new protection and cross-device experiences. The Galaxy Note10 will be the first to get the OneDrive integration, with more Samsung devices to follow.

Find out more:

Teams

Focus time

When you schedule “focus time” through MyAnalytics, Teams will automatically help you stay focused by changing your presence to “focusing” and silencing all notifications during the focus period (based on your priority access settings).

Find out more:

Content cameras & intelligent capture

The Microsoft Teams Room app has been updated to include a “content camera” feature. This detects the whiteboard in the room, crops and frames it, and shares the content with remote participants.

Microsoft Teams Rooms
Find out more:

Meetings first

Meetings First is a configuration mode that allows organizations to continue to use Skype for Business Server for their chat and enterprise voice needs, but move their meetings workload to the cloud.

Any version of Skype for Business Server is supported, though more recent clients will have a better coexistence experience. In addition, organizations need to be licensed for Teams, including Audio Conferencing if PSTN dial-in/dial-out functionality is required.

Teams Meetings First
Find out more:

Share audio in Teams

Now, you can share your audio during a Teams meeting, so all participants can hear whatever media you’re presenting.

Find out more:

Partner provided call plans for Japan

SoftBank has released their UniTalk calling plans to Office 365 customers in Japan. The Softbank Calling Plans enables SoftBank to sell and support PSTN calling services specifically for the Japanese market.

Find out more:

Audio Conferencing via Direct Routing for GCC High and GCC DoD

  • o Conferencing via Direct Routing for GCC High and GCC DoD

This feature enables participants to join your organization’s meetings using a standard phone number. Configuring this feature requires your GCC High or GCC DoD organization to use its own numbers for dial-in access and all meeting dial-outs to phones are via Direct Routing.

Find out more:

Personal apps on mobile (developer preview)

Currently in developer preview, Personal apps can extend and customize Microsoft Teams for your organization. It provides a capability for people in your organization to use 3rd party apps within Teams.

Personal apps in developer preview has been rolled out, with a a broader target rollout in the last quarter of 2019.

Find out more:

Enhanced assignment tab in Teams for Education

The enhanced Assignments tab now shows a clear view of what’s coming up next, when creating a class assignment, educators can add resources from your Staff or PLC team. Simply select Add resources on your assignment and choose it from the file picker. You no longer need to move your content between teams.

Add resources in Teams for Education
Find out more:

PowerApps

PowerApps October release wave updates!

In August the PowerApps team added videos to the release notes show casing upcoming innovations as part of the wave 2 releases. You can see the video below:

PowerApps 2019 release wave 2 overview
Find out more:

Publishing changes to PowerApps Portals

PowerApps Portals now uses the selective entity caching approach to improve reliability and performance of your portal. With this update, you can now see changes reflected on the portal immediately.

Find out more:

New features for the PowerApps CLI

PowerApps component framework can now see changes in the test harness as they are made and push components directly into an org using the CLI.

The push capability will make you more efficient because it bypasses the custom component versioning requirements and does not require you to build your solution in order to import into your development environment.

The watch capability removes the need to reload your test harness after every change is made.

Find out more:

SetFocus function

The SetFocus function gets data entered faster by having the app position the cursor in the input field where we should begin. When you go to validate, the app will take you directly to the offending entry, even if it scrolled off screen.

SetFocus function in PowerApps
Find out more:

With function

You can now simplify large formulas by dividing them into named sub-formulas, eliminate redundant sub-formulas, and easily work with functions that return records.

Find out more:

Provisioning & administration updates for Power Platform admin center

Several changes were rolled out in August to the Power Platform admin center, including:

  • Provisioning environments
  • Provisioning based on available capacity
  • Administrators can view all environments in the admin center
  • Simplified license requirements to administrator environments
  • Top table trend is now available in the capacity report.
Power Platform admin center
Find out more:

Inline navigate to all of our modern model-driven designers

To reduce the amount of clutter within your browser while building apps, Microsoft have introduced an option to open the modern view and form designers inline. To get back, you can simply press the back button in the designer.

Inline navigate for modern model-driven designers
Find out more:

Improvements to SharePoint delegation

Delegation of SharePoint complex objects and Query and filter operations on objects such as Person and Choice is now supported in PowerApps.

In addition, the DateTime and Date values are still not yet delegable, but a null value can be delegated for a DateTime and Date field.

Find out more:

Data source experience & Common Data Service views

New data source experience and Common Data Service views that allow adding data sources into the app, or creating new connections without inserting a control have been updated.

Also updated is enabling a Common Data Service entity view that can be selected in the property pane and the Items property.  The property pane will update the Items property to add the Filter function taking the the view name as the filter.

Find out more:

Share canvas apps with guests

Now in public preview, this feature enables canvas apps to be shared with guests of your organization! This enables teams of individuals made up of different organizations participating in a common business process to access the same app.

Sharing canvas apps with guests of your organization
Find out more:

Please note: there are also several updates for the PowerApps Unified Interface that I haven’t been able to list here, but you can find all the details from the link below:

https://powerapps.microsoft.com/en-us/blog/august-2019-updates-for-microsoft-powerapps/

Related

You can now transform standard shapes in PowerPoint, Word, and Excel into rough outlines that look handdrawn and convey a sense of in-progress work. Sketched Shapes is perfect for building wireframes, drafting designs, or adding an artistic touch.

Work-in-progress diagrams and slides in PowerPoint
Find out more:

You can now get a link to an individual slide from PowerPoint and share it with recipients. This will help others land on the most relevant information without having to find what you were trying to show them through a stack of presentation slides

Find out more:

Recently announced, a new Yammer mobile experience to iOS and Android devices. Some highlights include a modernized feed experience that reduces visual clutter and delivers improved readability, live events, and townhalls that you can view on the go; Seen Counts to let you know how many people have viewed your messages; and group search to cut down on search time and find the information you need.

Find out more:

Links and resources

Fun with PowerApps part 4: Creating a custom PowerApp

This is the final part in my fun with PowerApps series, in this post i’ll go through the steps involved in creating a new PowerApp from scratch and highlight some of the difference with using a template or generating a PowerApp from a SharePoint list.

You can read all the other parts in this series below:

Part 1: setting up the default gateway
Part 2: creating a data connection
Part 3: my first powerapp

Creating a PowerApp from scratch

So far we have generated our very first powerapp from a SharePoint list or library, but now we want to take it a step further and create a brand new PowerApp from the beginning to enable us to create a desktop experience.

To create the bespoke PowerApp we will need to begin in the PowerApps studio, the steps below walk through creating the bespoke PowerApp:

  • Navigate to https://web.powerapps.com/
  • In the Home screen, select Start from blank – make sure the desktop view is selected – Press Make this app

The PowerApps studio will give you some useful tips on how to create forms or galleries which are definitely worth checking out if you haven’t already!

  • On the canvas, press Connect to data
  • In the Data window, select the data connection we created earlier

  • Enter the URL of the SharePoint site you want to access
  • Once entered, you will see all the available lists and libraries you can use as the primary data source, select the one you wish to use

Conclusion

And there you are your custom PowerApp is all set up and ready to go! Of course this is just the very beginning and you now have the fun bits to come like adding all of the elements that will make up your PowerApp but from my experience I think there are a few approaches to achieve this.

My idea was to create and open up the template helpdesk PowerApp side-by-side with my custom one to get a better understanding of how to re-produce things like the totals across the top and some of the finer details that make up the PowerApp. I think doing it this way is much easier than trying to pick apart the templates as you are starting with your own data source rather than the static ones provided within the templates.

As well as the desktop and mobile experiences you now have the ability to create list forms using PowerApps too, so now there is even more fun to be had with PowerApps!

Source: https://docs.microsoft.com/en-us/powerapps/customize-list-form

Thanks for reading 🙂

Fun with PowerApps part 3: my first PowerApp

This is part three in my fun with PowerApps series where I’ll go through my personal experience of creating a new PowerApp from scratch and go through step-by-step for each part of the process…

You can read all parts of this series below:

Part 1: setting up the default gateway
Part 2: creating a data connection

Carrying on from my last post – creating a data connection, we are now good to go and begin to build our first PowerApp!

Just like setting up the data connection, creating a PowerApp can be a really simple thing to do.

However, I’ve found either creating a PowerApp from the SharePoint list or library is really quick and easy, but it doesn’t necessarily give you the most flexibility when it comes to wanting to do it your own way…

Creating a PowerApp

You can create a PowerApp from a list or library literally from the push of a button! Its as simple as:

  • Create your list or library, add all the associated columns and data you wish to be displayed in your PowerApp
  • Press the ‘PowerApps’ button on the list menu, then press ‘Create an app’

  • You’ll then be prompted to create your app, start by giving it a name and press ‘Create

After a few moments your app will be created! It will open in the PowerApps web editor and you should see your list columns and data displaying in your shiny new PowerApp!


You can also take a look at the app in the preview to get a good look at how it operates and how the data is displayed…

Conclusion…

That’s it! Your all set…but if you’re like me you’ll have some questions. Like, what if I want a desktop app and not a mobile one?

Well for that you’ll need to build an app from scratch, I’ll be going over creating a new PowerApp in the next part of this series so hold on as i’ll be posted the next part very soon!

Fun with PowerApps part 2: creating a new data connection

This is part two in my fun with PowerApps series where I’ll go through my personal experience of creating a brand new PowerApp from scratch and go through step-by-step for each part of the process…

You can read part 1 of this series below:

Part 1: setting up the default gateway

Continuing on from my previous post – setting up the default gateway, we should now be in a position to create a new data connection within PowerApps. On the surface this is pretty easy to do, all that’s needed is to choose the connection type – press create – authenticate – job done!

However, when we need to create a data connection for an on premise SharePoint environment, its a little bit of a different story. Here are the steps involved for setting up a new data connection for a SharePoint on premise environment:

  1. Go to web.powerapps.com
  2. Under Connections – press New Connection

  3. In the search bar, search for “SharePoint” – press the plus icon

  4. The SharePoint data connection popup box should appear, under “how do you want to connect to your data?” select Connect using on-premises data gateway
  5. Set the authentication type to Windows and then specify your username and password (you may need to include a domain name as part of the username)
  6. I used credentials of a user that had owner permissions for the SharePoint environment I connected to, it makes sense to me that the account you specify here would at the very least need to be able to read/write to the SharePoint list that acts as the data source.

  7. Choose the gateway we set up in part 1 of this series, if you can’t see it you might need to install it again or refresh the list until it displays.
  8. I actually had to create the default gateway using a different account than the one I created my first PowerApp with, so it wouldn’t show for me initially. I had to share the gateway I created and set my PowerApps user as an admin for it to show in this list.

  9. Press Save

You will now see your newly created data connection appearing in the connections list! Your able to edit and delete the data connection at any point and can also check who the owner is, the connection name and crucially the status of the connection under the details button.

BONUS

There is also this article from Microsoft talking through connecting to SharePoint from PowerApps that lists the known issues with certain column types:

https://docs.microsoft.com/en-us/powerapps/connections/connection-sharepoint-online

Fun with PowerApps part 1: setting up the default gateway

I’ve recently been playing with PowerApps for the first time, I set myself a challenge of creating an IT service desk in PowerApps using a SharePoint 2016 on premise environment as the main data source.

So before I start going through all the steps I found were needed for me to setup the default gateway, this article from Microsoft is a great place to start and contains most of the steps I’ll go through below:

Setting up the default gateway

  1. Download the gateway installer here
  2. Run and begin the install of the default gateway, this can be installed anywhere that is able to connect to the server name provided. Press Next
  3. Specify the install location for the gateway and accept the terms of use. Press Install

  4. Enter the email address you wish to use with this gateway. On the next screen of the wizard, press Sign in


  5. Select Register a new gateway on this computer, press Next


  6. Give your new on-premises data gateway a name, enter a recovery key and confirm it. Press Configure


  7. In the PowerApps Studio, under Gateways you should now see your Gateway listed
NOTES

I found that the internal firewall where I had setup the gateway was blocking connections, in my case the system admin allowed these connections and it worked a treat!

I also found that the 365 account used to register the default gateway needed a Power BI license assigned to it to be able to connect to a SharePoint on premise data connection.

I’m planning on doing a series of posts over the next few weeks on my fun with PowerApps so part 2 will be coming soon!