Hi! I created an Excel file that reads data from a SQL Server database, then placed the Excel file in a SharePoint site's Documents. I created a Power Automate Flow to grab the file and e-mail it to people (Recurrence... Get file content... Update file... Initialize variable... Send an email notification). The data in the Excel file is from a week ago, when I originally added it to the SharePoint site. Once the user gets the file, it runs a query to refresh the data and show current information. But is there a way to refresh the data before e-mailing it? I'd like the users to see current data when they open the file and not wait for 10 or 15 seconds to see it. What am I doing wrong? I would think the "Update file" step would... well... update the data, but it doesn't seem to. For my query properties, I have "Enable background refresh" and "Refresh data when opening the file" checked. Or is there just not a way to refresh the file while it just sits on the SharePoint site? Does it only refresh the data when someone opens the file? Thanks for any assistance!
