Unanswered

How to Refresh Linked Data Types (Stocks & Currencies) via Power Automate?

(1) Share

Report

Posted on by AA-20020912-0

I am trying to refresh Linked Data Types (Currencies & Stocks) in an Excel file stored in OneDrive using Power Automate.

I know that workbook.refreshAllDataConnections() can refresh queries, but this does not refresh Linked Data Types like currency exchange rates or stock prices.

I also checked Excel Scripts in Power Automate, but there is currently no function like refreshAllLinkedDataTypes().

Has anyone found a workaround to refresh Linked Data Types using Power Automate?

Looking forward to any suggestions. Thanks in advance! 😊

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

CU20020946-0 7 on at

Like (0)

Report

You can configure refresh setting automatically in excel settings. You can put to On File open or Automatically Every 5 minutes and call Excel actions from power automate that will trigger this setting.

Automatically refresh linked data types - Microsoft Support

Was this reply helpful? Yes No
AA-20020912-0 5 on at

Like (0)

Report

The solution mentioned by "CU20020946-0" is a manual process. I want to refresh the table with linked data type (currency) with power automate.

The "Data Types Refresh Settings" work only if the file is open.

Was this reply helpful? Yes No