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!
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.
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
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?
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
That is the document number that I am trying to pass to that lookup field from the another table.
Yes there is. Although it has a different name, but I don't think that should matter?
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)?
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