Dynamically Change Notebook ID for each Workspace

[MisterSmith]

Hi All

I want to set up a pipeline that dynamically selects the correct workspace and notebook, depending what environment/workspace the pipeline is in.  I am using the system variable to select the correct workspace.  However it doesn't provide a dropdown of available notebooks.  Therefore I am having to use the notebook id.  But I suspect the notebook id will change once it is deployed to a new environment/workspace.  Therefore I would like the pipeline to dynamically select the correct notebook id.  Can this be done.

Thanks

Neil

[KhagendraWagle]

Please visit the post and try if it helps to solve your problem. 

https://community.fabric.microsoft.com/t5/Data-Pipeline/Set-NotebookId-dynamically-in-notebook-activ... 

[kharithaas]

Hi 

i have tried to make the workspaceid dynamically, but cant se any notebooks - its empty

[MisterSmith · Accepted solution]

Put a value into the notebook field, save and exit the pipeline.  Reopen the pipeline and delete the notebook value.  The list should now be available.  In short the pipeline needs to be refreshed.

[MisterSmith]

This looks to have been resolved by Microsoft.  When dynamically setting the workspace id, the list of available notebooks is now available in the drop down box.  Therefore there is no need for me to create a variable to dynamically set the notebook id for each workspace.

[v-kongfanf-msft]

Hi @MisterSmith ,

Based on your description, to set up a pipeline that dynamically selects the correct workspace and laptop based on the environment, you can use a combination of system variables and mapped configurations. 

Refer to related document:

Set Variable activity - Microsoft Fabric | Microsoft Learn

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.

[MisterSmith]

Hi @v-kongfanf-msft 

I am aware that I can I can use the variable activity to construct a variable.  However it is the makeup of the variable that I am quering.  How can I dynamically call the correct notebook id depending on the workspace.  I am unsure on how I could do this.

thanks

Neil