dynamic library variables

Hi krhacke 

Thank you for reaching out to the Microsoft Fabric Community Forum.

We understand you are encountering an issue iwth dynamic libarary variables. As Library Variables are designed to store reusable configurations at the workspace level and are referenced using @pipeline().libraryVariables.<variable_name>.
 

Dynamic Concatenation (@concat('pipeline().libraryVariables.',json(pipeline().parameters.TaskStep.Notebook).NotebookId))may not work as expected because the expression engine treats it as a literal string or fails to resolve the GUID.

Library variables are resolved at runtime, but the dynamic construction of the variable name may not be fully supported in the current preview, as the engine might not dereference the concatenated string to the actual library variable.

Dynamic key resolution (e.g., pipeline().libraryVariables[variables('v_notebook')]) isn't supported in the current preview, requiring hardcoded keys instead.

To resolve this, consider a workaround that aligns with ADF’s current capabilities while achieve the goal of dynamically selecting a notebook based on a JSON parameter.
 

1. Using a Switch activity  to map the JSON parameter to the corresponding library variable explicitly, avoiding dynamic key concatenation.
   
   
2. Set up library variables in the ADF workspace, mapping them to notebook paths or GUIDs (e.g., nb_table_transformation, nb_other_transformation).
   
   
3. Create a pipeline parameter TaskStep to include the notebook ID in JSON format (e.g., {"Notebook": {"NotebookId": "nb_table_transformation"}}).
   
   
4. Extract Notebook ID: Use a Set Variable activity to extract the notebook ID from the JSON parameter and store it in a variable (v_notebook_id).
   
   
5. Use a Switch Activity: Add a Switch activity to map the notebook ID to the corresponding library variable:
   
   Case: nb_table_transformation: Set the notebook path to@pipeline().libraryVariables.nb_table_transformation.
   Default Case: Add a Fail activity or a no-op activity with a message like "Invalid NotebookId".
   
   

This approach ensures explicit mapping of the notebook ID to the library variable, avoiding dynamic concatenation issues.

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
 

Thank You!