connecting parameters to add a new row in database

(0) Share

Report

Posted on by michellecoslet

192

I successfully created a flow to add a new row of data into my dataverse table, from a collection once i hit a submit button. However for some reason i am not able to connect one choice field. Screenshot my flow below. i am not able to enter a dynamic value that makes sense for Response. I expect there to be a Body Response value to select.

 
Parse JSON parameter:
{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "Comments": {
                "type": "string"
            },
            "EvidenceDetails": {
                "type": "string"
            },
            "IsModified": {
                "type": "boolean"
            },
            "MasterID": {
                "type": "string"
            },
            "Response": {
                "type": "string"
            }
        },
        "required": [
            "Comments",
            "EvidenceDetails",
            "MasterID",
            "IsModified",
            "Response"
        ]
    }
}
 
Add a new Row parameters:
 

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @michellecoslet

You seem to be passing data into the Flow. Can you share what the data looked like that you passed.

Also, is this a single or multi-select choice?

Was this reply helpful? Yes No
michellecoslet 192 on at

Like (0)

Report
Copy link

Link copied!

yes i am passing data from my collection. Response is a single select choice field (Compliant, Non-compliant) default set to none.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @michellecoslet

So you are saying you want to create a Record, but there are many rows in that Collection and only 1 (that I can see) has a value for Response.

According to the little i can see, in the 4 of 17 its blank (which I expect as I see all blanks except for one Response).

Can you clarify what you are trying to do, is it 1 row or many rows that you want to create, because you are using a for Each (loop) and you only need that because the collection has so many rows in it.

Either way, you have Response as Required in the Schema, but you can see for yourself, that its Blank in your Collection.

You need to fix the collection

Was this reply helpful? Yes No
michellecoslet 192 on at

Like (0)

Report
Copy link

Link copied!

1. For the testing purposes, i only populated one line in my gallery. this is why 1/14 ROWS are completed and the rest are blank at the moment.

2. I only care about the 4 parameters saving to the collection/table. the remaining 13 are irrelevent and not required in my table

3. I want to create or update a row in my Dataverse Tablke when data is added/updated in my collection. The collection is working fine as you can see in my screenshot below. All 4 of the necessary columns are populating. The problem lies in the flow that is only sending data to my Dataverse Table for 'comments', 'masterID' and 'evidencedetails'. It is not sending the response to the dataverse TABLE. I do not understand how to configure either the Parse JSON or the Add a new row parameter to make this work.

Its as if i need to add an expression here that tells the flow to send whatever data is in "Response" column in the collection to the "response" column in the dataverse table. no different than comments, evidence details or masterID but for some reason there is no selectable option for Response when i click dynamic value icon.

here is the code view of my Add a new Row trigger

the highlighted does not work and its the only option available in Dynamic Values that doesnt give me an immediate error. The other option is "atitems('For_each')" but i get an immediate error "Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Add_a_new_row': The parameter with value '"@items('For_each')"' in path 'item/cr2fa_response' with type/format 'Object' is not convertible to type/format 'Integer/int32'.'."

Was this reply helpful? Yes No