cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Import into picklist

Hello community,

 

I had problems to import string data into a picklist/optionlist.

In first run of dataflow it works fine on different entities.
Picklist is always the same.

In next run with some entities it works, in other there are strange error messages:


Either:
Error code: 0x8004431a, Message: A validation error occurred. The value 999999 of 'cr847_kcolor' on record of type 'cr847_dcars' is outside the valid range. Accepted Values: 742200000,742200001,742200002,742200003, ...

That's really funny, because imported colors are strings like red, blue and so on and sure not '999999'


Or: 
"Data type mismatch with [ cr847_dcars.cr847_ktyp ] - Integer <-> String"

And again: Imported 'types' are strings like coupe, van and so on.

 

In first run there was no problem to convert a string into related option field.

I.e. 'red' imported as '742200000'


No, it didn't work to recreate this entity attribute again. So it is empty, at works like a first import. 😉


Any idea to solve?

Why it imports in two entoties and in two others, there are errors.

 

 

Thanks for help,

AndKan

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Import into picklist

Hello Eric,

your are right: error message makes sense, but DataFlows should be smart enough
It is smart ... and mysterious

1st error: "Error code: 0x8004431a, ... The value 999999... is outside the valid range. Accepted Values:..."
There was the value in picklist missing ...
Solution: Added the missing value into picklist and import works also.


2nd problem:
I recreated both entities new.
DataFlow import into pickuplist works fine.

Then I added an m:1 relationship and import fails again.
???

Related entity had no primary key; normally this is created with first import from SQL primary key.
Missing destination field cr847_entity02.cr847_id_entity01 in scheme
And pickup list has error Integer <-> String again.
So I removed relationship and: Import into picklist works again.
???
Solution:
- First I added a primary key manual.
- After that, I added m:1 relationship.
This workflow removes the error "Missing destination field ...".
And now the dataflow import works, including picklists.

 

And just another one:
I thought, my entity is crashed at all:
"General error","An item with the same key has already been added."

Of course there is a record with this key already, because Dataflow runs again. I'll try to update data.

This is a wrong error message ... It means: There is a duplicate entry in pickup list.
???
Solution:
Yeah ... you can enter any values like 'red', 'Red', 'reD' in pickuplist. No problem.
But you can only case-insensitiv import into picklist.
Otherwise you get the general error above.

 

Best regards,

AndKan

View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Import into picklist

Hi @AndKanPA,

Just trying to get a bit more context on your Dataflow. I assume your loading your data to an existing entity since option set  destination type is not supported yet for new entities? Option set fields are represented by a key value pair where the key is an integer value and what's saved in the records. That said, the error message makes sense, but DataFlows should be smart enough to automatically map the data source label/text to the option set item display name. Would it be possible to share screenshots of the Edit Query and Mapping steps of the Dataflow?

Also, try to edit the flow, save and rerun to see if it works again or even create a new one?

Thanks

Highlighted
Helper III
Helper III

Re: Import into picklist

Hello Eric,

your are right: error message makes sense, but DataFlows should be smart enough
It is smart ... and mysterious

1st error: "Error code: 0x8004431a, ... The value 999999... is outside the valid range. Accepted Values:..."
There was the value in picklist missing ...
Solution: Added the missing value into picklist and import works also.


2nd problem:
I recreated both entities new.
DataFlow import into pickuplist works fine.

Then I added an m:1 relationship and import fails again.
???

Related entity had no primary key; normally this is created with first import from SQL primary key.
Missing destination field cr847_entity02.cr847_id_entity01 in scheme
And pickup list has error Integer <-> String again.
So I removed relationship and: Import into picklist works again.
???
Solution:
- First I added a primary key manual.
- After that, I added m:1 relationship.
This workflow removes the error "Missing destination field ...".
And now the dataflow import works, including picklists.

 

And just another one:
I thought, my entity is crashed at all:
"General error","An item with the same key has already been added."

Of course there is a record with this key already, because Dataflow runs again. I'll try to update data.

This is a wrong error message ... It means: There is a duplicate entry in pickup list.
???
Solution:
Yeah ... you can enter any values like 'red', 'Red', 'reD' in pickuplist. No problem.
But you can only case-insensitiv import into picklist.
Otherwise you get the general error above.

 

Best regards,

AndKan

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,278)