Learn how to READ rows from dynamic files here:
• Power Automate: Use Excel connector with d...
(Disclaimer: video quality is not great!)
Jump to 6:00 to see how to manage Excel action with dynamic files.
00:00 - 1:12 Intro and use case explanation
1:13 - 4:10 Creating flow and generating base code for dynamic files
4:12 - 6:00 Add steps to create a copy of template everytime the automation runs
6:00 - 8:40 Change the "Add rows" action to use dynamic files
8:40 - 10:17 Test file and goodbye :)