Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Connector Development / connecting parameters ...
Power Automate - Connector Development
Suggested answer

connecting parameters to add a new row in database

Like (0) ShareShare
ReportReport
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
  • michellecoslet Profile Picture
    michellecoslet 192 on 12 Mar 2025 at 14:16:29
    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 Profile Picture
    Michael E. Gernaey 42,295 Super User 2025 Season 1 on 11 Mar 2025 at 22:39:05
    connecting parameters to add a new row in database
     
    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 Profile Picture
    michellecoslet 192 on 11 Mar 2025 at 13:03:41
    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 Profile Picture
    Michael E. Gernaey 42,295 Super User 2025 Season 1 on 11 Mar 2025 at 05:15:04
    connecting parameters to add a new row in database
     
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Connector Development

#1
RohanWadiwala Profile Picture

RohanWadiwala 16

#2
sdr7893 Profile Picture

sdr7893 2

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans