cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KSven
Advocate II
Advocate II

Dataflow standard v2 | Integration of choice value boolean

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:

KSven_0-1616749574387.png

 

Target column:

KSven_1-1616749680203.png

Choice of column with id:

KSven_2-1616749689500.png

 

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

6 REPLIES 6
dpoggemann
Solution Sage
Solution Sage

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

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
Solution Sage
Solution Sage

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 

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

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

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Kudoed Authors
Users online (75,033)