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...
Zdenek_Moravec no it's not possible because the Add a row into a table action won't know which table columns to add to the action when you are building the flow so you will always get an error when you try to save it. You can copy the action to your clipboard and then add it to each switch case, but you will need to change the file in each case.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
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 🙂