Update Rows in Microsoft Excel and CSV Files with Power Automate

April 24th 2024
Back to all blogs

In this Automate Excel series blog, we will look at how to update rows in your Excel files using Flowr’s ‘Update Rows in Excel‘ action. The action allows you to update rows in your Excel files in data tables and rows that aren’t contained in a table format!

Jump to:

 

Scenario

Consider the following scenario: a ‘Sales’ list in SharePoint is updated by the sales team each time a new sale is completed. Once a month, the data contained within the ‘Sales’ SharePoint list must be transferred to a ‘Sales’ Excel file, which the finance team uses for reporting and other purposes. This is not necessarily a real-world scenario but a good basis for demonstrating how the ‘Update Rows in Excel’ action works.

Excel file

The Excel file that needs updating looks like this:

The SharePoint Sales list looks like this:

The Flow

For this sample solution I’ve created a manually trigger Power Automate Flow, in real-world solution you would probably use a scheduled trigger.

 

Get Items action

First, we use the SharePoint ‘Get items‘ action to get all the items from the SharePoint ‘Sales‘ list.

For the Excel file, we only need to collect the number of customers for each product. We can achieve this by filtering the results of ‘Get items’ by each product; the number of customers will be equal to the length of the filtered array.

As I am only using three products, this is a viable solution. In a real scenario, this may be unrealistic, and it will be better to filter the products dynamically.

 

Get File Content action

The following action is to get the Excel file content. I am using OneDrive, so I can use the ‘Get file content‘ action and target the ‘Sales’ Excel file.

The ‘Update Rows in Excel‘ action accepts data as JSON, so we need to transform the SharePoint list data into a JSON object. As I am only updating one column, I will use a ‘Compose‘ action to create the JSON array rather than appending it to an array variable.

 

Parse JSON action

The last step in preparing the data for the Flowr action is to use ‘Parse JSON‘. This transforms the data into JSON format so it is ready to use in the action. If you use an array variable for your row input data, you must also parse it. The content will be your row input data (either from the compose or from a variable). In this scenario, to generate from sample you can simply copy and paste what you have put into the ‘Compose‘ action, if you are using a variable you will need to add a compose step and run the flow so you can copy and paste the results.

The expression I am using to get the lengths of the filtered arrays are:

length(body('Filter_array_-_Vertr'))
length(body('Filter_array_-_Flowr'))
length(body('Filter_array_-_Trigr'))

They have been put in this order because it is the order of the rows in the Excel file.

 

Update Rows in Excel action

Now, we can use the ‘Update Rows in Excel’ action!

You need to use the outputs of the ‘Parse JSON‘ action for the ‘Row Data‘ input. If this doesn’t show up in your list of dynamic content, you can write the expression manually:

outputs('Parse_JSON')

Specifying rows and columns

The data in my Excel file isn’t in table format, so I need to specify the row and column from which the data needs to be updated. I need to make sure the values being updated are numeric; otherwise, my chart won’t show any data. To do this, I have set the ‘Convert Numeric and Date’ input to Yes. If you have formatted the number or currency cells you are updating, you will also need to set this value to Yes so the formatting can be applied.

When using the Flowr Excel actions, they make a copy of the original file, which contains the updated file. This means you can either create a new file with the changes or update the original file. As we are updating the Excel file in this solution, I am going to update the original file in OneDrive.

Results

Let’s look at the results!

This was the Excel file before the flow ran:

This is the file after the flow has run:

As we can see from the results, the data has been updated, which has, in turn, updated the chart.

 

Video

View Sophie’s companion video: Update Rows in Excel with Power Automate.

What else can Flowr automate?

Search 150+ Actions to see how Flowr can save you time

Crop an Image
The ‘Crop an Image’ flow action crop the image provided to the specified configuration.
Extract Excel Worksheets
The ‘Extract Excel Worksheets’ Power Automate action enables you to extract specified...
Extract from Archive
The ‘Extract from Archive’ flow action enables files contained within supported archi...
Get Email Information
The ‘Get Email Information‘ collects and returns detailed information about the email...
Get Text from Word
The ‘Get Text from Word’ flow action extracts and returns text contained within the M...
Merge Excel Rows
The ‘Merge Excel Rows‘ flow action merges the rows contained within up to 1000 Micros...
Populate Excel
The ‘Populate Excel’ Power Automate action lets you populate a Microsoft Excel workbo...
Resize PDF
The ‘Resize PDF‘ action resizes the pages in the PDF document provided to the specifi...
Update Rows In Excel
The ‘Update Rows in Excel‘ action updates the specified rows in the Excel file provid...
Update Word - Add Headers and Footers
The ‘Update Word – Add Headers and Footers’ flow action adds an HTML header and...
Update Word - Remove Headers and Footers
The ‘Update Word – Remove Headers and Footers’ flow action removes the specifie...
Utility - AES Decryption
The ‘Utility – AES Decryption‘ utility action for Power Automate decrypts a pla...
Utility - AES Encryption
The ‘Utility – AES Encryption‘ utility action for Power Automate encrypts a pla...
Utility - Array Remove Items via Regex
The ‘Array Remove Items via Regex‘ utility action for Power Automate removes the item...
Utility - Array Replace Values
The ‘Array Replace Values‘ utility action for Power Automate replaces targeted values...
Utility - Calculate Date
The ‘Utility – Calculate Date‘ utility action for Power Automate formats the da...
Utility - Convert Array to JSON
The ‘Utility – Array to JSON’ action for Power Automate converts the array prov...
Utility - Convert Time Zone
The ‘Utility – Convert Time Zone‘ utility action for Power Automate converts th...
Utility - Extract Text Instances between Values
The ‘Utility – Extract Text Instances between Values‘ action for Power Automate...
Utility - Validate JSON
The ‘Validate JSON’ utility action for Power Automate validates the JSON data provide...

AI - Translate File
The ‘AI – Translate File‘ Power Automate action will translate the text value p...
AI - Translate Text (Single)
The ‘AI – Translate Text (Single)‘ Power Automate action will translate the tex...
AI - Translate Text (Multiple)
The ‘AI – Translate Text (Multiple)‘ Power Automate action will translate the t...
Excel - Delete Worksheets
The ‘Excel – Delete Worksheets‘ Power Automate action enables you to extract sp...
PDF - Delete Pages
The ‘PDF – Delete Pages‘ Power Automate action enables you to delete specified ...
PDF - Extract Pages
The ‘PDF – Extract Pages‘ flow action extracts the specified pages from the PDF...
Utility - Array to XML
The ‘Utility – Array to XML‘ action for Power Automate converts the array provi...
Utility - Convert JSON to XML
The ‘Utility – Convert JSON to XML‘ action for Power Automate converts the JSON...
Utility - Convert XML to JSON
The ‘Utility – Convert XML to JSON‘ action for Power Automate converts the XML ...
Utility - RSA Create Key Pair
The ‘Utility – RSA Create Key Pair‘ utility action for Power Automate decrypts ...
Utility - RSA Decryption
The ‘Utility – RSA Decryption‘ utility action for Power Automate decrypts a pla...
Utility - RSA Encryption
The ‘Utility – RSA Encryption‘ utility action for Power Automate encrypts a pla...

Add Attachments to PDF
The ‘Add Attachments to PDF’ action attaches (also referred to as embeds) the files p...
Add HTML Header or Footer
The ‘Add HTML Header or Footer’ flow action inserts the HTML fragment provided into t...
Add Image Watermark to Image
The ‘Add Image Watermark to Image’ action adds the specified image to the image provi...
Add Image Watermark to PDF
The ‘Add Image Watermark to PDF’ embeds the image file provided as a watermark horizo...
Add Image Watermark to PDF (Advanced)
The ‘Add Image Watermark to PDF (Advanced)’ embeds the image file provided as a water...
Add Image Watermark to Word
The ‘Add Image Watermark to Word’ action adds an image provided as a watermark to a s...
Add Page Numbers
The ‘Add Page Numbers’ flow action inserts page numbers into the provided PDF documen...
Add Rows to Excel
The ‘Add Rows to Excel’ Power Automate action allows you to add rows to the file prov...
Add Text Watermark to Image
The ‘Add Text Watermark to Image’ action adds the specified text to the image provide...
Add Text Watermark to PDF
The ‘Add Text Watermark to PDF’ adds the specified text watermark horizontally or ver...
Add Text Watermark to PDF (Advanced)
The ‘Add Text Watermark to PDF (Advanced)’ action adds the specified text watermark t...
Add Text Watermark to Word
The ‘Add Text Watermark to Word’ action adds specified text as a watermark to a selec...
Add to Archive (ZIP)
The ‘Add to Archive (ZIP)’ flow compresses and adds up to 1000 files to a zip package...
AI - Translate File
The ‘AI – Translate File‘ Power Automate action will translate the text value p...
AI - Translate Text (Single)
The ‘AI – Translate Text (Single)‘ Power Automate action will translate the tex...
AI - Translate Text (Multiple)
The ‘AI – Translate Text (Multiple)‘ Power Automate action will translate the t...
Compare Word Documents
The ‘Compare Word Documents’ Power Automate action allows you to compare Microsoft Wo...
Compress an Image
The ‘Compress an Image’ flow action compresses either a ‘PNG’ or ‘J...
Compress PDF
The ‘Compress PDF’ action applies compression to the PDF document provided.
Compress PowerPoint
The ‘Compress PowerPoint’ action applies compression to the PowerPoint or presentatio...
Convert Email Message
The ‘Convert Email Message’ Power Automate action converts an email message file (MSG...
Convert CAD
The ‘Convert CAD’ Power Automate action allows you to convert DGN, DWF, DWG, DXF, IFC...
Convert Excel
The ‘Convert Excel’ Power Automate action allows you to and from convert from various...
Convert HTML to PDF
The ‘Convert HTML to PDF’ flow action converts either HTML files (.html), HTML data o...
Convert HTML to Word
The ‘Convert HTML to Word’ flow action converts either HTML files (.html), HTML data ...
Convert Image Format
The ‘Convert Image Format’ flow action allows you to change file format of the image/...
Convert JSON to Excel
The ‘Convert JSON to Excel’ flow action provides the capability to convert the JSON d...
Convert PDF to Images
The ‘Convert PDF to Images’ flow action converts the PDF file provided into an array ...
Convert PDF to JPG
The ‘Convert PDF to JPG’ flow action for Power Automate converts every page contained...
Convert PDF to PNG
The ‘Convert PDF to PNG’ flow action for Power Automate converts every page contained...
Convert PDF to TIFF
The ‘Convert PDF to TIFF’ flow action converts the PDF file provided into a TIFF file...
Convert PDF to Word
The ‘Convert PDF to Word’ flow action converts the PDF document provided to a Microso...
Convert PowerPoint
The ‘Convert PowerPoint’ Power Automate action allows you to convert PPT and PPTX fil...
Convert to PDF
The ‘Convert to PDF’ flow action converts the file provided into a PDF document align...
Convert to Visio
The ‘Convert Visio’ Power Automate action allows you to convert to and from various f...
Convert Text to PDF
The ‘Convert Text to PDF’ flow action converts either text files (.txt) or text data ...
Convert Word
The ‘Convert Word’ Power Automate action allows you to convert DOC, DOCX, DOTX and RT...
Convert Word to PDF Form
The ‘Convert Word to PDF Form’ flow action converts the Microsoft Word document provi...
Create Barcode
The ‘Create Barcode’ action generates a barcode image file aligned to the configurati...
Create QR Code
The ‘Create QR Code’ action generates a QR code image file aligned to the configurati...
Convert PDF to PDFA
The ‘Convert PDF to PDF/A’ flow action converts the PDF file provided into a PDF/A co...
Crop an Image
The ‘Crop an Image’ flow action crop the image provided to the specified configuration.
Delete Rows from Excel
The ‘Delete Rows from Excel’ Power Automate action allows you to delete rows from the...
Disable Tracked Changes
The ‘Disable Tracked Changes’ action for Power Automate disables tracked changes for ...
Enable Tracked Changes
The ‘Enable Tracked Changes’ action for Power Automate enables tracked changes for th...
Excel - Delete Worksheets
The ‘Excel – Delete Worksheets‘ Power Automate action enables you to extract sp...
Extract Attachments from PDF
The ‘Extract Attachments from PDF’ flow action extracts and returns embedded files fr...
Extract Excel Worksheets
The ‘Extract Excel Worksheets’ Power Automate action enables you to extract specified...
Extract from Archive
The ‘Extract from Archive’ flow action enables files contained within supported archi...
Extract Images from PDF
The ‘Extract Images from PDF’ Power Automate action enables images to be extracted fr...
Extract Text from Image (OCR)
The ‘Extract Text from Image (OCR)’ Power Automate action will perform OCR on the ima...
Extract Text from Regions
The ‘Extract Text Regions’ flow action enables text to be extracted from specified re...
Flatten PDF
The ‘Flatten PDF’ action removes all fields and other objects from a PDF document rep...
Flip an Image
The ‘Flip an Image’ flow action flips the image provided to the specified configurati...
Fill a PDF Form
The ‘Fill a PDF Form’ Power Automate action populates the PDF Form provided with the ...
Get Email Attachments
The ‘Get Email Attachments’ flow action for Power Automate extracts and returns all a...
Get Image Information
The ‘Get Image Information’ collects and returns detailed information about the suppl...
Get PDF Document Information
The ‘Get PDF Document Information’ collects and returns detailed information about th...
Get PDF Form Data
The ‘Get PDF Form Data’ action extracts data from a filled PDF document and returns t...
Get PDF Text Layer
The ‘Get PDF Text Layer’ flow action extracts and returns the text layer from the PDF...
Get Rows from Excel
The ‘Get Rows from Excel’ action obtains and returns rows as JSON from the file provi...
Get Subscription Status - Flowr & Vertr
The ‘Get Subscription Status – Flowr & Vertr’ Power Automate action obtains...
Get Subscription Status - Trigr
The ‘Get Subscription Status – Trigr’ action obtains real-time information abou...
Get Text from Word
The ‘Get Text from Word’ flow action extracts and returns text contained within the M...
Get Tracked Changes
The ‘Get Tracked Changes’ action for Power Automate obtains all of the tracked change...
Image Clean Up (Document)
The ‘Image Clean Up (Document)’ Power Automate action provides differing options to c...
Image Clean Up (Photo)
The ‘Image Clean Up (Photo)’ Power Automate action provides differing options to clea...
Insert HTML to PDF
The ‘Insert HTML to PDF’ flow action inserts the HTML data provided into the PDF docu...
Merge Document Array to PDF
The ‘Merge Document Array to PDF’ flow merges up to 1000 documents provided in a JSON...
Merge Excel Files
The ‘Merge Excel Files’ flow action merges up to 1000 Microsoft Excel files (and rela...
Manage Tracked Changes
The ‘Manage Tracked Changes’ action for Power Automate allows all types of tracked ch...
Merge documents to PDF
The ‘Merge documents to PDF’ flow merges upto 10 documents into a single PDF document.
Merge Presentations
The ‘Merge Presentations’ flow action merges up to 1,000 presentation files to a sing...
Merge Word Documents
The ‘Merge Word Documents’ flow action merges up to 1000 Microsoft Word documents pro...
OCR a PDF Document
The ‘OCR a PDF Document’ performs OCR on the PDF document provided.
Parse CSV
The ‘Parse CSV’ action parses the contents of a CSV file and returns it as JSON data.
PDF - Delete Pages
The ‘PDF – Delete Pages‘ Power Automate action enables you to delete specified ...
PDF - Extract Pages
The ‘PDF – Extract Pages‘ flow action extracts the specified pages from the PDF...
Populate Excel
The ‘Populate Excel’ Power Automate action lets you populate a Microsoft Excel workbo...
Populate PowerPoint
The ‘Populate PowerPoint’ Power Automate action enables you to populate a Microsoft P...
Populate Word Document
The ‘Populate Word Document’ Power Automate action enables you to populate a word doc...
Read Barcode - Document
The ‘Read Barcode – Document’ Power Automate action will automatically locate a...
Read Barcode - Image
The ‘Read Barcode – Image’ Power Automate action read the barcode from image fi...
Read QR Code - Document
The ‘Read QR Code – Document’ Power Automate action will automatically locate a...
Remove Watermarks from PDF
The ‘Remove Watermarks from PDF’ action removes all or targeted watermarks from the P...
Rotate an Image
The ‘Rotate an Image’ flow action rotates the image provided to configuration specifi...
Read QR Code - Image
The ‘Read QR Code – Image’ Power Automate action reads the QR Code data from im...
Redact PDF
The ‘Redact PDF’ flow action provides the capability to search for text fragments wit...
Remove EXIF Tags from Image
The ‘Remove EXIF Tags from Image’ flow action removes EXIF tag data from ‘PNG&#...
Remove Watermarks from Word
The ‘Remove Watermark from Word’ action remove both an image and text watermark from ...
Repair PDF
The ‘Repair PDF’ action checks and repairs PDF documents.
Replace Text with Image
The ‘Replace Text with Image’ flow action locates instances of the specified text in ...
Resize an Image
The ‘Resize an Image’ flow action resizes the image provided to the specified configu...
Search and Replace Text
The ‘Search and Replace Text’ flow action provides the capability to search for text ...
Secure PDF Document
The ‘Secure PDF Document’ flow action applies the specified security configuration to...
Secure Word Document
The ‘Secure Word Document’ action for Power Automate enables you to secure / protect ...
Set PDF Document Priviledges
The ‘Set PDF Document Privileges’ flow action applies the specified security configur...
Sign PDF
The ‘Sign PDF’ action applies a digital signature to the PDF document provided.
Split PDF
The ‘Split PDF’ flow action splits the PDF document provided into multiple separate P...
Split PDF by Barcode
The ‘Split PDF by Barcode’ flow action splits a PDF document into multiple separate P...
Split PDF by Text
The ‘Split PDF by Text’ flow action splits a PDF document into multiple separate PDF ...
Unlock PDF Document
The ‘Unlock PDF Document’ removes password protection and decrypts the PDF document p...
Update Rows In Excel
The ‘Update Rows in Excel‘ action updates the specified rows in the Excel file provid...
Update Word - Add Headers and Footers
The ‘Update Word – Add Headers and Footers’ flow action adds an HTML header and...
Update Word - Hyperlinks
The ‘Update Word – Hyperlinks’ flow action provides the capability to search fo...
Update Word - Remove Headers and Footers
The ‘Update Word – Remove Headers and Footers’ flow action removes the specifie...
Update Word - Table of Contents
The ‘Update Word – Table of Contents’ flow action updates the ‘Table of C...

Utility - AES Decryption
The ‘Utility – AES Decryption‘ utility action for Power Automate decrypts a pla...
Utility - AES Encryption
The ‘Utility – AES Encryption‘ utility action for Power Automate encrypts a pla...
Utility - Array Add Items
The ‘Utility – Array Add Items’ utility action for Power Automate adds the item...
Utility - Array Contains Value
The ‘Utility – Array Contains Value’ utility action for Power Automate checks w...
Utility - Array Count Items
The ‘Utility – Array Count Items’ utility action for Power Automate counts the ...
Utility - Array Get Item(s)
The ‘Utility – Array Get Item(s)’ utility action for Power Automate selects and...
Utility - Array Remove Duplicates
The ‘Utility – Array Remove Duplicates’ utility action for Power Automate remov...
Utility - Array Remove Items
The ‘Utility – Array Remove Items’ utility action for Power Automate removes th...
Utility - Array Remove Items via Regex
The ‘Array Remove Items via Regex‘ utility action for Power Automate removes the item...
Utility - Array Replace Values
The ‘Array Replace Values‘ utility action for Power Automate replaces targeted values...
Utility - Array Reverse Items
The ‘Utility – Array Reverse Items’ utility action for Power Automate reverses ...
Utility - Array to XML
The ‘Utility – Array to XML‘ action for Power Automate converts the array provi...
Utility - Calculate Date
The ‘Utility – Calculate Date‘ utility action for Power Automate formats the da...
Utility - Compare Text
The ‘Utility – Compare Text’ compares the two text values provided, confirming ...
Utility - Concatenate Text
The ‘Utility – Concatenate Text’ action for Power Automate concatenates the tex...
Utility - Convert Array to JSON
The ‘Utility – Array to JSON’ action for Power Automate converts the array prov...
Utility - Convert JSON to XML
The ‘Utility – Convert JSON to XML‘ action for Power Automate converts the JSON...
Utility - Convert Time Zone
The ‘Utility – Convert Time Zone‘ utility action for Power Automate converts th...
Utility - Convert XML to JSON
The ‘Utility – Convert XML to JSON‘ action for Power Automate converts the XML ...
Utility - Clean Text
The ‘Utility – Clean Text’ action for Power Automate removes specified characte...
Utility - Create GUID
The ‘Utility – Create GUID’ utility action for Power Automate generates a new G...
Utility - Create Hash Code
The ‘Utility – Create Hash Code’ action allows you to generate a hash code for ...
Utility - Create HMAC
The ‘Utility – Create HMAC’ action allows you to create a Hash-based message au...
Utility - Escape HTML
The ‘Utility – Escape HTML’ escapes or also known as encodes the HTML string va...
Utility - Extract Email Addresses from Text
The ‘Utility – Extract Email Addresses from Text’ action for Power Automate det...
Utility - Extract Text Between Values
The ‘Utility – Extract Text between Values’ action for Power Automate returns a...
Utility - Extract Text Instances between Values
The ‘Utility – Extract Text Instances between Values‘ action for Power Automate...
Utility - Extract URL's from Text
The ‘Utility – Extract URL’s from Text’ action for Power Automate detects...
Utility - Format Date
The ‘Utility – Format Date’ utility action for Power Automate formats the date ...
Utility - Format Text Case
The ‘Utility – Format Text Case’ utility action for Power Automate formats the ...
Utility - Generate Password
The ‘Utility – Generate Password’ utility action for Power Automate generates a...
Utility - Generate Random Number
The ‘Utility – Generate Random Number’ action for Power Automate returns a rand...
Utility - Get Date and Time Difference
The ‘Utility – Get Date and Time Difference’ calculates the difference between ...
Utility - Get File Extension
The ‘Utility – Get File Extension’ action for Power Automate returns the file e...
Utility - Parse HTML Table
The ‘Utility – Parse HTML Table’ action for Power Automate parses a HTML table ...
Utility - Remove Diacritics
The ‘Utility – Remove Diacritics’ removes and replaces the diacritic marks cont...
Utility - Remove Text Between Values
The ‘Utility – Remove Text between Values’ action for Power Automate returns a ...
Utility - Replace Value with Regex
The ‘Utility – Replace Value with Regex’ replaces a value within the text provi...
Utility - Replace Value with Text
The ‘Utility – Replace Value with Text’ replaces a value within the text provid...
Utility - RSA Create Key Pair
The ‘Utility – RSA Create Key Pair‘ utility action for Power Automate decrypts ...
Utility - RSA Decryption
The ‘Utility – RSA Decryption‘ utility action for Power Automate decrypts a pla...
Utility - RSA Encryption
The ‘Utility – RSA Encryption‘ utility action for Power Automate encrypts a pla...
Utility - Search Text (Regex)
The ‘Utility – Search Text (Regex)’ Power Automate action provides the capabili...
Utility - Split Text
The ‘Utility – Split Text’ action for Power Automate splits the text provided a...
Utility - Text Contains Value
The ‘Utility – Text Contains Value’ utility action for Power Automate checks wh...
Utility - Trim Text
The ‘Utility – Trim Text’ performs a ‘Trim’ action on the text valu...
Utility - Unescape HMTL
The ‘Utility – Unescape HTML’ unescapes or also known as decodes the HTML strin...
Utility - Validate Email Address
The ‘Utility – Validate Email Address’ action for Power Automate validates the ...
Utility - Validate GUID
The ‘Utility – Validate GUID’ action for Power Automate validates whether the s...
Utility - Validate JSON
The ‘Validate JSON’ utility action for Power Automate validates the JSON data provide...
Utility - Validate URL Availability
The ‘Utility – Validate URL Availability’ action for Power Automate checks whet...
Utility - Validate URL Syntax
The ‘Utility – Validate URL Syntax’ action for Power Automate validates whether...

Convert HTML to PDF
The ‘Convert HTML to PDF’ flow action converts either HTML files (.html), HTML data o...
Convert HTML to Word
The ‘Convert HTML to Word’ flow action converts either HTML files (.html), HTML data ...
Convert JSON to Excel
The ‘Convert JSON to Excel’ flow action provides the capability to convert the JSON d...
Fill a PDF Form
The ‘Fill a PDF Form’ Power Automate action populates the PDF Form provided with the ...
Populate Excel
The ‘Populate Excel’ Power Automate action lets you populate a Microsoft Excel workbo...
Populate PowerPoint
The ‘Populate PowerPoint’ Power Automate action enables you to populate a Microsoft P...
Populate Word Document
The ‘Populate Word Document’ Power Automate action enables you to populate a word doc...
Replace Text with Image
The ‘Replace Text with Image’ flow action locates instances of the specified text in ...

Convert Email Message
The ‘Convert Email Message’ Power Automate action converts an email message file (MSG...
Convert CAD
The ‘Convert CAD’ Power Automate action allows you to convert DGN, DWF, DWG, DXF, IFC...
Convert Excel
The ‘Convert Excel’ Power Automate action allows you to and from convert from various...
Convert HTML to PDF
The ‘Convert HTML to PDF’ flow action converts either HTML files (.html), HTML data o...
Convert HTML to Word
The ‘Convert HTML to Word’ flow action converts either HTML files (.html), HTML data ...
Convert Image Format
The ‘Convert Image Format’ flow action allows you to change file format of the image/...
Convert JSON to Excel
The ‘Convert JSON to Excel’ flow action provides the capability to convert the JSON d...
Convert PDF to Images
The ‘Convert PDF to Images’ flow action converts the PDF file provided into an array ...
Convert PDF to JPG
The ‘Convert PDF to JPG’ flow action for Power Automate converts every page contained...
Convert PDF to PNG
The ‘Convert PDF to PNG’ flow action for Power Automate converts every page contained...
Convert PDF to TIFF
The ‘Convert PDF to TIFF’ flow action converts the PDF file provided into a TIFF file...
Convert PDF to Word
The ‘Convert PDF to Word’ flow action converts the PDF document provided to a Microso...
Convert PowerPoint
The ‘Convert PowerPoint’ Power Automate action allows you to convert PPT and PPTX fil...
Convert to PDF
The ‘Convert to PDF’ flow action converts the file provided into a PDF document align...
Convert to Visio
The ‘Convert Visio’ Power Automate action allows you to convert to and from various f...
Convert Text to PDF
The ‘Convert Text to PDF’ flow action converts either text files (.txt) or text data ...
Convert Word
The ‘Convert Word’ Power Automate action allows you to convert DOC, DOCX, DOTX and RT...
Convert Word to PDF Form
The ‘Convert Word to PDF Form’ flow action converts the Microsoft Word document provi...
Convert PDF to PDFA
The ‘Convert PDF to PDF/A’ flow action converts the PDF file provided into a PDF/A co...
Utility - Convert Array to JSON
The ‘Utility – Array to JSON’ action for Power Automate converts the array prov...

Merge Document Array to PDF
The ‘Merge Document Array to PDF’ flow merges up to 1000 documents provided in a JSON...
Merge Excel Files
The ‘Merge Excel Files’ flow action merges up to 1000 Microsoft Excel files (and rela...
Merge documents to PDF
The ‘Merge documents to PDF’ flow merges upto 10 documents into a single PDF document.
Merge Presentations
The ‘Merge Presentations’ flow action merges up to 1,000 presentation files to a sing...
Merge Word Documents
The ‘Merge Word Documents’ flow action merges up to 1000 Microsoft Word documents pro...
Split PDF
The ‘Split PDF’ flow action splits the PDF document provided into multiple separate P...
Split PDF by Barcode
The ‘Split PDF by Barcode’ flow action splits a PDF document into multiple separate P...
Split PDF by Text
The ‘Split PDF by Text’ flow action splits a PDF document into multiple separate PDF ...

Add Image Watermark to Image
The ‘Add Image Watermark to Image’ action adds the specified image to the image provi...
Add Image Watermark to PDF
The ‘Add Image Watermark to PDF’ embeds the image file provided as a watermark horizo...
Add Image Watermark to PDF (Advanced)
The ‘Add Image Watermark to PDF (Advanced)’ embeds the image file provided as a water...
Add Image Watermark to Word
The ‘Add Image Watermark to Word’ action adds an image provided as a watermark to a s...
Add Text Watermark to Image
The ‘Add Text Watermark to Image’ action adds the specified text to the image provide...
Add Text Watermark to PDF
The ‘Add Text Watermark to PDF’ adds the specified text watermark horizontally or ver...
Add Text Watermark to PDF (Advanced)
The ‘Add Text Watermark to PDF (Advanced)’ action adds the specified text watermark t...
Add Text Watermark to Word
The ‘Add Text Watermark to Word’ action adds specified text as a watermark to a selec...
Remove Watermarks from PDF
The ‘Remove Watermarks from PDF’ action removes all or targeted watermarks from the P...
Remove Watermarks from Word
The ‘Remove Watermark from Word’ action remove both an image and text watermark from ...

Create Barcode
The ‘Create Barcode’ action generates a barcode image file aligned to the configurati...
Create QR Code
The ‘Create QR Code’ action generates a QR code image file aligned to the configurati...
Read Barcode - Document
The ‘Read Barcode – Document’ Power Automate action will automatically locate a...
Read Barcode - Image
The ‘Read Barcode – Image’ Power Automate action read the barcode from image fi...
Read QR Code - Document
The ‘Read QR Code – Document’ Power Automate action will automatically locate a...
Read QR Code - Image
The ‘Read QR Code – Image’ Power Automate action reads the QR Code data from im...
Split PDF by Barcode
The ‘Split PDF by Barcode’ flow action splits a PDF document into multiple separate P...

Compress PDF
The ‘Compress PDF’ action applies compression to the PDF document provided.
Compress PowerPoint
The ‘Compress PowerPoint’ action applies compression to the PowerPoint or presentatio...

Add Image Watermark to Image
The ‘Add Image Watermark to Image’ action adds the specified image to the image provi...
Add Text Watermark to Image
The ‘Add Text Watermark to Image’ action adds the specified text to the image provide...
Compress an Image
The ‘Compress an Image’ flow action compresses either a ‘PNG’ or ‘J...
Convert Image Format
The ‘Convert Image Format’ flow action allows you to change file format of the image/...
Convert PDF to Images
The ‘Convert PDF to Images’ flow action converts the PDF file provided into an array ...
Convert PDF to PNG
The ‘Convert PDF to PNG’ flow action for Power Automate converts every page contained...
Convert PDF to TIFF
The ‘Convert PDF to TIFF’ flow action converts the PDF file provided into a TIFF file...
Convert to Visio
The ‘Convert Visio’ Power Automate action allows you to convert to and from various f...
Crop an Image
The ‘Crop an Image’ flow action crop the image provided to the specified configuration.
Extract Images from PDF
The ‘Extract Images from PDF’ Power Automate action enables images to be extracted fr...
Extract Text from Image (OCR)
The ‘Extract Text from Image (OCR)’ Power Automate action will perform OCR on the ima...
Flip an Image
The ‘Flip an Image’ flow action flips the image provided to the specified configurati...
Get Image Information
The ‘Get Image Information’ collects and returns detailed information about the suppl...
Image Clean Up (Document)
The ‘Image Clean Up (Document)’ Power Automate action provides differing options to c...
Image Clean Up (Photo)
The ‘Image Clean Up (Photo)’ Power Automate action provides differing options to clea...
Rotate an Image
The ‘Rotate an Image’ flow action rotates the image provided to configuration specifi...
Remove EXIF Tags from Image
The ‘Remove EXIF Tags from Image’ flow action removes EXIF tag data from ‘PNG&#...
Resize an Image
The ‘Resize an Image’ flow action resizes the image provided to the specified configu...

Extract Attachments from PDF
The ‘Extract Attachments from PDF’ flow action extracts and returns embedded files fr...
Extract Excel Worksheets
The ‘Extract Excel Worksheets’ Power Automate action enables you to extract specified...
Extract from Archive
The ‘Extract from Archive’ flow action enables files contained within supported archi...
Extract Images from PDF
The ‘Extract Images from PDF’ Power Automate action enables images to be extracted fr...
Extract Text from Regions
The ‘Extract Text Regions’ flow action enables text to be extracted from specified re...
Get Email Attachments
The ‘Get Email Attachments’ flow action for Power Automate extracts and returns all a...
Get Image Information
The ‘Get Image Information’ collects and returns detailed information about the suppl...
Get PDF Document Information
The ‘Get PDF Document Information’ collects and returns detailed information about th...
Get PDF Form Data
The ‘Get PDF Form Data’ action extracts data from a filled PDF document and returns t...
Get PDF Text Layer
The ‘Get PDF Text Layer’ flow action extracts and returns the text layer from the PDF...
Get Rows from Excel
The ‘Get Rows from Excel’ action obtains and returns rows as JSON from the file provi...
Get Text from Word
The ‘Get Text from Word’ flow action extracts and returns text contained within the M...
Parse CSV
The ‘Parse CSV’ action parses the contents of a CSV file and returns it as JSON data.
PDF - Extract Pages
The ‘PDF – Extract Pages‘ flow action extracts the specified pages from the PDF...

Extract Text from Image (OCR)
The ‘Extract Text from Image (OCR)’ Power Automate action will perform OCR on the ima...
OCR a PDF Document
The ‘OCR a PDF Document’ performs OCR on the PDF document provided.

Add to Archive (ZIP)
The ‘Add to Archive (ZIP)’ flow compresses and adds up to 1000 files to a zip package...
Redact PDF
The ‘Redact PDF’ flow action provides the capability to search for text fragments wit...
Secure PDF Document
The ‘Secure PDF Document’ flow action applies the specified security configuration to...
Secure Word Document
The ‘Secure Word Document’ action for Power Automate enables you to secure / protect ...
Set PDF Document Priviledges
The ‘Set PDF Document Privileges’ flow action applies the specified security configur...
Sign PDF
The ‘Sign PDF’ action applies a digital signature to the PDF document provided.
Unlock PDF Document
The ‘Unlock PDF Document’ removes password protection and decrypts the PDF document p...

Convert Email Message
The ‘Convert Email Message’ Power Automate action converts an email message file (MSG...
Get Email Attachments
The ‘Get Email Attachments’ flow action for Power Automate extracts and returns all a...
Get Email Information
The ‘Get Email Information‘ collects and returns detailed information about the email...

Add Attachments to PDF
The ‘Add Attachments to PDF’ action attaches (also referred to as embeds) the files p...
Add HTML Header or Footer
The ‘Add HTML Header or Footer’ flow action inserts the HTML fragment provided into t...
Add Image Watermark to PDF
The ‘Add Image Watermark to PDF’ embeds the image file provided as a watermark horizo...
Add Image Watermark to PDF (Advanced)
The ‘Add Image Watermark to PDF (Advanced)’ embeds the image file provided as a water...
Add Page Numbers
The ‘Add Page Numbers’ flow action inserts page numbers into the provided PDF documen...
Add Text Watermark to PDF
The ‘Add Text Watermark to PDF’ adds the specified text watermark horizontally or ver...
Add Text Watermark to PDF (Advanced)
The ‘Add Text Watermark to PDF (Advanced)’ action adds the specified text watermark t...
Compress PDF
The ‘Compress PDF’ action applies compression to the PDF document provided.
Convert HTML to PDF
The ‘Convert HTML to PDF’ flow action converts either HTML files (.html), HTML data o...
Convert PDF to Images
The ‘Convert PDF to Images’ flow action converts the PDF file provided into an array ...
Convert PDF to JPG
The ‘Convert PDF to JPG’ flow action for Power Automate converts every page contained...
Convert PDF to PNG
The ‘Convert PDF to PNG’ flow action for Power Automate converts every page contained...
Convert PDF to TIFF
The ‘Convert PDF to TIFF’ flow action converts the PDF file provided into a TIFF file...
Convert PDF to Word
The ‘Convert PDF to Word’ flow action converts the PDF document provided to a Microso...
Convert to PDF
The ‘Convert to PDF’ flow action converts the file provided into a PDF document align...
Convert Text to PDF
The ‘Convert Text to PDF’ flow action converts either text files (.txt) or text data ...
Convert Word to PDF Form
The ‘Convert Word to PDF Form’ flow action converts the Microsoft Word document provi...
Convert PDF to PDFA
The ‘Convert PDF to PDF/A’ flow action converts the PDF file provided into a PDF/A co...
Extract Attachments from PDF
The ‘Extract Attachments from PDF’ flow action extracts and returns embedded files fr...
Extract Images from PDF
The ‘Extract Images from PDF’ Power Automate action enables images to be extracted fr...
Flatten PDF
The ‘Flatten PDF’ action removes all fields and other objects from a PDF document rep...
Fill a PDF Form
The ‘Fill a PDF Form’ Power Automate action populates the PDF Form provided with the ...
Get PDF Document Information
The ‘Get PDF Document Information’ collects and returns detailed information about th...
Get PDF Form Data
The ‘Get PDF Form Data’ action extracts data from a filled PDF document and returns t...
Get PDF Text Layer
The ‘Get PDF Text Layer’ flow action extracts and returns the text layer from the PDF...
Insert HTML to PDF
The ‘Insert HTML to PDF’ flow action inserts the HTML data provided into the PDF docu...
Merge Document Array to PDF
The ‘Merge Document Array to PDF’ flow merges up to 1000 documents provided in a JSON...
Merge documents to PDF
The ‘Merge documents to PDF’ flow merges upto 10 documents into a single PDF document.
OCR a PDF Document
The ‘OCR a PDF Document’ performs OCR on the PDF document provided.
PDF - Delete Pages
The ‘PDF – Delete Pages‘ Power Automate action enables you to delete specified ...
PDF - Extract Pages
The ‘PDF – Extract Pages‘ flow action extracts the specified pages from the PDF...
Remove Watermarks from PDF
The ‘Remove Watermarks from PDF’ action removes all or targeted watermarks from the P...
Resize PDF
The ‘Resize PDF‘ action resizes the pages in the PDF document provided to the specifi...
Redact PDF
The ‘Redact PDF’ flow action provides the capability to search for text fragments wit...
Repair PDF
The ‘Repair PDF’ action checks and repairs PDF documents.
Replace Text with Image
The ‘Replace Text with Image’ flow action locates instances of the specified text in ...
Search and Replace Text
The ‘Search and Replace Text’ flow action provides the capability to search for text ...
Secure PDF Document
The ‘Secure PDF Document’ flow action applies the specified security configuration to...
Set PDF Document Priviledges
The ‘Set PDF Document Privileges’ flow action applies the specified security configur...
Sign PDF
The ‘Sign PDF’ action applies a digital signature to the PDF document provided.
Split PDF
The ‘Split PDF’ flow action splits the PDF document provided into multiple separate P...
Split PDF by Barcode
The ‘Split PDF by Barcode’ flow action splits a PDF document into multiple separate P...
Split PDF by Text
The ‘Split PDF by Text’ flow action splits a PDF document into multiple separate PDF ...
Unlock PDF Document
The ‘Unlock PDF Document’ removes password protection and decrypts the PDF document p...

Add Rows to Excel
The ‘Add Rows to Excel’ Power Automate action allows you to add rows to the file prov...
Convert Excel
The ‘Convert Excel’ Power Automate action allows you to and from convert from various...
Convert JSON to Excel
The ‘Convert JSON to Excel’ flow action provides the capability to convert the JSON d...
Delete Rows from Excel
The ‘Delete Rows from Excel’ Power Automate action allows you to delete rows from the...
Excel - Delete Worksheets
The ‘Excel – Delete Worksheets‘ Power Automate action enables you to extract sp...
Extract Excel Worksheets
The ‘Extract Excel Worksheets’ Power Automate action enables you to extract specified...
Get Email Information
The ‘Get Email Information‘ collects and returns detailed information about the email...
Get Rows from Excel
The ‘Get Rows from Excel’ action obtains and returns rows as JSON from the file provi...
Merge Excel Files
The ‘Merge Excel Files’ flow action merges up to 1000 Microsoft Excel files (and rela...
Merge Excel Rows
The ‘Merge Excel Rows‘ flow action merges the rows contained within up to 1000 Micros...
Populate Excel
The ‘Populate Excel’ Power Automate action lets you populate a Microsoft Excel workbo...
Update Rows In Excel
The ‘Update Rows in Excel‘ action updates the specified rows in the Excel file provid...

Compress PowerPoint
The ‘Compress PowerPoint’ action applies compression to the PowerPoint or presentatio...
Convert PowerPoint
The ‘Convert PowerPoint’ Power Automate action allows you to convert PPT and PPTX fil...
Merge Presentations
The ‘Merge Presentations’ flow action merges up to 1,000 presentation files to a sing...
Populate PowerPoint
The ‘Populate PowerPoint’ Power Automate action enables you to populate a Microsoft P...

Add Image Watermark to Word
The ‘Add Image Watermark to Word’ action adds an image provided as a watermark to a s...
Add Text Watermark to Word
The ‘Add Text Watermark to Word’ action adds specified text as a watermark to a selec...
Compare Word Documents
The ‘Compare Word Documents’ Power Automate action allows you to compare Microsoft Wo...
Convert HTML to Word
The ‘Convert HTML to Word’ flow action converts either HTML files (.html), HTML data ...
Convert PDF to Word
The ‘Convert PDF to Word’ flow action converts the PDF document provided to a Microso...
Convert Word
The ‘Convert Word’ Power Automate action allows you to convert DOC, DOCX, DOTX and RT...
Convert Word to PDF Form
The ‘Convert Word to PDF Form’ flow action converts the Microsoft Word document provi...
Disable Tracked Changes
The ‘Disable Tracked Changes’ action for Power Automate disables tracked changes for ...
Enable Tracked Changes
The ‘Enable Tracked Changes’ action for Power Automate enables tracked changes for th...
Get Text from Word
The ‘Get Text from Word’ flow action extracts and returns text contained within the M...
Get Tracked Changes
The ‘Get Tracked Changes’ action for Power Automate obtains all of the tracked change...
Manage Tracked Changes
The ‘Manage Tracked Changes’ action for Power Automate allows all types of tracked ch...
Merge Word Documents
The ‘Merge Word Documents’ flow action merges up to 1000 Microsoft Word documents pro...
Populate Word Document
The ‘Populate Word Document’ Power Automate action enables you to populate a word doc...
Remove Watermarks from Word
The ‘Remove Watermark from Word’ action remove both an image and text watermark from ...
Replace Text with Image
The ‘Replace Text with Image’ flow action locates instances of the specified text in ...
Search and Replace Text
The ‘Search and Replace Text’ flow action provides the capability to search for text ...
Secure Word Document
The ‘Secure Word Document’ action for Power Automate enables you to secure / protect ...
Update Word - Add Headers and Footers
The ‘Update Word – Add Headers and Footers’ flow action adds an HTML header and...
Update Word - Hyperlinks
The ‘Update Word – Hyperlinks’ flow action provides the capability to search fo...
Update Word - Remove Headers and Footers
The ‘Update Word – Remove Headers and Footers’ flow action removes the specifie...
Update Word - Table of Contents
The ‘Update Word – Table of Contents’ flow action updates the ‘Table of C...

Get Subscription Status - Flowr & Vertr
The ‘Get Subscription Status – Flowr & Vertr’ Power Automate action obtains...
Get Subscription Status - Trigr
The ‘Get Subscription Status – Trigr’ action obtains real-time information abou...

AI - Translate File
The ‘AI – Translate File‘ Power Automate action will translate the text value p...
AI - Translate Text (Single)
The ‘AI – Translate Text (Single)‘ Power Automate action will translate the tex...
AI - Translate Text (Multiple)
The ‘AI – Translate Text (Multiple)‘ Power Automate action will translate the t...
Start your FREE Flowr trial

Sign up for your free 30-day trial; no cards, catches, or contracts.

Start your trial
Need help building your flow?

No job is too big or too small for our Professional Services team!

Contact us
Author
Sophie Charlwood

Technical Evangelist

Back to all blogs

You might also be interested in...