Here's a technique to display row numbers against a sorted set of data in a gallery control.
If you're struggling to access records in nested collections/tables, here's some example syntax.
Find out how to install and connect to a local SQL Server with the on-premises gateway
If you're completely new to SQL Server, this post will show you how to install an on-premise instance of SQL Server.
Both new and experienced app builders should look at Mr Dang's 'design patterns' app. Read this to find out more, and to also find out how to setup Microsoft Cognitive Services with PowerApps.
It's important to understand how PowerApps behaves in terms of case sensitivity. Here are 3 things you should be aware of.
If you want to build charts or images that can change depending on data, here are some blog posts you should definitely read.
How do you extract sections of a string? Here are some code samples that can help you.
Don't know what data source to use? Read this to find out which data source can best suit your needs.
Bulk updating SQL data from PowerApps can be very slow. Read this to find out why.
Coming soon! Guest access for PowerApps...
Before you choose to Excel as a data source, you must read this.
Before you use SharePoint as a data source, make sure to read this to find out what problems you might encounter.
PowerApps wins the PC Magazine 'Editors Choice' award.
Read this to find out how to compare against other fields whilst carrying out validation.
Here's the best sample app that shows how to page and add previous and next buttons to a gallery.
Here are the best web links to help overcome the 500/2000 row limit.
Find out how to show running totals within a gallery.
Find out how to display row numbers against records.
- Formulas - Generating Row Numbers - Part 2
- Data - How to access nested collections/tables
- SQL Server for Beginners Part 3 - Installing On-Premises Gateway
- SQL Server for Beginners Part 2 - Installing Management Studio
- SQL Server for Beginners Part 1 - Installing SQL Server
- Sample Apps– How to auto save forms, carry out translations, and much more!
- Searching data–What you need to know about case sensitivity
- Images - How to create images that can change depending on data
- Text - How to get part of a string / Splitting text by spaces
- Excel vs SharePoint vs SQL Server vs CDS
- SQL - What you need to know about bulk updating records
- Authentication - Allowing Guest / Anonymous Access
- Excel - Reasons NOT to use Excel as a data source
- SharePoint - What you need to know about Filtering Data
- Review of PowerApps - PC Magazine
- Data - How to validate input data against other fields
- Gallery Control - How to Paginate Data
- Delegation - How to overcome the 500/2000 Row Limit with Collections
- Formulas - Show Running Totals
- Formulas - Generating Row Numbers
- Missing Features - Printing
- 7 Alternatives to PowerApps
- Running PowerApps on older mobile devices
- Finding your way round the PowerApps websites
- How to get started with PowerApps – Subscription Sign-Up Walkthrough