HI
Realistically you can but it would be something you should do in Power Automate.
1. I would do steps 1-2 in one Flow.
Then save the path to the new file, either sending it back to the Canvas App to hold onto its path, or make sure you have an Environment Variable where you have the path (minute the filename) that can be read in Flow for steps 3 and 4
2. You would let the users fill out data. Whenever you want to save (either each row or not), you would pass that information to the second flow.
the second flow would receive the data and the file name (or possibly the filename and entire path).
The flow would dynamically fill in the File Name from the Input you passed from the Canvas App.
The only thing not clear to me is... do people need to go back hours , days, weeks later to fill in the sheet?? Will there be multiple ones that they can edit at later times.
The last question is because if you need that, you need to have a link table. A table that would map the old name and path to the new (copied) name and path, then in the UI, they would select which file they want to modify, you would instead grab the COPY names based on the original name.
But I am not sure you even need that, but its all there as an option.
Yes, you can do what you want, I merely expression a couple ways of doing it.
