Unanswered

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

(0) Share

Report

Posted on by 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:

Screenshot 2024-01-31 180922.png

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion

10,508 Moderator on at

Like (0)

Report

Copy link

Link copied!

@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

Was this reply helpful? Yes No

Tewkes 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tewkes 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No