Power Automate

Power Automate

How to Delete Excel Files Locked After Editing in Power Automate: 6-Minute Wait Solution

Here's how to handle an error that occurs when trying to delete Excel files used in Power Automate flows.Error: "File is...
Power Automate

Complete Guide to Power Automate Excel Online (Business) Actions: How to Manipulate Excel Files in Flow

I needed to manipulate Excel files stored in SharePoint document libraries, so I researched the available Excel actions....
Power Automate

How to Format Dates and Times in Power Automate: A Guide to Functions and Time Zones

Power Automate allows you to transform date data into various display formats. Here's a summary of how to achieve this e...
Power Automate

Power Automate: Advanced DateTime Filtering in SharePoint Lists – Complete Guide

This article continues from our previous guide about date-only filtering, focusing on DateTime columns (including time c...
Power Automate

Power Automate: Date Filtering in SharePoint Lists – Complete Guide with Examples

Let me share my notes on how to filter SharePoint Online list items using "Date and Time" columns, as I often need to re...
Power Automate

Complete Guide to OData Operators in Power Automate: Filtering SharePoint List Items

When setting up filter queries in Power Automate's "Get Items" action, you need to specify them using OData filter query...
Power Automate

How to Call Power Automate Flow with ‘When a HTTP request is received’ Trigger Set to ‘Any user in my tenant’

When I set up a Power Automate HTTP request trigger with "Any user in my tenant" authentication, I wasn't sure how to ca...
Power Automate

Exception handling in Power Automate is done with Scope.

While foreseeable errors (such as references to Blank) should be prevented by prior checking, unforeseeable errors inevi...
Power Automate

Using Word connectors from Power Automate to create documents|Replacing text, adding dynamic items and creating PDFs.

The Word connector action gives the impression that it is not used very often because it requires a premium licence.I ha...
Power Automate

How to set a value in the User column of a SharePoint list in Power Automate with an email address, and how to set null.

Note how to set a value in the SharePoint user column from Power Automate by specifying an email address.Person or Group...