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.

Power Automate can work with Word documents, Excel worksheets and other Microsoft software to help users update reports, modify documents, reply to emails and a multitude of other routine tasks.

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.