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

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
Super User
Super User

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

Hope this helps. Please accept if answers your question or Like if helps in any way.
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
Super User
Super User

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 

Hope this helps. Please accept if answers your question or Like if helps in any way.
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
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 Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Users online (3,773)