Power Automate - iAuditor integration to Excel for business

Nested "Apply to each" loops are usually the problem here. Each loop runs once for every item in the loop above it, so with three of them you get every combination of site, serial number and so on, rather than one row per inspection. It is also very slow, which can look like the flow stopping.

What tends to work better:

1. Use a single "Apply to each" over the main array, the list of inspections or items.
2. Inside it, pick each value from the current item, for example items('Apply_to_each')?['site'], instead of looping over each field separately.
3. Put "Add a row into a table" inside that one loop.

Two Excel points as well. The data needs to be formatted as a table (Insert, then Table) in a file at a fixed location. And set the loop's concurrency to 1, because Excel doesn't handle lots of rows arriving at once well.

If this feeds Power BI and will grow, a SharePoint list is usually more reliable than Excel as the landing place, and Power BI reads it just as easily.