“I have email texts in an Excel file including new lines but when I send the email with Power Automate it removes all of them!”
Category: Excel
Get more than 256 rows from an Excel file in Power Automate
“I’m trying to turn my Excel file into a csv, but the Power Automate flow exports only the first 256 rows, how do I get the rest…?”
Add unique ID to rows in Excel file for your Power Automate flow
“There’s no unique ID in my Excel file making it hard to use in Power Automate flow, is there an easy way to add such ID?”
How to find Excel rows missing in SharePoint list (Power Automate)
“My Power Automate flow is adding rows from Excel into SharePoint daily, but it’s so slow, is there a quicker way to find the missing rows?”
Building a time tracking solution using Power Automate flow
“I’d like to keep tracking of the time I spend on various tasks, is there maybe a way to build such solution using Power Automate flow?”
How to get date from Excel as a date in Power Automate flow
“I have an Excel file with dates in one column, but Power Automate returns a number instead of the date, how can I fix it?”
Update multiple Excel rows with the same key in Power Automate
“I’m trying to update multiple rows in an Excel file with Power Automate, but it keeps overwriting the data on the first row!”
How to add a row to a new Excel sheet with Power Automate
“I’m able to create a new sheet with Power Automate, but how can I then add a row in this new sheet? It keeps adding to the old one.”
Remove Excel rows with empty value with Power Automate
“Is there a way how could I use Power Automate to remove rows from an Excel table where a specific column is empty?”
How to get the highest value from Excel rows in Power Automate
“I use Power Automate to process results of a Forms quiz, what’s the best approach to get the highest points value from the Excel file?”