cancel
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:

image.png

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!

 

Thanks,

Chris

Status: New
Comments
Anonymous
Not applicable

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.

 

Thanks

Harry

MonicaW
New Member

Hi @Murderbot and @Anonymous 

I'm not sure if you resolved your issue. Maybe you can try what I've done to add a row into a dynamic excel file table named "Table1". My custom value express looks like concat('Table1', ''). For @Anonymous , if you have an GUID variable, you can try the express concat(variables('varGUID'), ''). Share us your result 🙂