web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / create entities in azu...
Power Automate
Answered

create entities in azure from for each loop

(0) ShareShare
ReportReport
Posted on by 295

Hello,

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.

Rosie_0-1655080903651.png

If I have the Insert Entity within the For Each loop then I get multiple records of the same record created.

Rosie_1-1655081137901.png

 

Thanks

Rosie

Categories:
I have the same question (0)
  • Verified answer
    Rosie Profile Picture
    295 on at

    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.

    Rosie_0-1655149870165.png

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard