Excel Archives - Let's POWER Automate

Get source and drive id for files in SP with Power Automate

“I’m using the Office actions in my Power Automate flow, but they don’t accept the environment variable, how do I get this source and drive id?”

Posted on October 8, 2023October 8, 2023 by Tom

“I have a Power Automate flow checking dates in Excel and sending reminders, can I improve it to send a single email with more rows?”

“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!”

Posted on April 19, 2023April 19, 2023 by Tom

“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…?”

Posted on April 2, 2023April 2, 2023 by Tom

“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?”

Posted on March 29, 2023March 30, 2023 by Tom

“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?”

“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?”

“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?”

Posted on September 4, 2022April 2, 2023 by Tom

“I’m trying to update multiple rows in an Excel file with Power Automate, but it keeps overwriting the data on the first row!”

“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.”