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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fix errors in File Nam...
Power Automate
Unanswered

Fix errors in File Name and File Content when auto-populating excel template

(0) ShareShare
ReportReport
Posted on by 21

I have created a flow where I can pull the data from one excel table and auto-populate that info into an another excel template. But i'm having a problem since the file name does not match the content that it was passing

 

Here's my current power automate flow:

 

lo_ori_0-1713451482634.png

 

the flow works but the problem is that the file name it populates in this 'copy file action' and the 'data it's populating' is not the same. for example, here's my source of data:

lo_ori_1-1713451713020.png

 

1. The file name I set is MMddyyy - 'doctorsName'. The file name output shows the doctors name in row 2

2. The actual file content it populated to the excel template is the data for doctor in Row 3

Summary: File name is for Doctor in Row 2 - Body is for Doctor in Row 3

 

I've investigated that the reason it keeps on happening is because it overwrites the original excel template (which shouldn't happen) that's why it's not matching. How can I correct my flow?

 

 

 

 

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,278 Most Valuable Professional on at

     @lo_ori 

    It looks to me as though you are copying the same file over and over again to the same destination and are just changing the file name.  Am I correct?

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard