Share Point 2016 Codeless Mobile Apps,lists,Flow,Power Apps
4.3 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,084 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Share Point 2016 Codeless Mobile Apps,lists,Flow,Power Apps to your Wishlist.

Add to Wishlist

Share Point 2016 Codeless Mobile Apps,lists,Flow,Power Apps

This course will teach you how take a SharePoint list and transform it into a full functioning mobile application
4.3 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,084 students enrolled
Created by Dr. Luke Angel
Last updated 5/2017
English
Price: Free
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to create, edit, and update a SharePoint list from a mobile app with writing any code.
  • How to getting started With Share Point 2016 Workflows
  • Know How Basic Workflows In SharePoint Work
  • How To Sign up for PowerApps
  • Using custom lists as mobile back-ends
  • How to Create and manage a PowerApp with SharePoint
  • How to Formatting text in your app
  • How to modifying settings, and branding your app
  • Applying conditional formatting to a control
  • How to Sign up for Microsoft Flow account
  • How to create a workflow using Microsoft flow.
  • Viewing results in Flow Installing the PowerPoint App On Your Device
View Curriculum
Requirements
  • Have Access To SharePoint or Office 365 or the ability to sign up for a free trial Office 365
  • Be able to sign up for free accounts for Flow and PowerApps
Description

Whether you are a hard core share point user or just getting started this course has something for you. This course will teach you how take a SharePoint list and transform it into a full functioning mobile application from a mobile app with writing any code.  We will be taking two exciting new technologies from Microsoft  PowerApps and Microsoft Flow to efficiently create mobile apps and custom workflows again without needing to write a single line of code.

We will start off by creating a a custom list in SharePoint 2016, and then I’ll show you how to use PowerApps to build the base of our application. We will then fine-tune your app, showing how to modify the layout, format text, brand your app, and add use conditional formatting to highlight key areas for the user. We, then switch into Flow and see how to create a custom workflow that responds to the data entered in the app. By the end of the course you will have a fully functional PowerApp mobile application, using SharePoint 2016 custom list, following a custom Flow workflow that you can install your device. 

Lessons Include: 

  • How to create, edit, and update a SharePoint list from a mobile app with writing any code.
  • Getting Started With Share Point 2016 Workflows
  • How Basic Workflows In SharePoint Work
  • Signing up for PowerApps
  • Using custom lists For Mobile Databases
  • How to Create and manage a PowerApp with SharePoint
  • How to Formatting text in your app
  • How to modifying settings, and branding your app
  • Applying conditional formatting to a control
  • Signing up for Microsoft Flow account
  • How to create a workflow using Microsoft flow.
  • Adding data using a mobile app
  • Viewing results in Flow Installing the PowerPoint App On Your Devi


Who is the target audience?
  • Anyone who want to learn to create mobile apps without using any code.
  • People who want to learn more about Microsoft Flow
  • People who want to learn more about Microsoft PowerApps
  • People who want to learn how to transpose a share point custom list into a mobile application
  • People who want to learn more about SharePoint
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
01:08:05
+
Introduction
3 Lectures 03:16

In 2016, Microsoft released the first new toolkit for SharePoint customization in nearly a decade, Microsoft PowerApps and Microsoft Flow. These tools aren't specific to SharePoint and can be used with a wide range of products, but with SharePoint they sing. This course demonstrates how to use PowerApps and Microsoft Flow to quickly create mobile apps and custom workflows without the need to write any code at all. After creating a custom SharePoint list, we'll use PowerApps to build an application.

Welcome
01:06

his 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.

Prerequisites And Materials
01:40

There are only two exercise files that are used in this course.  If you don't have access to the online training library, then feel free to use any relatively small logo that you have in place of this file and any Excel table that you would care to use to create a list on SharePoint. 

Exercise Files
00:30
+
Workflows 101
5 Lectures 15:12

A workflow is an organizational process that has a clear beginning, some sequential steps, and then an end. And a workflow might sit at the very core of your business, like an order entry process or a shipping process to send products to customers, or could serve more of a supporting role, like a process that allows employees to submit a time sheet or request time off for a vacation. This workflow is a small simple workflow. It was designed to allow an employee to apply to be part of a management training program. This is one of those supporting workflows. In this workflow, the employee has an idea that they'd like to apply. And they fill out a form and submit that form to their immediate supervisor.

Getting Started With Share Point 2016 Workflow
01:56

This is a really interesting time to be creating workflows and forms for SharePoint because we have a number of tools that have been available and then we have some new tools. Let's take a look at the world of development tools for Microsoft SharePoint. 

Workflows In Share Point 2016
04:21

PowerApps Plan Two also includes support for the Common Data Service. So, if you need to have access to Plan Two, you have the ability also to do a free trial simply of Plan Two. For now, we will be working largely with the features that are included in both Plan One, and Plan Two. Finally, if you're using Office365, and you can't log in to PowerApps at all, it may be then that your organization has turned off individual sign up for Microsoft PowerApps, and if that's the case talk to your IT department, and ask for licensing for Microsoft PowerApps. You'll sign up for Flow in exactly the same way. Rather than going to powerapps.microsoft.com, you'll go to flow.microsoft.com, and you'll end up on a page like this, and it will also have a link at the top that will allow you to sign up. Notice that I'm already signed up for Microsoft Flow. This is how it works then, when you log in when you're already signed up. After you have signed up for your accounts for Flow and for PowerApps,

Microsoft Flow And Power Apps 101
02:01

I've created a site just for the work that I'm doing in this course, I'm working in SharePoint Online, so this is what my site looks like. Your site might look a little bit different, but find yourself in the site that you want to use for the work that we'll be doing together. If you're already familiar with this, this is a little bit of a review, if you're not familiar with this, this is one of my favorite techniques to work with Excel and SharePoint together, because anything I can model in Excel, as a list, as a table, I can then import into SharePoint and this allows me to, very quickly, create apps where users can enter information, whether that app is going to allow them to enter in SharePoint or to enter it, in this case, in a PowerApp that we're going to create from this custom list.

Create A Custom Lists With Excel
06:34

I would love to hear your feedback if you feel the course needs improvement. Can you please provide feedback directly to me so I can make this course better for you! Please don't just rate it two stars with no comment and leave. Did you know uDemy removes FREE courses with less than a 4 star review. Its a hour of FREE Content. If I stopped my life to explain something to you for a hour could you take 1 minutes to send me feedback or at the very minimum not leave poor ratings. Disclaimer: feedback is not required to take this course but is greatly appreciated. 

Please Rate This Course
00:20
+
Power Apps Beginner To Advanced
10 Lectures 32:51

 Microsoft PowerApps is a suite of Cloud-based software services that can be used to connect to many data sources, including SharePoint, which is our focus in this course. But to other services as well, all of the different types of connectors that we have for Power BI, for example, and Flow, they're all a common set of connections. Using the PowerApps services, we can create, build, publish and share applications in web settings and for mobile and it's mobile where PowerApps really shine because we can leverage the capabilities of our mobile devices, the GPS, the camera, and so on, in our PowerApps. The PowerApp components include web.powerapps.com, which we saw in the last movie.

Getting Started With Share Point 2016 Power Apps
01:29

Let's create a new PowerApp right here from the SharePoint online list. Notice that at the top in the command bar we can click PowerApps and choose Create an app. Build a custom app based on your SharePoint list using PowerApps. We are going to name our app to get started, and we're going to simply call this west inventory, and click Create. This will take a couple moments to build my app. Notice that what has opened is the web version of PowerApps studio. Which is all displayed in this second tab here in my browser. The app is being saved to my PowerApps collection and here is the first screen of my PowerApp. This is great. A quick tour to help us get started. We'll take this tour because it's a quick way to be able to understand how this interface works for the studio. First on the left we have thumbnails for the screens, and when we create a new PowerApp, by default we get three separate screens. We get a screen that's used for browsing. We see that one here. 

Use SharePoint Power App 101
03:34

basics of managing and working with your apps that you've created. First, based on your organizational role and how PowerApps is set up, you might find that every app that you create is created for you privately until you share it. In my case, the PowerApps that I create are being shared automatically, and if I want them not to be shared, then I need to make them private. There's actually two different and parallel things happening here. I have a view which is, really, you could think of it as PowerApp in the browser. But the PowerApp itself is not here. The PowerApp itself lives in web.powerapps.com. 

Manage Your App
03:52

Designing Your Power App Interface
04:52

Some additional customization we might be interested in. This is called BrowseScreen1. We have DetailScreen1 and so on. If you'd like to change the name from BrowseScreen1, you can do that. Simply on the Screen tab or on the Home tab with the screen selected, choose BrowseScreen. We could say BrowseInventory, for example. That's an internal name. It's the title here actually that bothers me because it gets cut off. It says West Region Inventory but there really isn't enough room for that in the label. I'm just going to say West Inventory, delete this. Change its name and notice, much better. I'm going to go to File and Save just to save the work I've done so far because that seems to be a good way to work in PowerApps. While I'm here though, let's take a look at the app settings. This is the West Inventory.

App Branding And Settings
05:38

The choices that were made by PowerApps about what fields, what columns of data were most important was a little different than the choices that I would make because my users aren't as focused on whether something is back ordered as they are in being able to find it in order. The same problem exists here on my details screen and on my edit screen. I'd like to be able to rearrange, to reorder, the information on this screen so that name is at the top, very first. That's the most important thing. Second then, is we have information about availability and not necessarily in stock or not in stock but the quantity that are available. How do we modify this particular screen? Well, it's super easy. 

App Detail And Edit Forms
05:05

The inventory that's maintained in this list in SharePoint is calculated based on items that are removed from inventory, purchases that are added to inventory, but there is not a visual inspection of these items most of the year. However, twice a year, we take a physical count of all of the items in our inventories so that we can reconcile the number of units available with the actual number of units that are in stock. And we'd like to make it easy, we want to create a mobile app that will do that, a PowerApp. First though, we need to modify our list by adding another column to the list. Let's go to settings, list settings, and in our set of columns, there's units available, which is number. We want to create another column, in addition to units available and that column is going to be unit count or actual count or verified count or whatever we'd like that would describe it. And it's a number, semi-annual audited count.

Updating Your App Data Source
02:28

I'd like to add the new column, then, to my details screen and to the edit screen. Let's do that then. Here are the units that are available, and what I'd like to do is I'd like to actually add another card. Simply click on any of the existing cards, scroll down to actually count. On hide it, and here it is. I'd like this right after units available. So I'm going to drag it up here. Sometimes you can catch this and drag the actual card, but I normally found it easier to drag the field here in the right pane. Now we need to allow our user to enter the actual count. Let's go here, and notice that we haven't really modified this to be in the same order, I also didn't change the name here, I should probably do that. Drop down to our details screen. 

App Forms
02:32

Here's the last spiffy little thing we're going to do to this power app, and that's to apply some conditional formatting to a control. This is the type of thing that makes an app much easier for our users. I'm going to select in the gallery, the very first item, and choose the availability, because what I'd like to do is flag if these items have been back-ordered. Now, generally, the color that we have applied here to this text is orange, and I'm going to switch it back to something a little bit duller, like a dark brown, and now they are all dark brown. Now, it's hard to make red stand out from orange. What I'm going to do is choose a color, and say if, this is going to seem really familiar, almost like Excel. If availability equals back-ordered, make sense? Comma, and they're telling about the color here.

Apply Conditional Formatting
03:01

I would love to hear your feedback if you feel the course needs improvement. Can you please provide feedback directly to me so I can make this course better for you! Please don't just rate it two stars with no comment and leave. Did you know uDemy removes FREE courses with less than a 4 star review. Its a hour of FREE Content. If I stopped my life to explain something to you for a hour could you take 1 minutes to send me feedback or at the very minimum not leave poor ratings. Disclaimer: feedback is not required to take this course but is greatly appreciated. 

Please Rate This Course
00:20
+
Share Point List Automation Using Microsoft Flow
5 Lectures 15:38
Flow 101
01:46

Flow Into Share Point List
07:28

The flow is assigned to the list, and our SharePoint list doesn't really care how we add a new record, so let's add it using our PoweApp. Better yet, let's begin using PowerApps Mobile, which I've downloaded using Itunes and I'm now logging in for the first time. So I'm going to sign in with my work or school email account, the same account I used when I logged in to PowerApps. And in a moment I'll be prompted for a password. I'll sign in. I will allow notifications from PowerApps. And even though that screen came back for login, we shouldn't worry about it because here we are.

Insert Data From The Mobile App
03:15

"transcript": " - [Instructor] When we added the new item to this list flow automatically ran a workflow. First let's make sure that we can find the item in this list. We can Search and 24-volt is going to find something for us. There's our K-Eco2 24-volt backup battery in stock three, that looks good. And what about that email? Well remember that the email was sent not just to Rodney but also to me, so if we switch to my inbox in Microsoft Outlook. Notice, new inventory item added. K-Eco2 24-volt backup battery, a new item was added at date and time by Gini Courter. Details item name, quantity. 

Read Results From Flow Actions
02:49

I would love to hear your feedback if you feel the course needs improvement. Can you please provide feedback directly to me so I can make this course better for you! Please don't just rate it two stars with no comment and leave. Did you know uDemy removes FREE courses with less than a 4 star review. Its a hour of FREE Content. If I stopped my life to explain something to you for a hour could you take 1 minutes to send me feedback or at the very minimum not leave poor ratings. Disclaimer: feedback is not required to take this course but is greatly appreciated. 

Please Rate This Course
00:20
+
Conclusion
2 Lectures 01:08

We've reached the end of this course but this is not the end of what you can learn to do to automate SharePoint.  It's been a pleasure to create this course for you. I look forward to our next learning adventure together."

Next Steps
00:48

I would love to hear your feedback if you feel the course needs improvement. Can you please provide feedback directly to me so I can make this course better for you! Please don't just rate it two stars with no comment and leave. Did you know uDemy removes FREE courses with less than a 4 star review. Its a hour of FREE Content. If I stopped my life to explain something to you for a hour could you take 1 minutes to send me feedback or at the very minimum not leave poor ratings. Disclaimer: feedback is not required to take this course but is greatly appreciated. 

Please Rate This Course
00:20
About the Instructor
Dr. Luke Angel
4.1 Average rating
1,936 Reviews
26,401 Students
18 Courses
Sr. Technical Cross Platform Program Manager

Hello!

Thanks for looking at my courses. I am excited to bring you some awesome lessons I have learned along the way. I also love to talk about my favorite products that really help me stay ahead of the curve. I am an Architect, Developer, Product/Project Manger, and humble hustler focusing on building next generation application.

I am currently working as a Sr. Technical Cross Platform Program Manager at a Fortune 500 company building technology-driven marketing solutions with global reach and Netflix scale. I lead teams of developers to new heights by giving top of the line guidance on product deliverables, organizational techniques, and in general kicking butt. I hope you find my courses enjoyable and please contact me if you have any questions or would like any additional content covered that is not in one of the courses.

I am a PMP expert and PRINCE2 consultant.