“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?”
Category: Excel
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.”
Export multiple Person or Group column into .csv table in Power Automate
“I need only the user name from the Person or Group SharePoint column that Power Automate just exported into .csv table, not the full user data.”
Quick way to export SharePoint list to Excel file using Power Automate
“I’m trying to automate export of SharePoint list into an Excel file, but Power Automate takes ages to finish. How can I make it faster?”
Skip empty row(s) when processing Excel file in Power Automate
“My Power Automate flow errors out because there are blank values in the processed Excel file, how can I skip the empty row(s)?”