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 with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
CreativeExpirements 5 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No