Getting started using PowerApps can also involve learning how to plan apps, and prepare dependencies. In this hangout, we'll build a Giving Campaign application where we'll set targets by clarity name, then we'll track the employee drive to collect contributions from celebrities. Our data source will be SharePoint, where we'll build two lists (Parent = Contribution Targets, with Child = Donations). We'll discuss and demonstrate using Lookups in SharePoint as well as how to roll-up reporting using expression based calculations as well as Power BI. In just two hours we'll have an end to end solution!
P.S. I forgot to show you the experimental feature for showing the column display names in formulas, rather than the internal column names. If you open any app and click the File menu, then select App Settings - you'll find this option (shown below):
Other Promised links (also see attachments):
SharePoint Lookup Columns: https://support.office.com/en-us/article/Create-list-relationships-by-using-unique-and-lookup-columns-80A3E0A6-8016-41FB-AD09-8BF16D490632
Default Values for SPO Columns: https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Filter, Search, and Lookup Functions: https://docs.microsoft.com/powerapps/maker/canvas-apps/functions/function-filter-lookup
Mathematical functions like Sum: https://docs.microsoft.com/powerapps/maker/canvas-apps/functions/function-aggregates
Counting Functions: https://docs.microsoft.com/powerapps/maker/canvas-apps/functions/function-table-counts
How to configure relative positioning for apps easier to edit: https://www.youtube.com/watch?v=Wan4ryYsgrY
