Original Post: How to Reduce Flow Runtime by Optimizing Entity Column Selection in D365 Power Automate Loops [Quick Guide]
When loops or queries involving large entity lists occur in a flow, the runtime of the flow can quickly extend to several seconds.
To mitigate this, it is crucial to specify only the columns that are genuinely required.
Consider the following example:
By specifying the columns in every action that interacts with an entity, I was able to reduce the runtime to a third in my case.
Results:
I hope these instructions have helped some of you.
