Importing animals table

[powerup123]

Hi.

I got an error

There is a data type mismatch between the dataflow's source query column value and the destination entity field type. The source query column that is mapped to the Common Data Service as_Animal entity's as_microchipid field contained 5656565656 but the Table's field requires IntegerType data type.

But in my power query everything is ok - microchip id should import as int.64 type

[AhmedSalih]

Hello, @powerup123. What is the Data type of your Dataverse Column that will be mapped to the Microchip column in the source Excel file? Is it a whole number? 

---

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[CN_05]

Hello @AhmedSalih 

I am having the same issue.  Mine is a whole number but for some reason, my import is failing

[kashjoyin]

I used whole number too but getting a failure on microchip values that are more than 9 integers. I am wondering if there is a limit on the number of integers allowed. Have you resolved it yet?

[Oyin]

@kashjoyin no. of dm exceeded. The current location formula did not work for me as well and I had to move on. If you can create a Shelter Name column in the Animal table, you should be fine. Here's my formula: 

'Initial Shelter'.'Shelter Name'

( if it is named like this in your shelters table)

Glad to know that the Microchip field now works well as text 

[kashjoyin]

Ok. Thank you. I will try this formula out

[kashjoyin]

Ok. Thank you. I will try this formula out

[Atinubel2024]

Hello Oyin, the current location was giving errors for several days too, but I had to compare the way the words were spelt, upper case, lower case, the signs and the arrangement of the words. I had to write all the formulas word for word before the system accepted.

[Oyin]

Good to know it eventually worked for you.