Unanswered

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

(0) Share

Report

Posted on by bootstrapper

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!

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @bootstrapper ,
you can follow these steps:
1. When a row is modified (don't care about the "Contact" table, it's an example):
2. Initialize an Integer variable and put 0:
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):
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

Was this reply helpful? Yes No
bootstrapper 11 on at

Like (0)

Report
Copy link

Link copied!

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)?

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

BR,
Marco

Was this reply helpful? Yes No
bootstrapper 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bootstrapper ,
what’s the SOLn-1824 reference?

BR,
Marco

Was this reply helpful? Yes No
bootstrapper 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
bootstrapper 11 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
bootstrapper 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No