SharePoint Online (or SharePoint 2016), Excel, Microsoft Flow, and PowerApps are all used in the SharePoint 2016: No-Code Workflows course. Learn more how to use Microsoft Flow together with SharePoint in this course.
- [Instructor] This course has some prerequisites. The first is that you need to have access to SharePoint. An easy way to do this is with SharePoint Online. As a matter of fact, an Office 365 subscription includes SharePoint Online, will get you all the tools that you will need for this course. If you're not using SharePoint Online, if you're using SharePoint server 2016, then you'll need to have the ability to set up an on-premises data gateway or to work with your SharePoint admin so that that can happen and I'll talk just a little bit more about that in a moment.
Next, you need to have, out of Office 365 or out of Office, Microsoft Excel 2016 or 2013 will do just nicely. Then you'll need to have to have the ability to sign up for Microsoft Flow and Microsoft PowerApps. These are included with Office 365 subscriptions and with Dynamics 365, so if you are setting up an environment simply to work with this course, I'd suggest an Office 365 trial subscription.
If you have SharePoint Online, if you have Office 365, if you have Dynamics 365, you're good to go. A little bit more about that on-premises data gateway. You'll find the information that you will need at this bit.ly link, remember that bit.ly links are case sensitive, so it's bit.ly/wfGateway and this will take you to the PowerApps article about setting up a gateway. Even if you are the first person using PowerApps in your organization, if someone else is already using PowerBI and needed to be able to expose data for example, from sequel server, there may be existing gateways already.
Once you have your requirements in place, SharePoint, Excel, Flow, and PowerApps, you're ready to go.
- Signing up for PowerApps and Microsoft Flow
- Importing a custom list from Excel
- Creating and managing a PowerApp from SharePoint
- Formatting text, modifying settings, and branding your app
- Updating app forms and the data source for an app
- Applying conditional formatting to a control
- Creating a flow for a SharePoint list
- Adding data using a mobile app
- Viewing results in Flow