To enable automatic updates, simply refresh the Power Query connection to your folder. Excel will scan the folder for any new files and seamlessly integrate them into your existing dataset.

The When a file is create or modified trigger has quite a few options available however there is no options to control how often you want Power Automate to check.