SharePoint Tips 🗂️
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
Read every column of a SharePoint list via the REST API, filter down to the custom (user-created) fields, and recreate the exact same columns on another site...
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
Need per-item access control in SharePoint? Break role inheritance and grant a user or group a permission level with two ‘Send an HTTP request to SharePoint’...
#PowerPlatformTip 159: ‘Force a Direct File Download in Power Apps with Launch’
Clicking a SharePoint file link in Power Apps usually opens a preview instead of saving the file. Appending &download=1 to the URL inside Launch() often ...
#PowerPlatformTip 154: ‘Preserve Author, Editor & Dates on Copied SharePoint Files’
When you have to copy-and-delete a SharePoint file, it loses its original Created By, Modified By and timestamps. One ‘Send an HTTP request to SharePoint’ ME...
#PowerPlatformTip 153: ‘Rename a SharePoint File with Power Automate’
The SharePoint connector has no ‘Rename file’ action, but you don’t need one. A single ‘Send an HTTP request to SharePoint’ call that MERGEs the FileLeafRef ...
#PowerPlatformTip 151: ‘Manage All Your SharePoint Lists in One Model-Driven App with Virtual Tables’
Stop juggling dozens of SharePoint lists across separate views and apps. Dataverse virtual tables expose your production lists in Dataverse without copying d...
#PowerPlatformTip 147: Dummy Patch After Complex Flows
Complex Flows with approvals/fallbacks updating lists? Use Dummy Patch on GalleryExample.selected + RefreshHack column for precise single-record refresh, ski...
#PowerPlatformTip 143: Reduce AI Costs with Thumbnail-First Document Processing
With AI Builder credits ending November 1, 2025, and Copilot Credits costing significantly more, organizations need smarter AI processing strategies. Process...
#PowerPlatformTip 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
#PowerPlatformTip 133: ‘SharePoint Updates with Power Automate, No Required Fields Needed’
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
#PowerPlatformTip 132: ‘Office Files Viewer in PowerApps’
Display Office files like PDFs or Word documents directly in PowerApps without external workflows or third-party tools.
#PowerPlatformTip 131: ‘ForAll & Patch Optimization in PowerApps’
Optimize Power Apps performance by using ForAll and Patch for bulk updates, reduce API calls, speed up batch processing, and handle missing IDs efficiently.
#PowerPlatformTip 129: ‘Case-sensitive SharePoint Filtering’
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
#PowerPlatformTip 123: ‘Get Lowest / Highest SharePoint ID & TotalCount’
Efficiently retrieve the highest, lowest, and total item IDs from a SharePoint list in Power Automate for advanced list analytics and data management.
#PowerPlatformTip 121: ‘Filtering SharePoint File Fields with OData’
Quickly and efficiently filter SharePoint files in Power Automate by using FileLeafRef (file name), FileRef (full path), and FileDirRef (folder) fields with ...
#PowerPlatformTip 107: ‘Last Item from SharePointList’
Efficiently retrieve the latest item from a SharePoint list in PowerApps using delegable sorting and the First function for reliable, scalable data access.
#PowerPlatformTip 110: ‘Protect SharePoint Data’
Use a SharePoint custom permission level to block direct access to lists and enforce interactions through Power Apps for improved data security.
#PowerPlatformTip 106: ‘Word & Quick Parts’
Automate Word documents for free using Quick Parts placeholders filled by a standard Power Automate flow, no premium license needed.
#PowerPlatformTip 103: ‘Quick Setup Guide’
Quickly configure dropdowns and ComboBoxes in PowerApps using SharePoint or Dataverse Lookup and Choice columns for rapid, reliable data selection.
#PowerPlatformTip 97: ‘Enhanced Pagination’
Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint, retrieve more data, improve performance, and streaml...
#PowerPlatformTip 95: ‘Optimized SharePoint Queries’
Optimize SharePoint queries in Power Automate using OData filter options, improve data filtering, workflow efficiency, and minimize processing for large lists.
#PowerPlatformTip 76: ‘PowerApps Sharing with Guests’
Easily share PowerApps with external guests using Microsoft Teams Groups for unified access, streamlined management, and secure backend integration with Shar...
#PowerPlatformTip 47: ‘Batch-Method within SharePoint’
Accelerate bulk SharePoint list operations in Power Automate using the SharePoint REST batch method. Create, update, or delete up to 1,000 items per call to ...
#PowerPlatformTip 27: ‘Overwrite existing files’ (The Settings Hack)
Enable file overwriting in SharePoint by disabling ‘Allow Chunking’, a simple settings tweak that unlocks the hidden overwrite toggle in Power Automate.
#PowerPlatformTip 19: ‘Resize files’
Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation.
Run Power Apps Connections with Elevated Permissions via Power Automate: Impersonate Flow Actions from Reza Dorrani
Learn how to enable end users to perform actions with elevated permissions in Power Apps using Power Automate’s impersonation features. Reza Dorrani demonstr...
How to Track the Current Progress of a Flow in PowerApps
Learn how to track Power Automate flow progress in real-time within your PowerApps using a StateLog table and timer controls. Complete solution with download...
Fill and Sign a Word Document with Power Apps and Power Automate without using any premium actions from Paulie M
Simply convert a Word into a zip file, replace the data a little and convert it back into a zip file -> Ingenious way to create a Word file without premiu...
Power Automate Flows vs Automate Rules: Performance and Efficiency Comparison by Daniel Christian
Explore the differences between Power Automate Flows and SharePoint Automate Rules. Daniel Christian analyzes performance implications and optimal use cases ...
PowerApps PDF Viewer SharePoint Document Library without Flow from Reza Dorrani
A great video, which replaces all the cumbersome workarounds via PowerAutomate. Here you learn how to simply ‘manipulate’ data and thus directly view PDF fil...