ms fabric how to dynamically set the Copy activityTable Append or Override Action with an expression

[davemc69]

I haven't been able to find any thing related to setting this property dynamically. 

[Anonymous]

Hi @davemc69 ,

For the time being this is unlikely, an interim solution is to create a switch on the workspace ID and copu your activity using the correct connection for that environment.

Refer to below similiar solution:

Solved: Dynamically set source connection in copy activity... - Microsoft Fabric Community

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com