Answered

Dataverse Choices Field

(0) Share

Report

Posted on by NPrice99

1,302

I have a DataVerse table called JukeBoxJuryMembers which has a Choices field called Colours with values "WHITE", "BLACK" and "RED".

I want to add a record to this table. I use "RED" for the Colours field but I get an error "The runtime value "RED" to be converted doesn't have the expected format 'Integer/int32'.

So I try and get the equivalent integer value for the Colour "RED" by querying the table String maps with the filter attributename eq 'Colours' and value eq 'RED' and objecttypecode eq 'jukeboxjurymembers'.

I get an error The entity with a name = 'jukeboxjurymembers' with namemapping = 'Logical' was not found in the MetadataCache.

What am I doing wrong ?

Thanks

Nigel

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @NigelP ,

Do you want to patch a new record in Dataverse table with choice column is "RED"?
You can either show me the code which is reporting an error, or you can try this code first.

Patch(DataverseTableName,Defaults(DataverseTableName),{Column1:"test",ChoiceColumnName:ChoiceTableName.RED})

Best regards,
Rimmon

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft
Sorry, My bad I should have said this was happening with a PowerAutomate Flow.

Regards

Nigel

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you tell us if you’re doing a canvas app, model driven app or something else to add a record?
Please paste a screenshot of the error thrown too, so we can see context of where this is coming from.
based on the Odata query it seems you may be using JavaScript or a Power Automate Flow…
if you’re using a flow, choices should be a dropdown in the UI. Don’t enter the words “red”, simply use the dropdown to select the Red option. If you enter a formula, then you have to use the option set number value. For testing purposes just enter the number value for Red directly without commas. It should work then.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NigelP ,

Could you please show me current actions for update choice column?

Was this reply helpful? Yes No