Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Using a flow to add multiple rows on a model driven app table

(0) ShareShare
ReportReport
Posted on by 11

I am new to Power Automate and I am trying to add multiple rows of data into a model drive app table rather than having to manually create them. The trigger will be a toggle button in the form. The data in the new rows will be the same but the amount of rows to be added will depend on a field value entered by the user. Thanks for your advice everyone!

 

  • bootstrapper Profile Picture
    bootstrapper 11 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Hi

    I have tried your suggestion and many other way like Orderlinedetail//your_value, Orderlinedetail('your_value'), Orderlinedetail(your_value), /Orderlinedetail/your_value. Nothing seem to work.

     

    I thought I should mention this but the data from the field I am trying to pass into fulfillments is of type "autonumber". I have tried to delay the add a row function in case the autonumber field has not created the number but nothing.

    I have tried looking on YouTube as to formatting this by listing the row first and then composing but still nothing. 

    https://www.youtube.com/watch?v=EsRWGw-KYtA

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Hello @bootstrapper ,

    in the "Add a new row" action, in the "Order line detail" you should put first the table schema name, then the value, like:

    Orderlinedetail/your_value.

     

    Let's imagine you have to populate the Contact lookup field in the Fulfillments table, so the field must be populated in this way:

    contacts/your_value

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

  • bootstrapper Profile Picture
    bootstrapper 11 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Hi Marco,

    The table where I am getting the "SOLn-xxxx" is Order Line Details, then I want to pass that value to another table called fulfillments. This is where the field is of type lookup.

    This is the only value I am adding to the new row in fulfillments table. 

     

    This is how I am formatting "Order line detail" Which brings "SOLn-xxxx" under "Add a new row".

    outputs('Get_a_row_by_ID_3')?['body/crc5a_solinenumber@OData.Community.Display.V1.FormattedValue']

    I am aware that they have different name, unless they are not supposed to and this is why I am getting the resource error?

     

    1 of 2.JPG2 of 2.JPG

     

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Using a flow to add multiple rows on a model driven app table

    ok @bootstrapper ,

    is  "SOLn-1824" the Table schema name? Which value are you adding after the SOLn-1824/?

     

    Please share the flow in Edit Mode.

     

    BR,

    Marco

  • bootstrapper Profile Picture
    bootstrapper 11 on at
    Re: Using a flow to add multiple rows on a model driven app table

    That is the document number that I am trying to pass to that lookup field from the another table.

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Using a flow to add multiple rows on a model driven app table

    @bootstrapper ,

    what’s the SOLn-1824 reference?

     

    BR,

    Marco

  • bootstrapper Profile Picture
    bootstrapper 11 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Yes there is. Although it has a different name, but I don't think that should matter?

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Using a flow to add multiple rows on a model driven app table

    @bootstrapper ,

    in the row to be added, is there a lookup field?

     

    BR,

    Marco

  • bootstrapper Profile Picture
    bootstrapper 11 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Thank you, this helped. For some reason I am getting a "resources not found for this segment" error when I try to create the new record. Even thou I am formatting the data to bring it into the new table, given that it is a lookup field. Could it be because is inside a loop or do you think is the way I am formatting it(I have used the same format for other flows when it comes to choice and lookup fields)?

     add a new row.JPG

     

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Using a flow to add multiple rows on a model driven app table

    Hello @bootstrapper ,

    you can follow these steps:

    1. When a row is modified (don't care about the "Contact" table, it's an example):

    MarconettiMarco_0-1659889524225.png

    2. Initialize an Integer variable and put 0:

    MarconettiMarco_1-1659889549472.png

    3. Add a "Do Until" control: it will repeat the same actions until the variable raise the value entered by the user in the form (the field in the form must be integer type, otherwise you should use the expression "int" to convert the string in integer):

    MarconettiMarco_3-1659889697495.png

    as final action within the "Do until" control, increment the variable with "1".

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard