I thought this was straight forward but I need some help to insert entities into an Azure table from a For each loop.
Json files are received by the flow, sometimes multiple records present in the JSON e.g. there are 3 body sections.
A For each loop is used to get the data from each file, I then need each set of data to be added as an entity.
I am missing some fundamental step but I don't know what it is?
I had the Insert Entity outside of the For Each loop, but only one of the records in the loop is inserted into the table.
If I have the Insert Entity within the For Each loop then I get multiple records of the same record created.
Go to Solution.
I found the solution, the concurrency setting needed to be set to sequential, with a value of 1.
When the azure create entity step is within the For Each loop each new record from the body of the json is inserted.
This default of this setting seems to have changed from sequential to parallel based on the screenshots I found when searching for information about this setting.
View solution in original post
Keep up to date with current events and community announcements in the Power Automate community.
Check out the latest Community Blog from the community!