Next, I go into PowerApps to create my app.

He has written more than 15 books on the topic and has spoken at dozens of conferences. Join other Azure, Power Platform and SQL Server pros by subscribing to our blog. I select and connect to my Timecard DB data source and choose my Project table (conversely, when you start with data, you can only do one table at a time). If playback doesn't begin shortly, try restarting your device. If you need to learn PowerApps, our deep dive PowerApps courses in our On-Demand Learning platform will teach you all you need to know to leverage PowerApps in your organization.

In this case, I’ll have to add another connection, my Project Table Type, as a new data source. This is where the foreign keys are going to be a bit of a challenge. You need access to an existing SQL Database. I can change things like filtering and sorting or changing the sort order of the fields on my gallery screen. Brian has been working with SQL Server as a DBA and business intelligence professional since 1998. To do something about that we need to key pair – we want to show the value of Project Type ID, but then keep the key that we store in the database, so we have a key pair. One thing I don’t like is the gallery field that says Project Type ID of 1; I’d like that to say something like ‘translation services’. We need to go in and rename these so when we call out to them, we’ll know what each one is.

Using PowerApps to Read and Write to Azure SQL DB with Foreign Keys. The goal here is to communicate with Azure DB to store all our data so we can better secure it, back it up and query it in better ways later. For this demo, I’m going to create from a data source. Anything I do in the first row will be repeated in the rows below. Once complete, a negative to point out is that it uses default names on the screens that is has built, like Browse Screen 1.

Videos you watch may be added to the TV's watch history and influence TV recommendations. Then I can hit the play button to see what I like or don’t like. Security Information and Event Management, Power App Session 6 | Adding Records to our Data Sources. In this application example, we're going to start building a quick timecard application to manage projects using PowerApps and Azure SQL DB. In my gallery, I want to customize it by selecting the subtitle, which is an email and in my code bar I add the word “manager” (and “&”) so people know what that email means and so that I’m showing what that value is all about.

I want to turn the Project Type ID field into a drop-down box to which I’ll be able to add values. the final set up for the flow will ask you to define the parameters but you click on "ask in powerapps" for each parameter space. All our 50+ courses on Azure, Power BI, Big Data and much more are taught by industry experts and are taken at your pace, with Learning Paths and Learning Coaches available to help with your learning goals.