Create File seems to be pulling file content from the original file before updates

[Tewkes]

Hi,

I have a flow that pulls information from Excel and updates another excel sheet held on SharePoint this process seems to work fine.

I am then attempting to copy this file with an updated name to another SharePoint location.  I have these step in the flow to achieve this:

That works and creates the file in the correct folder with the correct file name. It seem to be bringing in the file contents of the original Excell file before the updates are applied in the earlier flow step.

Am I missing a step or this approach completely wrong.

[creativeopinion]

@Tewkes After the Create File action you need to add another Get File Content action to get the contents of the newly created file. Tip: Ensure you are renaming your actions to keep things organized. Also, it makes it easier to see which dynamic content belongs to which action. This is especially helpful when using multiple instances of the same action.

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this tutorial I cover:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

[Tewkes]

That does not seem to be working. An additional get file step still results in the created file having hte data of the original file before the update process ran.

Is there a flow for copying and renaming an exisitng sharepoint file i could look at.  Would it help to share the whole flow for calrity.

This seems like it should be simple but i cant get my head round for this is supposed to be working.

[creativeopinion]

@Tewkes Can you pls share a screenshot of the entire flow? It would help to provide more context. Thx!

[Tewkes]

Hi.

Please as below.

An inital step that read informtaion from an exisitng excell table and populates a "Template" excell sheet. That works fine.

First steps

Continuation to End or updates

Then im trying to copy and save this tempalte file with another file name.   Steps tried as below:  That creates a file but the content is of the "Template File" before the update process starts.