web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / The problem of opening...
Power Automate
Answered

The problem of opening an Excel file and executing a script in automatic flow.

(0) ShareShare
ReportReport
Posted on by 1

在 FLOW 中,提示指示执行成功,但 EXCEL 文件尚未更新。
EXCEL 文件(保存在 sharepoint 中)具有 Power Query 的执行过程。在执行过程中,调用了其他 sharepoint 中的 EXCEL 文件(我将其更改为其他数据源、LIST 和文件中的其他 SHEETS 也不允许)。
脚本中只有一行代码,
工作簿。refreshAllDataConnections();
提示指示执行成功,但 Excel 文件尚未更新。
手动执行脚本可以成功刷新。

Categories:
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @wanghongmou123 ,

     

    I replied to you in the same post here.

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 445

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 300

Last 30 days Overall leaderboard