Category: Delegation
Data - The most effective ways to get a random record or row from a data source
If you want to select a random row or record from a data source, this post summarises the syntax that we can use.
Data - Is the AddColumns function delegable?
A question that I hear on occasions is - is the AppColumns function delegable? This question often arises when app builders are unable to retrieve more than 2000 records. This post explores this behaviour in more detail.
Delegation - How to overcome the 500/2000 Row Limit with Collections
Here are the best web links to help overcome the 500/2000 row limit.
Recent Posts
- Formula - Transposing/converting rows to columns- an almost impossible task?
- Charts - How to create donut charts
- Settings - The easiest way to find environment id and other settings
- Admin - How to quarantine or block all users from running a specific app
- Learning - Learn Power Apps through the free Microsoft Virtual Training Day events (and receive a free exam)
- Formula - How to round times to the nearest x minutes
- Formulas - Review of how to write formulas using natural language
- Licensing - Microsoft 365 licensing price set to increase in March 2022
- SharePoint - Filtering lists by User() is now delegable
- Dates - How to get the start date from week number
- Data - How to remove/delete a field from a record
- Numbers - 10 examples of how to round numbers
- Dates - How to check if a year is a leap year
- Dates - How to get the week number for a given date
- Dates - How to get the nth weekday for a month
- Dates - How to get the last weekday for a month
- Forms - How to calculate values (eg sums and products) and store the results in SharePoint or other datasource
- Sums - How to calculate 'year to date' or running totals
Blog Author
|
Tim Leung Author, software developer, Power Platform specialist |