“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?”
Category: Excel
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?”
How to get selected Excel row(s) in a Power Automate flow
“Should I use ‘Get a row’ or ‘List rows present in a table’ to get a specific Excel row in my Power Automate flow?”
Export Planner assigned users into Excel with Power Automate
“I’m stuck on exporting Planner tasks to Excel because some task are assigned to multiple users and Power Automate doesn’t store names in a string!”
How to send a reminder on a date stored in Excel file with Power Automate
“The reminder flow should send an email 2 days before a date stored in Excel file, but Power Automate sends email for each row, the condition doesn’t work.”
How to import tasks from Excel into Planner with Power Automate
“I’ve got 100s of tasks in an Excel file that I’d like to import into Planner, is that possible with Power Automate?”
Format multiple choice SharePoint column in .csv using Power Automate
“How can I format the value(s) from multiple choice column in a .csv file created by Power Automate? It shows just an ugly string.”