connecting parameters to add a new row in database

Like (0) Share

Report

Posted on 10 Mar 2025 19:04:31 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:

Authentication

All responses (4)

Answers (0)

michellecoslet 192 on 12 Mar 2025 at 14:16:29

Like (0)

Report

connecting parameters to add a new row in database

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'.'."
Suggested answer

Michael E. Gernaey 41,498 Super User 2025 Season 1 on 11 Mar 2025 at 22:39:05

Like (0)

Report

connecting parameters to add a new row in database

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
michellecoslet 192 on 11 Mar 2025 at 13:03:41

Like (0)

Report

connecting parameters to add a new row in database

yes i am passing data from my collection. Response is a single select choice field (Compliant, Non-compliant) default set to none.
Michael E. Gernaey 41,498 Super User 2025 Season 1 on 11 Mar 2025 at 05:15:04

Like (0)

Report

connecting parameters to add a new row in database

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?

Community site session details

connecting parameters to add a new row in database

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

connecting parameters to add a new row in database

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates