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...
Hello RobElliott
OK, I see now, the manually selected file in the field "File" triggers the list of tables in the next field "Table". BTW, the option Add dynamic content in the field "File" is then useless, isn't it?
Anyway, I have created 16 more cases.
Copy the action is a good idea, but it does not work in my case - "Failed to find xxx in definition" (I have copied the Excel action in Case 2, created next case, clicked new action and selected My Clipboard)
Paste the action outside the Switch case then drag it inside.
RobElliott, thank You for the magic touch 🙂