Chapter 1. Programming in the Power Platform In this chapter, we will cover the basics of programming: properties, methods, and events. We will then look at how their implementation differs between in each of the Power Platform applications compared with traditional environments like .NET (Windows Forms and ASP.NET) and JavaScript. For Power Apps, we will see how you can set the properties of other objects directly but instead need to make the value of what you want to change (such as the text of a button) a variable and ...
Read More
Chapter 1. Programming in the Power Platform In this chapter, we will cover the basics of programming: properties, methods, and events. We will then look at how their implementation differs between in each of the Power Platform applications compared with traditional environments like .NET (Windows Forms and ASP.NET) and JavaScript. For Power Apps, we will see how you can set the properties of other objects directly but instead need to make the value of what you want to change (such as the text of a button) a variable and then change the value of that variable elsewhere in the application. We will also explore its Visual Basic-like syntax. In Power Automate, we will look at the different types of actions (variables, loop, parallel branches, conditions, etc.). Finally, in Power BI we will look at the Power Query M formula language. Chapter 2. Updating a SharePoint List Using Power Apps Chapter 3. Creating an Approval Process with Power Automate Chapter 4. Creating a Survey Response Dashboard with Microsoft Power BI Chapter 5. Creating a Survey Solution with Microsoft Forms, Flow, SharePoint, and Power BI Chapter 6. Power BI Challenges with JSON, XML, and Yes/No Data Chapter 7. Power BI Case Study: Monitoring BMC Remedy Help Tickets Chapter 8. Building a Help Ticketing System in PowerApps and SharePoint - New Ticket Form Chapter 9. Continuing the Help Ticketing System - Technician Form Chapter 10. Using Power BI for the Help Ticketing System Chapter 11. Overcoming Power Apps Delegation Issues with SharePoint Data Sources In this chapter, we look at how to use the technique described in https: //tinyurl.com/twzvbgl to overcome delegation limits in Power Apps using a SharePoint data source. We also implement a corresponding Power Automate Flow to copy the ID value to a numeric column each time we create a record. Chapter 12. Creating a Class Sign-Up Solution in SharePoint and Power Apps Chapter 13. Visualizing Learning Management Data from SQL Server using Power BI This chapter gives several examples of connecting to multiple tables in a SQL Server database in order to visualize test score, completion, assignments and similar learning management data. It demonstrates custom columns, merging tables, slicers, and much more. Chapter 14. Dynamic Information in Power Apps and Sending an Adaptive Card to Teams using Power Automate In this chapter, we create linked SharePoint lists that display status levels, colors, and associated steps. We then read these lists from PowerApps to create a status display that we display in a tab in Teams. Finally, we create a Power Automate flow so that each time the status changes, we automatically post that to our Teams channel. Chapter 15. Dynamically Setting Object Properties in Power Apps Based on a SharePoint List In this chapter, we explore how to approximate dynamic object references/reflection in Power Apps. We take an "Actions" list in SharePoint and use it to set Text, Tooltip, and Visible properties of each corresponding button in Power Apps. Chapter 16. Uploading Files from PowerApps to SharePoint and Emailing Links using Power Automate In this chapter, we see how to upload multiple attachments from Power Apps to a SharePoint document library using Power Automate. While we are in Power Automate, we create an email of links to these documents and email it to the designated recipient. Chapter 17. Working with SharePoint Lookup Columns in Power BI In this chapter, we explore how to use the FieldValuesAsText functionality in Power BI to get the data from within a SharePoint Lookup column. We also explore creating custom columns and filtering by Content Type. Chapter 18. Joining
Read Less