Errors when adding row to Dataverse table

[michaelkennett]

I'm currently building an app, and would like the inputs of it to feed into a Dataverse table. I've already created the table, and set up a Power Automate flow using the Power Apps connector. I have a button set up, with the below function:

'PowerApp->Addnewrow'.Run(.....) ,

and then reference to each input control. The majority of these work, however there are four drop-down controls in my app, each referencing a different choice from the Dataverse environment. Each of the 4 drop-down controls throw up the below error under 'Formula'

They are referenced in the function as per the below format:

'dropdowncontrol'.Selected.Value

Can anyone advise what might be causing this error? The choices are not number values, neither are the columns in the table.

[AJ_Z]

So with this Power Automate error the Dataverse Connector is Expecting the Choice Options Value

The Value is the number that represents the choice which you can find when editing the choice in dataverse

So for my test I need to not send the text Cool but instead send 748490002

There are two good ways to do it. Method one is quick but may need some maintenance in the future. You create a Switch or If that swaps the text with the value. Or you can do it dynamically. 

For the first method it would be something like this for my example:

'PowerApp->Addnewrow'.Run(Switch('dropdowncontrol'.Selected.Value,'Choice Name'.Cool,748490002,'Choice Name'.No',748490001,'Choice Name'.Yes',748490000))

The switch changes it to the value before it passes it. 

You can do it with the dynamic method aswell but for that I would recommend you check out this Blog Post on the topic: https://www.d365geek.co.uk/single-post/updating-dataverse-optionset-choice-from-text-dynamically-usi... 

Let me know if you have any more questions.

[michaelkennett]

Hi @AJ_Z 

Thank you for your response. I've given this a go and I'm now seeing the belowerror message:

Error message

As you can see below, each choice is referring to the correct values. The control 'CAPEX?' is referencing the 'CAPEXSpend?' choice from my table.

Choice with values

The same error message is occurring with all 4 dropdowns in use within the app.

Please advise if you can see anything I'm doing wrong.

Many thanks.

[AJ_Z · Accepted solution]

Apologies for any confusion in the switch you will need to do the choice name . then the choice option as the comparison e.g.

'PowerApp->Addnewrow'.Run(Switch('dropdowncontrol'.Selected.Value,'Choice Name'.Cool,748490002,'Choice Name'.No,748490001,'Choice Name'.Yes,748490000))

you can find the choice name by looking at the Items Property for the drop down it is usually, Choices('Choice Name')

[michaelkennett]

Thanks @AJ_Z  - looks like I misread it at first.

Just been through and it now works as intended - thanks for your help!

[AJ_Z]

I am so happy I could help! Good luck with your App and future Power Apps 🙂