Showing results for 
Search instead for 
Did you mean: 

Dynamic excel table names

When adding a row to an Excel table, I would like to set the table dynamically from a Sharepoint list as below:


Unfortunately, it is currently not possible to set table or file names dynamically as evidenced by the error.


My workaround is to use a switch, but this is very inefficient as I have to duplicate the same actions for each switch path.  The issue is also mentioned here.


Please enable us to dynamically set Tables!




Status: New
Regular Visitor

Hi, Can I get some information about the Switch workaround. I got the same issue as all the excel files I have updated everyday and Table name changed to some GUID value.

It will be good to try the switch part and see if that fix my issue.