Powerapps Editable Data Table








	When you're creating your PowerApps from the SharePoint, by default the PowerApp only render the data from the single list that where we are in. The gallery will have to be designed to have the fields that you want in the repeating table. A single row is always selected in a Data table control. Here's a first look at how they compare. Create a new table by selecting the data and Insert - Table. PowerApps: Caching lookup tables to improve performance Lookup tables can slow down app performance significantly. How Create Editable Excel Like Table in PowerApps Stephen Homa. , as well as towards external data sources like Salesforce, Dropbox, and Google Drive. Azure Table Storage. Show, edit, or add a record in a canvas app. To have some name values to filter I just set the Items property to ["Martin Wölzmüller", "Otto Walker", "Christian Gut"] Of course you can fill the drop down items to any data source you want. If you're new to PowerApps, be sure to read my brief introduction to PowerApps HERE. Select you want to create a new app. How PowerApps works offline? While a copy of the application is cached in the mobile device, working with data offline is possible through Collection which could be synced to remote data sources when online. There are two ways to create a PowerApps—either you create a PowerApps from scratch using the PowerApps designer, or generate the PowerApps automatically. This can generally be seen as an alternative method to pagination for displaying a large table in a fairly small vertical area, and as such pagination has been disabled here (note that this is not mandatory, it will work just fine with pagination enabled as well!). 	Today I will show how I've worked around its limitations to make Dynamics 365 lookup fields easily viewable and editable in PowerApps. In this way, we can create a collection. It's a rather weird issue, but I can't seem to get any data edited whether it be text, columns, or rows to update in the app. Once the variable is set, we then use it on the data card as the Update value. Consult the documentation on data sources for PowerApps if you plan to use different data sources. Fewer options (for now), but quick and easy creation. Here is the Excel Table we will use with the links to the AMS video URLs: From PowerApps, choose Content > Data sources. The first step of pulling data from the cloud is completed by creating a connection. The data source that we will be using for this post is a simple excel file stored in One Drive for Business. Dimensions and Fact tables are the two essential parts of. Edit, Create new record for a Data Source. I'm hoping that by the time most people read this, native support for filtering and sorting the new Data Table control in PowerApps will be released, but since some users may be wanting this functionality now, here's a quick guide to adding sorting to your columns: In my sample app, I have added a Data…. The gallery will have to be designed to have the fields that you want in the repeating table. Notice: Undefined index: HTTP_REFERER in /home/forge/shigerukawai. A recent addition to the product is the ability to create PowerApps through the browser interface. This example shows the DataTables table body scrolling in the vertical direction. 		Sound good? Let's begin … 1. PowerApps is an enterprise service for innovators everywhere. More importantly, developing PowerApps does not require any software development skills. How PowerApps works offline? While a copy of the application is cached in the mobile device, working with data offline is possible through Collection which could be synced to remote data sources when online. Further, you will learn how to automate business processes using Microsoft Flow, and then we explore Web API, the most important platform update in Dynamics 365 CRM. What is a repeating table? A repeating table, or sub-table, is a way to display data from two or more lists. Can anyone suggest me how to do that. The app can be modified in many ways, but we will run it either by the triangle or by F5 button. Tagged with InfoPath, Office 365,. Add the Preferred Method of Contact optionset to EditScreen1. The business problem I wanted to fix was as follows: I only want to show rows where a count of a field for a given row is equal to zero I want to filter the. There are several ways to import and export data from PowerApps. Blank Screen. …First, connected data sources…that are data that is stored some place in the Cloud. Get PowerApps to create, use, and share custom business apps with your team and organization. Data Flow Overview via CDS. PowerApps Connectors. Finally, we'll check the PowerApps functionality and configure an email to be sent from Microsoft Flow. The configurable data integrator feature of the CDS is the first step towards integrating. 	More importantly, developing PowerApps does not require any software development skills. This could range from databases to file storage locations. On-premises means that your data is stored on a server physically located within your organization, not in the cloud. PowerApps and Flow Training Overview. I have rendered a SQL view in PowerApps in the form of a data table. Editor does not require Buttons in order to function, as shown in this example where edit and delete links are shown in the table and the 'new' option is a link at the top of the table. Only for Dynamics 365 for Operations more than 60 PowerApps are avialable at the moment. We’ll explore the capabilities when building an app using PowerApps Studio. The screen is nothing but the visual front end of an application designed for user interaction. Once on a screen, the Data table can be found in the Insert tab:. We are building a PowerApps screen with a data table using a collection as the data source for the Items property. This example shows how easy it is to add searching, ordering and paging to your HTML table by simply running DataTables on it. - [Narrator] Most of the PowerApps that we create…will use some kind of information…outside of the app itself called a data source. but, when I restart the power app and power bi services there is no data in this schema. Data Flow Overview via CDS. We have to choose the table name (RankSheet), which was given in the Excel file and click the Connect button. Get PowerApps to create, use, and share custom business apps with your team and organization. 		The form has 4 fields, the other three fields are just default data cards, the last is a choice field, but since I don't want just the text, I wanted the design of the Icon/Title/Description, I changed the data source to another list in which it's "Title" is the same value as the "Choice" column on the main list. Starting a group is an excellent way to exercise your leadership skills and gain extra perks as a leader. Create a new On-Premise gateway connection. In below screen shot you can see that I have created a "States" custom list. Add Collection. An entity is essentially a table in a database that helps you manage the data getting pulled into your app. Nice quick hits. PowerApps displays SharePoint List data in an interactive form from mobile devices. Checkbox "my table has headers. All in about 1 minute. One of the great strengths of the platform is to provide connectors towards Microsoft world: Office 365, SQL Server, Azure, etc. Recently I was looking into the On-Premises gateway for Powerapps functionality and how we can send data to on-premise sql database. But there is a lot. First of all, we want to set a data source and item that PowerApps has a relation to and can work with. The same is true whether I check in editor, in the play section, or even upon app deployment. I have created a simple table, with column 1 replicating fields from another table and then column 2 with desired names so I can classify the data as I want. Show items of different heights in a PowerApps gallery Show, edit, or add a record from a table in PowerApps Show information about a PowerApps user Add a list box, a drop-down list, or radio buttons Show data in a line, pie, or bar chart in PowerApps Using multimedia files in PowerApps. In PowerApps, managing the screen. " Save this file to OneDrive. 	In this article, we are going to see “how to create blank powerapps with excel as data source”. This example shows the DataTables table body scrolling in the vertical direction. I use sharepoint Lists as my data table. I have used Azure SQL database. Install PowerApps for Windows to: • Use apps that were shared with you • Create custom-built apps Create apps that: • Help coworkers automate tasks and get more done • Empower your team to get work done from anywhere—on any device • Connect to business data, whether on the web, on-premises. Info: This is only one way of how you do the data retrieval in PowerApps. Fewer options (for now), but quick and easy creation. In this post, you'll learn how you can translate the concept of sub-tables, or repeating tables, or sub-grids, to PowerApps. There is no solution yet for SharePoint. Click on the Data table from Insert tab. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. One of the great strengths of the platform is to provide connectors towards Microsoft world: Office 365, SQL Server, Azure, etc. Here's how. I apologize for my "newbieness," just can't believe I can't figure out this simple task. Connect to PowerApps maker portal using your Dynamics 365 credentials. Let the technician create a new list item and fill in the metadata. Orange Box Ceo 7,004,597 views. 		Select the cloud you store the file in: Select the file:. Please see Part One for info on the SQL Server database design and how the screens below were created. We are building a PowerApps screen with a data table using a collection as the data source for the Items property. Show, edit, or add a record in a canvas app. PowerApps mainly focuses on lookups and variables that are linked to data sources that reside elsewhere. As a PowerApps consultant and trainer, the most frequently misunderstood thing I have seen with PowerApps is the difference between the Filter, Lookup and Search functions and when to use each one. Most PowerApps rely on a data source you must create, like a SharePoint list, an Excel document, a CDS Entity, or a Flow. First of all, we want to set a data source and item that PowerApps has a relation to and can work with. With the introduction of PowerApps, users have found most of what they loved about InfoPath, plus some improvements. These techniques may appear straightforward but beyond the simple task of working with a single table of data, there are some difficult challenges that we can face. The #1 Rule for Using PowerApps with SQL Server. You'll see the data. Jason Bonello - Jason's blog - Even if PowerApps truly is a low-development option for building applications, it would still be important to approach application development with best practices that are normally applied in other development technologies. On the left side there are three basic sites - overview, detail and edit. Filter PowerApps Gallery Using a Drop Down Control. 	PowerApps designer is used to manage PowerApps. Start a new User Group. Step 10 Adding the Table Name Here, they list out the tables present in your table.   In truth, it should be referred to as a "JSON Object" for clarity. Now you can select the server and then the table. UpdateAuditLog_20190528. An Excel spreadsheet is a quick way to load the data to the app. text property of a field it is not going to do anything. …First, connected data sources…that are data that is stored some place in the Cloud. If you're new to PowerApps, be sure to read my brief introduction to PowerApps HERE. This Intro to PowerApps and Flow presentation gives a high level overview of Microsoft's latest forms and workflow tools. Yet, with any software there’s always a learning curve. In our onVisible event of the screen we create the collection like this: ClearCollect( collTrackedSales, Filter( eBayIT_Item_Management, TCode = "A02" ) ). As "cool item" we're receiving new data connectors for Dynamics 365 and SalesForce, so, why not PowerApps and Flow?. Local PowerApps User Groups are a great way to network, grow your skills, discover opportunities and have FUN. 		Search form. Click on the Data option of the property pane. PowerApps designer is used to manage PowerApps. Figure 5 - the Preview button. A recent addition to the product is the ability to create PowerApps through the browser interface. The most common use case is to simply click on the cell you want to edit and then hit return once the edit is complete. Once selected, set the data source and the fields that should be displayed. Create a new On-Premise gateway connection. You can join them by common fields. Especially with the new "Rule" feature in PowerApps(which keeps remembers me of InfoPath form 😏) But, Then I was looking for People picker control in this latest PowerApps update. Below are a few ways you can start using variables immediately in your apps. @LauraOnu thanks for the tip on the Date/Time cards, I had seen it and tried it once. Setting up a flow to send data to the On-Premises database. Navigating The PowerApps Builder User Interface. From the PowerApps menu select Insert, Forms, and select Edit, because we want to be able to edit the data in the form. Microsoft PowerApps allows people, without any development skills, to build applications that are mobile friendly on top of their data. I have rendered a SQL view in PowerApps in the form of a data table. Show, edit, or add a record in a canvas app. When you're done, the data card's properties view should look like this: The resulting edit screen will now show the possible lookup values in a drop-down menu. 	PowerApps mainly focuses on lookups and variables that are linked to data sources that reside elsewhere. PowerApps creates custom business apps for web and mobile devices that help you do your job more efficiently and collaborate better with your co-workers. i used the term “schema” for the table and labels that have been defined in the htmltext box, text box for email,email icon. Office 365 PowerApps Deep(ish) Dive - Part 1 Even though PowerApps is still in Preview, it continues to Evolve at quite a rapid pace. PowerApps introduced the Data table control on May 5, 2017. Forms - if you wish to include a form that houses a desired set of fields that are pulled from a data source, use either the edit or display forms. The SharePoint connector in PowerApps is extremely useful to mobilize your workforce and give them access to SharePoint data on the move. 1) Create a user mapping table in an Excel file and store it in One Drive for Business (I am using Excel file stored in One Drive, but this could be any of the data source that PowerApps can read/write from and Power BI can read from). Now available. Sign into your Storage account to create, update, and query tables and more. text property of a field it is not going to do anything. Check the following link to know more about PowerApps. Building PowerApps using data from a Custom Connector. Note: You can find PowerApps Use Cases here. A variable in Microsoft PowerApps is used with the function UpdateContext. 		Only for Dynamics 365 for Operations more than 60 PowerApps are avialable at the moment. I'm hoping that by the time most people read this, native support for filtering and sorting the new Data Table control in PowerApps will be released, but since some users may be wanting this functionality now, here's a quick guide to adding sorting to your columns: In my sample app, I have added a Data…. When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. To display the data in a tabular format, I have used a. After creating a connection, the next step is to create a PowerApps. Sound good? Let's begin … 1. I am able to display text value of the lookup field on the form using Lookup() function. Connect to PowerApps maker portal using your Dynamics 365 credentials. If you allow PowerApps to auto-create an app from your list, it’s a simple process to create, edit, and delete new items from that list. Updating a Data Card from a Button. To enable a record to be edited, you must link the selected row in the Data table control to an Edit form control or another control that supports updating data. Returning tables of Data. PowerApps: Repeating section with editing In this post I will build a repeating section in a simple PowerApp. PowerApps is a great tool, included in most Office 365 licenses, to create simple apps that store data into backend tables, like Excel, a SharePoint list or a SQL Server table. Both Google App Maker and Microsoft PowerApps seek to offer their enterprise customers an alternative to mobile app development through traditional programming. 	Connect to your Dynamics 365 tenant by selecting +New connection. These Form Controls have different Modes: New - To add a New Item to your DataSource Edit - To Edit an Existing Item in your DataSource Display - To View data in your DataSource. In PowerApps, data control labels come from the data source, for example, the header row from an Excel table, or column headings from a SharePoint list. Editing the Optionsets in PowerApps The above solution can show the text, but won't let the user edit the values in the app. Forms expect a record object so we need to use the First function to convert this table of one row to a record. Now that I have a data source, I can add a form to my app and connect it to the data source I just added. Notice: Undefined index: HTTP_REFERER in /home/forge/shigerukawai. php(143) : runtime-created function(1) : eval()'d code(156) : runtime-created. A PowerApps Gallery control isn't any better - merely showing a blank record. It contains standards for naming objects, collections, and variables, and guidelines for developing. Step 10 Adding the Table Name Here, they list out the tables present in your table. However, you can gather data just fine when using the. Learn about data forms. Creating a new CDS for Apps environment. All in about 1 minute. 		Nice quick hits. Working with files; Databases. The table itself, is pretty simple - four columns and multiple rows. The Data table control in PowerApps is an easy and quick way to display data in a tabular format on an app created in the platform. Select the data card control and set its update property to DataCardValue22. Select Data Cards to be added to Product Detail form. On-premises means that your data is stored on a server physically located within your organization, not in the cloud. To keeps thing easy to understand, we. Dynamics 365 subscription. The created flow already has a PowerApps trigger that does not require any configuration (the binding from the PowerApps form to the Flow is automatically generated). To import sets of related data, how do we maintain the linkages between parent and child records?. php(143) : runtime-created function(1) : eval()'d code(156) : runtime-created. Get PowerApps to create, use, and share custom business apps with your team and organization. Fewer options (for now), but quick and easy creation. The easiest method of saving RTF data from a rich-edit control was to first save the contents of the control to disk and then write that file's contents to a BLOB (binary large object) column. Along the way students will learn to build a canvas app for mobile devices that reads and writes customer data to a table inside an Excel workbook in OneDrive for Business. cant find any straight forward control thought. Click on the Data table from Insert tab. 	There is no solution yet for SharePoint. So, let's understand this now. This video demonstrates unlocking and editing data control labels. Install PowerApps for Windows to: • Use apps that were shared with you • Create custom-built apps Create apps that: • Help coworkers automate tasks and get more done • Empower your team to get work done from anywhere—on any device • Connect to business data, whether on the web, on-premises. Before read the article go through the Introduction to PowerApps and Creating Template with it. As "cool item" we're receiving new data connectors for Dynamics 365 and SalesForce, so, why not PowerApps and Flow?. Creating the PowerApp. Read on to find out how to add an option set, integrate data from other platforms, and modify app settings to get more out of PowerApps. Powerapps upload file to sql server. Show, edit, or add a record in a canvas app. Here we will see, How to setup the On-Premises gateway. Creating a new CDS for Apps environment. This section provides information about capabilities that are supported and capabilities that aren't supported. Now Select Connection and choose a dataset from that Connection. …We connect to these data sources by using a connection. Take your data to the next level with the. Here are the steps to do the same. The #1 Rule for Using PowerApps with SQL Server. It allows you to add child items from any master form, including a new one, and bind them automatically with a lookup field. 		But as the product matures, I am hopeful that shortcuts will be implemented to make these common scenarios less cumbersome to address. In this example, we'll modify an edit form to add this type of validation to start date and end date fields. daily proxy September 27, 2017 at 9:10 am - Reply. An Excel spreadsheet is a quick way to load the data to the app. The process of creating an HTML table is similar to the process that you used to create your web page and any elements that you may have already included in your page, such as links or frames. We shall walk you through the steps involved in connecting on premise SharePoint 2016 and SQL 2016 to Office 365 using On-premises data gateway and accessing the on premise data via PowerApps. This example shows how easy it is to add searching, ordering and paging to your HTML table by simply running DataTables on it. I have rendered a SQL view in PowerApps in the form of a data table. This is because the lookup is performed by going back to the server every time the data is needed. You can even use Microsoft Flow within PowerApps. PowerApps will begin using your Excel file to create the App. Invoke the Flow from PowerApps. PowerApps is building the app out of the box with three screens: browse, detail and edit. Click on the icons below to learn about all the actions and triggers that each services provides. The created flow already has a PowerApps trigger that does not require any configuration (the binding from the PowerApps form to the Flow is automatically generated). With Access Web Apps retiring in April, it couldn't be a better time to switch over to SharePoint and PowerApps to work with your data. You can view and, in some cases, edit the field properties on the Fields tab of the Layer Properties and Table Properties dialog boxes. With the introduction of PowerApps, users have found most of what they loved about InfoPath, plus some improvements. 	If we choose the same data source as we used in the gallery then we can certainly we the data and place it on the form, but updating the record or creating a new one could prove a bigger challenge. How can this data be consumed? This is out of scope for this article, but some of the ways Azure Storage Tables can be consumed are PowerBI and PowerApps. Show items of different heights in a PowerApps gallery Show, edit, or add a record from a table in PowerApps Show information about a PowerApps user Add a list box, a drop-down list, or radio buttons Show data in a line, pie, or bar chart in PowerApps Using multimedia files in PowerApps. This PowerApps and Flow training course teaches attendees how to build advanced business solutions using PowerApps and Microsoft Flow. In this session, I'll show you how to setup a series of drop-down menus were the list of available values is based on the value selected in the first dropdown. com/public/qlqub/q15. Delegation permits the data processing to be done on the datasource's end, and get only the required data back to the application, in order to avoid shifting all the data in the application itself and process it within. ,  you need great tools to edit data in lists and libraries. Additionally, PowerApps can connect to multiple data sources to provide an intuitive experience for your users. Connect to your Dynamics 365 tenant by selecting +New connection. @cwayne758 Yes, you can edit the data at any time. Show, edit, or add a record in a canvas app. Microsoft Flow has a lot of assumptions around JSON built into it. Create a PowerApp for a list in SharePoint Online. Install PowerApps for Windows to: • Use apps that were shared with you • Create custom-built apps Create apps that: • Help coworkers automate tasks and get more done • Empower your team to get work done from anywhere—on any device • Connect to business data, whether on the web, on-premises. PowerApps Repeating Tables like InfoPath Part 2 – View and edit the data. 		The following figure shows a Sales Projections worksheet for which a one-variable data table is to be created. Create a Microsoft Flow to use the captured data, enrich it with HTML, and convert it to PDF. Table Storage is a NoSQL key-attribute data store, which allows for rapid development and fast access to large quantities of data. Connect PowerApps to Data Entity. Notice: Undefined index: HTTP_REFERER in /home/forge/theedmon. First thing first, adding and deleting columns should not be difficult. This blog post highlights how one can create a PowerApps Canvas app to create an editable table to interact with the data in the database quickly without having to connect through a separate interface. Let the technician create a new list item and fill in the metadata. Microsoft PowerApps has dozens of prebuilt entities for various commerce and sales use. Show items of different heights in a PowerApps gallery Show, edit, or add a record from a table in PowerApps Show information about a PowerApps user Add a list box, a drop-down list, or radio buttons Show data in a line, pie, or bar chart in PowerApps Using multimedia files in PowerApps. The steps below for creating a one-variable data table follow a specific example (rather than using generic steps) to help you understand exactly how to use this feature in your worksheets. PowerApps are a solid avenue for getting the most out of your Dynamics 365 subscription. This action is used to remove the empty element we get at the end when creating the data string in PowerApps. Below the "Split Images" action, add a "Filter array" action. Tagged with InfoPath, Office 365,. 	When you're done, the data card's properties view should look like this: The resulting edit screen will now show the possible lookup values in a drop-down menu. Edit queries - select the table - in the Applied Steps section click on the Gear next to "Source" and it will pop up your manually built table and you can modify/add/remove values and save. </p>. You have a Browse screen that includes some search functionality for the records, a Detail Screen to get a more granular view of the data, and an Edit Screen to make changes to the data. The SharePoint connector in PowerApps is extremely useful to mobilize your workforce and give them access to SharePoint data on the move. The Microsoft Flow and PowerApps Training is a 100% Online video course which allows you to learn at your own convenient time. Ultimately, Flow automatically escapes. Connect to your Dynamics 365 tenant by selecting +New connection. As with an edit form, edits made in a table affect the record in the database immediately for each field (as soon as you press Enter, click outside a field, or make a selection). HTML (DOM) sourced data The foundation for DataTables is progressive enhancement, so it is very adept at reading table information directly from the DOM. Note: You can find PowerApps Use Cases here. One of the most-used features in InfoPath was the ability to repeat tables, and happily, you can still do that in PowerApps. What is a repeating table? A repeating table, or sub-table, is a way to display data from two or more lists. PowerApps data not loading in OnStart Jeremy Hancock PowerApps , Uncategorized August 17, 2018 0 Minutes I created a PowerApp which loads a SQL table in the OnStart event and stores it in a Collection. Students learn advanced techniques, including writing complex expressions for PowerApps and Flows and accessing REST-based data sources using custom connectors. This example shows the use of the create() , edit() and remove() API methods, which are activated when required by standard jQuery events. Another scenario that is now possible is to use a flow to get a table of data — either from SQL, Excel, or another data source. php(143) : runtime-created function(1) : eval()'d code(156) : runtime-created. The simple Respond to PowerApps action only allows you to return back basic strings of data. To keeps thing easy to understand, we. 		One of the great strengths of the platform is to provide connectors towards Microsoft world: Office 365, SQL Server, Azure, etc. An entity is essentially a table in a database that helps you manage the data getting pulled into your app. Datatable select dropdown list. …First, connected data sources…that are data that is stored some place in the Cloud. Skip to main content. As a PowerApps consultant and trainer, the most frequently misunderstood thing I have seen with PowerApps is the difference between the Filter, Lookup and Search functions and when to use each one. Powerapps disable button if. PowerApps is a service for building and using Custom business applications which connect to your data and work across the web and mobile without the time and expense of custom software development. We can connect to SharePoint and make custom apps using PowerApps in two ways. i used the term “schema” for the table and labels that have been defined in the htmltext box, text box for email,email icon. Microsoft PowerApps has dozens of prebuilt entities for various commerce and sales use. Create a new On-Premise gateway connection. So that I can edit my data in the same field not in edit form. The Microsoft PowerApps Office Add-in enables data connections to Microsoft PowerApps systems In Excel, the Microsoft PowerApps Office Add-in allows users to read, analyze, and edit data from Microsoft PowerApps (Common Data Model) and publish data changes back to Microsoft PowerApps OData services. Add Edit Form; An empty form will be added to the form. Forms expect a record object so we need to use the First function to convert this table of one row to a record. Query them with SQL. 	We start where we left with creating the form screen and add a drop down field. Now, the next question is how to ADD/EDIT/Remove in the collection. The Dynamics GP Blogster provides third-party resources to help you find other services and/or technical support resources. Now you can select the server and then the table. PowerApps creates custom business apps for web and mobile devices that help you do your job more efficiently and collaborate better with your co-workers. This is a guide on all the services you can connect using Microsoft PowerApps and Microsoft Flow. In this way, we can create a collection. Tip: If you made some or all of the fields in the table editable, you can edit data in the table. Install PowerApps for Windows to: • Use apps that were shared with you • Create custom-built apps Create apps that: • Help coworkers automate tasks and get more done • Empower your team to get work done from anywhere—on any device • Connect to business data, whether on the web, on-premises. Both have the same set of prebuilt connections. When marking a table as a date table, you must select a date column to be used as a primary date column. Show, edit, or add a record in a canvas app. css File for displaying SharePoint List data in tabular format. Office 365 PowerApps Deep(ish) Dive - Part 1 Even though PowerApps is still in Preview, it continues to Evolve at quite a rapid pace. Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. PowerApps is an enterprise service for innovators everywhere. We can connect to SharePoint and make custom apps using PowerApps in two ways. Presented at Tulsa Tech Fest 2017 in the Office 365 Track.