Formulas - How to calculate the distance between 2 points
We can calculate the distance between two longitude and latitude co-ordinates using a trigonometric calculation. It's a complex formula so in this post, we'll find out how exactly this works, including a verification of the result. We'll see how to perform this distance calculation in both kilometers and miles.
SharePoint - How to Patch the 6 most complex data types
With SharePoint, the syntax to patch certain data types can look very complicated. In this post, we'll summarise the syntax to patch lookup, single choice, multi-choice, yes/no, single person/group, and multi person/group columns.
Formulas - Generating Row Numbers - Part 2
Here's a technique to display row numbers against a sorted set of data in a gallery control.
Data - How to access nested collections/tables
If you're struggling to access records in nested collections/tables, here's some example syntax.
Formulas - Show Running Totals
Find out how to show running totals within a gallery.
Formulas - Generating Row Numbers
Find out how to display row numbers against records.
Recent Posts
- Location - Finding the closest location and and sorting records by distance, based on the current location of the user
- SQL - Security - How can users hack shared SQL connections?
- SQL - How NOT to name database tables, columns, and objects
- Formulas - How to cope with weekends and public holidays in date calculations
- Licensing - What license do I have?
- Dataverse - How to Patch the 5 most complex data types
- Controls - How to Transition/Show/Hide controls with a Sliding Effect
- Formulas - How to calculate the distance between 2 points
- SharePoint - How to Patch the 6 most complex data types
- GPS - 3 Frequent Questions about Location Services
- Settings - Old Layout vs New Layout (2021)
- SQL - How can we count rows accurately?
- SQL - Have you seen these Power Platform options in SQL Azure portal?
- SharePoint - Beware of numeric calculated columns!
- SharePoint – 2 Mistakes to avoid when importing Excel data
- Settings - What does the Delayed Load setting do?
- What to do when some part your app breaks, or starts behaving differently?
- 5 Tips for when you can't sign into Power Apps
- Forms - How to conditionally make form fields mandatory
- SQL - Don't let this DateTime bug catch you out!
- Settings - What's the purpose of the "Explicit Column Selection" Setting?
- 10 Great Ideas to Improve Power Apps
- What Power App features can we expect in 2021?
- Top New Power App Features from 2020
- Formulas - Generating Row Numbers - Part 2