last week’s #whiteboardwednesday was all about power (apps)! here are cam’s top 5 learnings on automation using powerapps:
1. templates
Utilise the large number of prebuilt templates, readily available through the create page of the PowerApps Portal. This allows you to analyse how the template has been built when first starting out with the software, furthering your understanding.
2. connectors
PowerApps has a large number of inbuilt connectors allowing apps to connect to external data sources such as Office 365, Azure and Power BI. These data sources can then be leveraged within the PowerApp.
3. ease of build
The building of a PowerApp UI (User Interface) is essentially drag and drop, enabling an easier build through simply adding a new screen, a button, or a drop-down box.
4. limitation of data source rows and how to fix
PowerApps has a maximum limitation of 2000 rows when using non-delegable queries (meaning PowerApps must perform the query in the app rather than on the data source). By looping through records in sets of 2000 and storing them in a temporary collection with the app, you can overcome this issue for larger lists.
5. publishing results
Nathan built a simple Application in less than an hour, demonstrating the ability to easily publish a record to a SharePoint list. This showed the speed, simplicity, and ability that the Power stack possess.
An example PowerApp embracent have developed to book desks