Forum Discussion
Power Automate - set filename by variable in Add row to Excel action
I have a Form for employees. One text field is department name. I add the survey row into a particular department excel workbooks on sharepoint, i.e. Covid-mp.xlsx Covid-odsh.xlsx Now I use sw...
I might be too late if you've already gone another route, but this post and video by John Liu might help you use dynamic Excel file names... I've used these methods to add rows to Excel files which have a different name on each flow run. It's a little advanced, using SharePoint http requests, but it's quite cool once it's working!
Please see https://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow and https://www.youtube.com/watch?v=64lSykOYmzI
Hope this helps!
Sandy
Hello Sandy Ussia
Thank You for the link. The guide is really very advanced to me. I will stay by the basic level and I will study this guide once I get more advanced skills in power automate 😉
