Dataflow standard v2 | Integration of multiple choices

(2) Share

Report

Posted on by KSven

182

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

Categories:

Microsoft Dataverse

Tables

Dataflows

I have the same question (0)

All responses (9)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

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

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

Hi @dpoggemann ,

thank you for your reply.

Here's my Target Column incl. Choices:
And my Column in Dataflow (single Values are working, combined ones not...) :
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

Was this reply helpful? Yes No
f3dvr 2 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

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!

Was this reply helpful? Yes No
Verified answer

KSven 182 on at

Like (2)

Report

Re: Dataflow standard v2 | Integration of multiple choices

Hi @f3dvr ,

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

Let's wait for this..

BR,
Sven

Was this reply helpful? Yes No
GingerBread007 4 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

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

Was this reply helpful? Yes No
CreativeExpirements 5 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

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.

Was this reply helpful? Yes No
GingerBread007 4 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

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

Was this reply helpful? Yes No
ell10706 112 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

This is occurring for me, as well. Using Dataverse with the OData connector, my "Choices" fields which have multiple choices selected are throwing the same errors on import. Anyone seen an answer or workaround for this that doesn't involve manually editing the data?

Was this reply helpful? Yes No
xClaudioWeberx 4 on at

Like (0)

Report

Re: Dataflow standard v2 | Integration of multiple choices

I have the same problem, when I selected the table with multiple choices it happened

Was this reply helpful? Yes No