How-to

All our how-to blogs in one place!

Filter by:

April 24th 2024

How To

Update Rows in Microsoft Excel and CSV Files with Power Automate
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!

Sophie Charlwood

April 4th 2024

How To

Remove duplicate entries from Excel and CSV files in Power Automate
In this post, we’ll cover how to use the Encodian Flowr connector for Power Automate to automatically detect and remove duplicates from an Excel file (or CSV file).

Jay Goodison

April 4th 2024

How To

Add Rows to Microsoft Excel and CSV Files with Power Automate
In the second blog of our Automate Excel series, we will examine how you can automatically transfer data from Dataverse to Excel using Encodian Flowr’s Add Rows to Excel action. The action allows you to add one or multiple rows of data at a time.

Sophie Charlwood

March 21st 2024

How To

Get Rows from Excel
In the first post of our Automate Excel series, Sophie explores how to get rows from Excel using the example of Supplier Notes. If blogs aren’t for you, check out our companion video!

Sophie Charlwood

March 12th 2024

How To

Trim text in Power Automate
Post #24 of our Build Flows Faster series covering our new utility actions for Power Automate. Today’s lesson covers how to ‘Trim Text’ in Power Automate with Encodian utility actions.

Jay Goodison

March 8th 2024

How To

Using Custom AI Prompts in Power Apps and Power Automate
Many new, exciting AI features, including GPT technology, have recently been added to the Power Platform. Prompts are a new feature within AI Builder that allows you to manipulate text using GPT. Prebuilt prompts are readily available, or you can create your custom prompts!

Sophie Charlwood