Category: Sharepoint

Data - How to make a copy of a record

A common requirement is to make a copy of a record, based on an existing record. This post describes some examples of how to carry out this task, including how to copy an existing record from a form, a gallery control, and how to write formula that copies the last created record.

SharePoint - How to export and import lists and maintain lookup relationships

A common requirement is to export and import sets of SharePoint lists, and to maintain the lookup data. This post describes how to carry out this task.

SharePoint - how to fix list threshold errors when working with very large lists

When we attempt to filter large SharePoint lists, the operation may fail with the error "The attempted operation is prohibited because it exceeds the list view threshold". This post describes this error, including how to fix this problem.

Data - How to move SharePoint sites, lists, and data

SharePoint is a very popular data source with Power Apps. A common requirement is to move data and lists between sites, or different tenants or organisations. In this post, we'll walk through how to use PowerShell to carry out this task.

Code - Can we hack SharePoint ID columns to be delegable using the greater than/less than operators?

Power Apps recognise a SharePoint ID column in a peculiar way. It recognises an ID column as numeric, but does not support delegable filter operations against this type of column using the greater than/less than operators. In this post, we'll investigate whether or not we can fix this problem in code.

SharePoint - How to filter records by the current user

A common requirement is to filter SharePoint records by email address. This use case scenario often attracts many questions from app builders who struggle to implement this in a delegable way. In this post, I'll describe how to carry out this type of filtering in a delegable way.

SharePoint - Beware of numeric calculated columns!

Help! - my numbers don't format correctly or they appear with loads of trailing numbers. If we encounter this problem, a likely cause is a bug that affects SharePoint calculated columns. This post examines this issue in more detail.