I'm trying to build a Query in Excel, which I've saved in OneDrive (synced with the PC). This file will be retrieved by Flow and attach to an email.
The source data is a folder, and it will iterate and compare files to get only the unique rows through an ID.
I was planning to just set it to refresh every x minutes or so, and then Flow will pick it up to send as an attachment, to minimize manual steps. But then it would only refresh if the file is open? Is this there a way to automatically refresh data without actually opening or touching the file?