You’re offline. This is a read only version of the page.
Hello everyone,
i try the following.
A workflow that every morning open my excel file, refreshed it, saves and close again.
What would the process look like? 🤗
Thank you in advance
Hi, I experienced the same problem. My case is trying to refresh all data for my Power Query by using Workbook.refreshAllDataConnections in Office script. However, it doesn't work in Power Automate environment. After researched, this method is not going to work. Microsoft published an Article to mention that refreshAllDataConnections or other refresh data function do not work in Power Automate environment. It is a dead-end. Sad.😫
Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn
See Alichson's reply above.
Specifically, this video https://www.youtube.com/watch?v=xwvLGbyhssI
I have similar query. I have created a power Automated flow which send emails to employees on work anniversary. This flow is connected to an excel saved on my one Drive. That excel has a column with today's Date updated by Function- Today(). The emails are sent to those whose anniversary dates matches with Today's Date. For this the excel needs to be opened, refreshed and saved.
My Question- Can the today() function be refreshed everyday without opening the Excel.
If you want the candy, you got to open the jar 😊
This articles states that Refresh in Office Scripts is not supported by Power Automate. The scripts run successfully, but they do nothing and throw no errors.
https://learn.microsoft.com/en-us/office/dev/scripts/testing/power-automate-troubleshooting
I have also adopted a workaround using Power Automate to add / update rows of an Excel table when items are added / updated to a SharePoint List. The Flow that I am using described in this video.
https://www.youtube.com/watch?v=xwvLGbyhssI
However, I also have SharePoint items being deleted and I could not create a similar flow to remove rows when items are deleted because the trigger "When an item is deleted" can only be used by admins.
https://learn.microsoft.com/en-gb/connectors/sharepointonline/#when-an-item-is-deleted
I have not found a workaround, so I am just periodically opening the file and refreshing the connection manually for now.
If you want to run the refreshes automatically & most users don’t have access to the data source, then you can try adjusting this batch create & update template to your datasource:
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
