There is limited space allocated to the tenant. To ensure business continuity and smooth ongoing operation, it is imperative to keep an eye on its usage and take relevant actions suited to the circumstances. By default a SharePoint site is allocated 25 TB by default and OneDrive for Business site is allocated 1 TB by default. These settings can be amended manually to a different quota to control SharePoint site. The script will help to proactively monitor percent used against quota for each SharePoint site.

Update A row action from Dataverse connector was not available to an older Power Automate.The requirement was to add ability to cancel an approval task created via action ‘Create Approval’ within 30 days as Power Automate flows timeout after 30 days. I noticed the action Update a Row in Selected Environment and decided to try it instead. Unfortunately it threw the forbidden error for no apparent reason with no obvious permissions to grant.

SharePoint Online has a list view threshold (LVT) of 5,000 items, which can cause performance issues if exceeded. This post provides a workaround through filtering libraries/lists to stay within this limit and avoid common problems associated with large lists. The Problem When a SharePoint library exceeds the 5,000-item threshold, various issues can arise. These include: Inability to Browse Folders Navigating through folders becomes challenging and sometimes impossible through desktop office apps (Excel, Word,etc.