John Liu Blog

Every drop counts

Power Automate with Excel

When we work with Excel in Power Automate, we might need to remove the filter on worksheet to be able to create a data table. If filter is enabled, Excel Online for Business connector might not be able to create a data table. We can create Office Script within Excel Online for Business. To save the script so Power Automate can use it, we must open the file in Excel Online (the web version).

Posted by John Liu Friday, February 13, 2026

Configure application auto start after reboot

To configure application auto run after current user login: First login in as the user Ctrl + R to start run, type in “sheel:startup” (which is folder like C:\Users\john\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup) Create a shortcut to the application required with appropriate parameter Note: you may need to redo the above each time following application reinstall/upgrade

Posted by John Liu Saturday, January 28, 2023

Automate email process

Note: When design Power Automate flow, for file path or folder path values, try not to pick from the dropdown list, but instead type in the actual name. When picking from the dropdown list, the designer will undercover save the actual internal physical ID of the location as well. If you then try to export the package and modify it for a different folder, it will be hard as the physical ID will no longer match with the one for the new location.

Posted by John Liu Monday, March 7, 2022