Getting the autoID from first table and added data to the second table (for looping flow)

Posted on by Thinzar

Hello,

I am preparing the flow which allows adding a new row with autogenerated id in one table and then, getting that recently added id as a foreign key, the new data will be added to the next table.

The flow I prepared is as follows

adding a new data to the first table dtb_FRL

adding the data to the second table dtb_FRLC_TravelCost together with the recently added id (in the first pic)

It is successfully when running with a single trigger. However, when I runs the flow with loop (with multiple times), the added id are all the same in adding the data to the second table though the id are not the same in the first table. This may be due to the same time when creating the data record in the first table.

I would like to know is that is there any alternative way for my scenario? Or how could I overcome this problem?

Thanks.