Symptoms
- Inventory data (Apps, Flows, Connections, Makers) is no longer updating.
- CoE dashboards show stale or missing records.
- Admin sync flows show repeated failures or timeouts.
- Flow error message includes:
- “API throttling limit exceeded”
- “Request URL too large”
- “Timeout expired before the operation completed”
Root Cause
Common reasons include:
- Tenant has grown significantly, causing sync flows to exceed runtime limits.
- Power Apps and Flow inventory has exceeded recommended scale guidelines.
- Environment list exceeds 500+ environments without pagination enabled.
- Missing or expired Power Platform Admin / Service Principal permissions.
- Remove‑unused or clean-up flows are stuck waiting for admin approval.
Resolution Steps
1. Validate Admin Connector Permissions
- Open Power Platform Admin Center.
- Go to Entra ID app registrations.
- Confirm the service principal used by CoE has:
- Power Platform Admin role
- Power Platform Service Admin role
2. Reduce The Volume of Records Pulled in Each Run
Update each sync flow:
- Open the solution CoE Starter Kit – Core.
- Edit each sync flow and adjust the query filters:
- Filter by modified in last X days.
- Limit to environments where monitoring is required.
3. Turn On Pagination
In any List Rows or List Flows step:
- Select the action → Settings → Turn on Pagination → Increase threshold to 100,000.
4. Split or Parallelize Sync Jobs
For large tenants:
- Duplicate flows and configure:
- Flow A: Regions A–D
- Flow B: Regions E–H
- Flow C: Remaining
5. Restart Flows and Monitor
- Re-enable flows.
- Confirm they run without timeout.
- Check CoE Dashboards refresh automatically within 24 hours.
Validation
- CoE dashboards show recent inventory data.
- Sync flows run successfully without errors.
- Environment, App, and Flow inventory is no longer stale.
Additional Notes
- Microsoft recommends running inventory sync during off-peak hours for enterprise tenants.
- Consider scheduling sync flows hourly, not constantly.