
Announcements
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:
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:
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?
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?