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

Announcements

News and Announcements icon
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,290 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard