Data Refresh not working in Type Script called by Power Automate

Question

I am trying to grab values (total number of members) from a Dynamics Real Time Segment

I have an Excel spreadsheet with a link to the Datverse table

I have a Type Script that updates the data connection, finds the values I want and copies them to another table.

All of this works fine if I run the script from within the app.

I have a flow that runs the script.

If I run the script from the flow, the script runs fine, no errors.  All the other steps in the script work as expected.

But the refresh statement doesn't do anything.

Any suggestions?  Thank you for your help.  Guy

Answer 1

By the way, this isn't really a Power Automate issue. It is really an issue about the way all the Microsoft tools work together, particularly Excel, TypeScript, Dataverse and Power Automate. Although Microsoft make a big selling point of how good it is these all work togther, there is a big hole when it comes to getting support to link them together

Answer 2

Hi Naren,

I do not have the question, "Was this reply helpful? Yes / No." or I would answer yes, it was helpful.

I only have the question, "Did this reply resolve your issue? Yes / No". And it didn't resolve the issue, so I answered No

Guy

Answer 3

Good day! Updated information. We are here to assist you.

Meanwhile, since many other users also mistakenly post about Power Automate issue in this community, I’d like to make a summary of redirection so other users can refer to your reply more easily.

---

Issue Description:

Data Refresh not working in Type Script called by Power Automate

---

Environment:

Microsoft Business Power Automate.

---

Redirection:

I understand how important it is to get this issue resolved. However, since our community is mainly focus on the Microsoft 365 and Office built-in features and this specific query might require more specialized assistance, I recommend Microsoft Power Platform Community Forum Thread .

The experts and other users there have a wealth of knowledge and should be able to provide the detailed help you need. The Microsoft Power Platform Community Forum Thread  is a great resource for specialized assistance.

---

Meanwhile, if you think my redirection above is helpful for this Power Automate issue, could you please use the feedback tool to send feedback for us? (pictured below)

As other users may also seek information about Microsoft Power Platform Community Forum Thread within this community, your valuable vote will assist others facing similar challenges in finding solutions more efficiently and directing them to the appropriate Copilot resources.

Please accept my apologies for redirecting you to different community as the members in the category posted focus on the users with out-of-the-box concerns on Microsoft 365, and have limited knowledge on the Power Automate, so to get the fast and better assistance, we have redirected you in the correct path.

Greatly Appreciate again for your patience and understanding and thank you in advanced for your cooperation.

I wish you keep safe and having a great day as well! 😊

Sincerely

Naren | Microsoft Community Moderator

Answer 4

Thank you for the suggestion Naren, I already posted there too. Guy

Answer 5

Dear Mr. Boswell,

Good day! Thank you for contacting the Microsoft Community. We are here to assist you.

It sounds like you're encountering a common issue with data refresh in Power Automate. This may be due to several factors like Data Refresh Settings, Data connections, Power Automate Limitations or Permissions.

---

I understand how important it is to get it done. However, since our community is mainly focus on the Microsoft 365 and office general and build-in features issues and this specific query might require more specialized assistance, I recommend visiting the Microsoft Power Platform Community Forum Thread The experts and other users there have a wealth of knowledge and should be able to provide the detailed help you need. The Power Apps Community Forum is a great resource for specialized assistance. 

Please accept my apologies for redirecting you to the related team support, as the moderators in this community have limited resources and permission to verify the backend information and to get the quick and better assistance, we requested for this.

I hope you are staying safe and well! Have a great day and take care! 😊 

Sincerely, 

Naren | Microsoft Community Moderator