Hi everyone,
In Model Driven app is it possible to automate "Add child rows when Master record is created ?"
Example
We have a Master table called "Vehicle" Primary Key auto number "V_01",
connected with an associated table "Activity" Primary Key auto number "Ac_01".
When users create new vehicle request in main form they add 5 Activities(5 rows) in associated table, so I was thinking if there is a way to create 5 default lines for every master record.
Any suggestions ? 🙂
Thank you
Hi @My_connect
Yes, using Power Automate we can add activities records when vehicle record is created
Sample
Note: Change to Vehicle table instead of Account on this example
Thanks,
Stalin
Thank you @StalinPonnusamy .
But to add New Row Power automate requires auto number which is mandatory
I guess i need to know last auto number in my table lets say "AC_22" and +1 to make it AC_23 and loop this 5 times ?
Hi @My_connect
Yes, If the auto number is your custom number then Get the latest number and increment one by one.
I recommend using the Dataverse Auto number that is easy to handle and unique. In Dataverse, we have Autonumber field which generates based on a few combinations
You can combine these 3 options to get 12 char lengths.
For example
{SEQNUM:6}{RANDSTRING:6} --> 001000QUKJIN {DATETIMEUTC:yyyyddMM}{RANDSTRING:6} --> 20211410D344BG
Hi @My_connect
Please let us know if anything needs on your post. We can help with this.
Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.
Thanks,
Stalin - Learn To Illuminate
User | Count |
---|---|
257 | |
108 | |
90 | |
51 | |
44 |