I have built a flow that displays the closest accounts within a 10 mile radius. The flow is launched via a button on the account the user is currently viewing. Below is the flow:
This works perfectly fine in my Sandbox. However on my production org it fails due to the following error: "Error Occurred: Too many query rows: 50001"
I assume its working on my Sandbox because there are only about 20 accounts.
How can I resolve this issue on my production org? Is there something I can change to my flow?
Any help much appreciated