Unanswered

Add a new row in Dataverse table - Choice field

(0) Share

Report

Posted on by Feanor

Dear community,

I am trying to build a simple flow that takes an item that is created on a SharePoint list and feeds that info into a Dataverse table.

So when an item is created go and add a new row. In my SharePoint list I have Choice fields and in my table I have Choice fields.

So for my flow I have 2 options a) the frequency or b) the frequency value which is my choice.

But it does not matter which one I take it will always result in an error when I run it.

This is the error I get:

An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal 'weekly' to the expected type 'Edm.Int32'. ---> System.FormatException: Input string was not in a correct format.

Can anyone help me out here, would really appreciate some help with this.

With best regards

Chris

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

PrasadAthalye on at

Like (0)

Report

Did you create it as Choice field? If yes, edit the field in edit mode and open values and click value. You will see integer value. That's what you need to send in Dataverse... Below is an example

Was this reply helpful? Yes No
Feanor 45 on at

Like (0)

Report

Hi there, yes I did and I can see the value, I can hard code this of course but is there a way to do a lookup on this with the Choice value I have from sharepoint and get the value from the table?

Kind Regards
Chris

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (2)

Report
Hi @Feanor,

You can query the String Maps table to get the integer value (attributevalue). This table stores all Choice(s). You will need the following to filter it appropriately:

Table name (objecttypecode)

Choice column name (attributename)

Choice Label you want to retrieve the value for (value)

An Example of how to fetch this is shown below:

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Feanor 45 on at

Like (0)

Report

@ChrisPiasecki perfect that works! Thank you very much, really appreciate the help.

Was this reply helpful? Yes No