Forum Discussion
Use dynamic content
Hi community
I’m trying to add a Dataverse destination as dynamic content, but I’m unsure what value should be used for this. I’m also not certain if this functionality even exists.
In the screenshots below, I’ve successfully added a Lakehouse as dynamic content, which works perfectly. In the second screenshot, you’ll see how it appears when selecting the Dataverse connection (without dynamic content).
Thanks in advance!
Hi dibeau,
At the moment, only Lakehouse, Warehouse and KQL Database are supported in the dynamic content section of the copy activity. You may create different copy activities with other connections and determine which copy activity is run based on a switch statement (I know this is not easy to maintain, but a workaround you could try).
2 Replies
- FabianSchutSolution Sage
Hi dibeau,
At the moment, only Lakehouse, Warehouse and KQL Database are supported in the dynamic content section of the copy activity. You may create different copy activities with other connections and determine which copy activity is run based on a switch statement (I know this is not easy to maintain, but a workaround you could try).
- AnonymousNot applicable
Hi dibeau ,
As FabianSchut mentioned, dynamic content is currently only supported for Lakehouse/Data Warehouse/KQL Database object ID.
You can refer to below document:
How to copy data using copy activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.