Flow Not Copying Modified CSV File to Excel Template

(0) Share

Report

Posted on by MA-08061339-0

Hi all,

I’m building a Power Automate flow with this process:

1.Trigger: When any file is modified in a specific OneDrive for Business folder.

2.Get File Content: The flow reads the content of the modified file (a CSV).

3.Notify: It posts a notification in Microsoft Teams to a user.

4.Copy Template: The flow copies a pre-existing Excel template file from a Templates folder to a new file.

5.Run Script: It then runs an Office Script on the new Excel file, passing in the CSV content form the earlier modified file.

Problem:

The flow triggers and sends the Teams notification, but it does not copy the template Excel file or run the script.
In the run history, the trigger shows “no output,” but then how am I getting the teams message from step 3 (which I set up later to include as test to the outputs)?
I’ve checked folder IDs, permissions, and connections. A simple test flow with just the trigger and a Compose action works.

Question:
Why is the flow not running the script after the Teams notification? What could cause the trigger to have “no output” even though the notification works? How can I debug this further?

Thanks for your help!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

David_MA 14,835 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Please share screen shots of the actions in your flow and how they're configured so we can see your approach. Also, share the script you are calling as well.

However, you should address a potential issue with your trigger and the get file content action in your second step. Do you have a trigger condition so the flow only triggers if the file is a csv file? If not, how do you ensure that when you get the file content it is getting the content of a csv file? Based on your description, I am not sure how you're getting the file content from step 2 into the spreadsheet you are creating from a template. Seeing the flow will help to show the process.

Was this reply helpful? Yes No
MA-08061339-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi David,

Screenshots of the flow start in my original post (just edited) and continue on here. Any advice you have would be super helpful!

Was this reply helpful? Yes No
David_MA 14,835 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Now that I see the flow, you are running an Excel script. I have found that this works best when you save the script as an osts file in OneDrive. Then use this action instead:

The folder path shown above is the default that Excel will export the script to. Are you running the script on the file generated before the run script action. Normally the flow would fail if this were happening, but sometimes a lock is placed on the Excel file. It takes about 10 minutes for the lock to be released. If switching to the run script from SharePoint does not resolve the issue, try adding a 10-minute delay after you create the file. In addition to the lock, it could also be that the run script action is starting before the file is fully created, and the delay will ensure the file is fully created before running the script.

Was this reply helpful? Yes No