Forum Discussion

Krishna09's avatar
Krishna09
Helper III
3 years ago
Solved

Alternate key datatype in dataverse dataflow

Hello everyone, I am creating upsert(update and create new row) dataflow in dataverse. sharepoint is my data source and importing it to dataverse existing table. So I created a key in dataverse tabl...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Krishna09 ,

    I suggest you temporarily change the data type of the column to text and try again, to check if it's the problem of date type.

    Also, please see if this document can help: Alternate keys in Microsoft Dataverse (linkedin.com)

     

    Best Regards,
    Community Support Team _ kalyj

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

Krishna09's avatar
Krishna09
Helper III
3 years ago

v-yanjiang-msft 

- I changed data type of date to text in power query,

- Created text column and created new key in dataverse table.

 Now I have below error. How to solve it?