Knowledge Base

💡 Encountering errors writing the correct formula to Excel using the action “Write to Excel worksheet”? Use “Activate cell in Excel worksheet”, followed by “Send keys” to write the formula instead. Remember to insert the special key {Return} at the end.

💡 If you are not using the premium version of the Microsoft Power Automate for desktop, it can be rather tricky to retrieve the logs for the previous runs of a particular desktop flow. Until now.

💡 If you need to read a large Excel file containing a lot of data, you should consider using the database actions instead of the usual Excel actions.

💡 Do you need to navigate to multiple URLs iteratively? Each of the URLs contains dynamic values which need to be read from an Excel spreadsheet.

💡 How to filter and split a datatable into a list of datatables