
Hi,
I have two Excel files stored in SharePoint. In the first file, we input data. The second file uses the first file as a data source, and with Power Query, some columns are removed.
Every time a change is made to Sheet 1 of File 1, I want the changes to be automatically replicated in File 2.
Currently, when I manually refresh the data connection in file 2 , the changes are reflected. However, the automatic or scheduled refresh is not working with in Excel File .
Can this be implemented using Power Automate?