- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Alternate key in Copy Activity for Dataverse expects bool
Hi All,
I am trying to create a pipeline where my source is file and i'm trying to upsert the data into dataverse. for that I want to pass the alternate key in dynamic format. But while passing the alternate key( which is actually a string and parameter of the pipeline) I am getting below error:
Expression of type: 'String' does not match the field: 'alternateKeyName'. Expected type is 'bool'.
Could any one help? How can alternate key be of type boolean?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was having the same problem. The answer suggested is no help at all. The Alternate Key Name is a field where you provide the name of the key column - the column used as a key to perform a merge or upsert. It has to be the name of one of the columns in the table. I know that we can remove the error by putting a parameter with a value of True or False into it, but that will not tell the merge activity which column to use, resulting in an error when we run the pipeline.
I did note that when the error appeared, it was in yellow rather than red, so I saved the pipeline anyway (with the correct string in place of the required bool) and ran it and everything worked. So this appears to be a display bug only.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @Barnita
I briefly restored your question.
After testing, you can try the following methods. Create a new parameter.
No errors are reported at this time.
For more information you can refer to the following documents.
Expression and functions - Azure Data Factory & Azure Synapse | Microsoft Learn
Configure Dataverse in a copy activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Charlotte,
Thank you for your reply.
I understand that if I use a parameter of type boolean, no error will be shown.
But alternate key has to be a string. Boolean can hold only true or false value. To be able to pass a proper key (example- ID, Name) I have to pass a string to this alternate key box.
Can you please let me know why it expects a boolean exactly?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @Barnita
Pipeline parameters are available as strings. You can refer to this document hope it help: Pipeline parameters and variables - Azure Data Factory & Azure Synapse | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-02-2024 07:12 AM | |||
04-30-2024 05:58 AM | |||
08-28-2024 03:58 PM | |||
02-20-2025 11:40 PM | |||
11-04-2024 01:13 AM |
User | Count |
---|---|
4 | |
3 | |
3 | |
1 | |
1 |
User | Count |
---|---|
9 | |
8 | |
7 | |
6 | |
4 |