Dataflow standard v2 | Integration of choice value boolean

[KSven]

Hi lovely community,

already have read some messages about dataflow actions with a choice column.

Have set a new dataflow standard v2 with one boolean choice column:

Dataflow:

Target column:

Choice of column with id:

With this setting I will get the following Error:

O-GEB,823650bb-19d5-4e5e-823f-84fa5ff7c590,,Table contact field crefb_bonusrelevant is a field_security_permission_type Choice data type. The value 0 is not a valid value for the crefb_bonusrelevant choice field.

Like on my Dataflow Screenshot, I've set it the column as Whole Number type cause with checking Odata feed my target column is also Whole Number type.

With Dataflow standard v1 it worked with the string values "Zulässig" and "Nicht zulässig", already have tried but this is also not working anymore.

So do I need to open again Support Ticket related to standard v2 dataflows? Or is there a reson for it?

BR,

Sven

[dpoggemann]

Hi @KSven,

Check out the following post which should help you set the Choice value from your dataflow...

Dataflows in CDS (agarwalritika.com)

Hope this helps!

Thanks,

Drew

[KSven]

Hi @dpoggemann ,

I already know this page, thank you for that, but this is about a normal Choice Column, not the security boolean one. Already have the right values for it like described in your link. 

So unfortunately it doesn't help me.

BR,

Sven

[dpoggemann]

Hi @KSven,

That is a normal Choice column (although when it was made it was OptionSet) as well in the example he walks through...

Thanks,

Drew 

[KSven]

Hi @dpoggemann ,

yes the described steps should work fine, but I guess it's cause of differences betwenn Dataflow standard v1 and v2.

Have created a new support ticket.

BR,

Sven

[hjaf]

This article seems to cover a choice column (single selection) but what about choices (multiple selections)? 

[P3Sven]

Hi @hjaf ,

I had some MS support tickets on it.

This article is about single choice -> still one ticket open (just 0 values fails)

Multiple Choice column is since 2 weeks possible per Dataflow:

Data Type: "Any"

Value per Record like: "999740000,999740001,999740002"

BR,

Sven