cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KSven
Kudo Collector
Kudo Collector

Dataflow standard v2 | Integration of multiple choices

Hi lovely Community,

 

data integration via Dataflow for a "CHOICE" Column work fine with a single value like this:

"999740000"

 

But how does it works for multiple "CHOICES". Already know it works fine via Power Automate or Excel Add-In like:

"999740000,999740001,999740002"

 

With Dataflow standard v2 I just get the follwing Error:

T-TYP,588129f8-0ee4-4efb-a38d-034c72a33e2c,,"Table crefb_producttype field crefb_market is a crefb_market Choice data type. The value 999740000,999740001,999740002 is not a valid value for the crefb_market choice field."

 

How does it works with Dataflows and multiple choices? Have choosen Text Type for column..

 

BR,

Sven

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @f3dvr ,

 

I already have a running support ticket. Here the reply from MS for this issue:

KSven_0-1619199324882.png

 

Let's wait for this..

 

BR,

Sven

View solution in original post

7 REPLIES 7
dpoggemann
Super User
Super User

hi @KSven,

 

Is the crefb_market field a "Choices" type or is it a "Choice" type?  The error appears to reflect it is the latter which would not allow setting the value to what you identified.  You would need to have the field in the dataverse defined as a Choices type.  Can you also show the code you are trying to execute to help diagnose?

 

Thanks much,


Drew 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Hi @dpoggemann ,

 

thank you for your reply.

 

Here's my Target Column incl. Choices:

KSven_0-1616762234566.png

KSven_1-1616762248388.png

And my Column in Dataflow (single Values are working, combined ones not...) :

KSven_2-1616762379831.png

And here's the part of my last code steps incl. Values for Choices:

....

  #"Replaced value 2" = Table.ReplaceValue(#"Changed column type 1", each [crefb_market], each if [crefb_market] = "111" then "999740000,999740001,999740002" else if [crefb_market] = "100" then "999740000" else if [crefb_market] = "010" then "999740001" else if [crefb_market] = "001" then "999740002" else null, Replacer.ReplaceText, {"crefb_market"}),
  #"Filtered rows" = Table.SelectRows(#"Replaced value 2", each ([crefb_oid] <> "#(001A)"))
in
  #"Filtered rows"
 
BR,
Sven
f3dvr
New Member

hi @KSven

 

I have the same problem.
This is my step.

https://twitter.com/f3dvr/status/1383200667494277121 

 

MS support can't reproduce.

I need help too!

Hi @f3dvr ,

 

I already have a running support ticket. Here the reply from MS for this issue:

KSven_0-1619199324882.png

 

Let's wait for this..

 

BR,

Sven

GingerBread007
New Member

I still have this issue. Did you guys get a solution?

Did they ever reply to your ticket with a solution?
Currently running into the same issue when trying to import into a (multiple) choice column through Dataflow.

GingerBread007
New Member

No, we ended up using classic workflows from Dynamics for our use case.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,354)