Practical Power Apps deals primarily with users wanting to set up their Power Apps structure using SharePoint as the data source and Canvas Apps and Power Automate.
User support and training is also offered via Teams or other conferencing facilities. This is focussed on users wanting to use SharePoint as a data source.
The guidance for your Power Apps journey contained in this site utilises the experience gained solving user’s problems on the Power Apps Community Forum and also the development of a Power Apps / SharePoint structure over a number of years on a substantial field and office-based operation.
Power Apps is a highly versatile and powerful platform for a low-code solution to many business data gathering, storage and extraction needs. Many adopters of this platform are not professional programmers, but rather the same people who have managed data with things like Excel macros.
This site is designed to guide these users along this journey, with many useful posts under the Blog and Useful Tips sections, also indexed under Categories.
Before you start – your Data structure
Starting your app – Design and Naming
Controls and their references
Filters – combining multiple criteria
Power Apps Delegation – SharePoint
With() Statement and Delegation
Distinct values for a large list field in Combo Box Items
Multi-Choice Combo Box Filter
Opening attachments instead of needing to download
Send selected attachments on an email directly from Power Apps
Send Uploaded files on an email and include attachments
User Interface Management
Dynamically-filtered multi-select check boxes
Prevent the use of Special Characters in a Text Input
Auto-fill Text boxes based on List values
Restricting users to specified file types in Attachment control
Office365 Groups Security
Changing the Authoring Version of an App
Enter Time directly instead of using drop-downs
Choice Columns – manage content but use Text fields to store
Dynamic expanding drop-down menus
Slideshow for your Intro screen
Alternate shading in Galleries
The rogue wrap-around
Duplicating a Canvas App Form into SharePoint Integration
Using Variables when you change the standard design
Many to Many Filters
When you do not have to say true or false
Combining two collections based on order alone
Finding the newest versions of a criteria in a data set
Rounding to the nearest .5
Pasting and Patching Excel Data
Saving and displaying multi-select field with Combo Box
Show size of attachment or uploaded file
A guide to posting on the Power Apps Forum
Developer: Warren Belz