Hello!

I created an autolaunched flow that is started via process builder. When trying to create a new contact, I get the following error email:

Error element Update_County (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: CFL:Too many SOQL queries: 101. For details, see API Exceptions.

This report lists the elements that the flow interview executed. The report is a beta feature.
We welcome your feedback on IdeaExchange.

Flow Details
Flow Name: Lookup_zip_county
Type: Autolaunched Flow
Version: 2
Status: Active

Flow Interview Details
Interview Label: Lookup zip/county 1/31/2018 4:19 PM
Current User: General User (00515000006mz1Z)
Start time: 1/31/2018 4:19 PM
Duration: 0 seconds

How the Interview Started
General User (00515000006mz1Z) started the flow interview.
Some of this flow's variables were set when the interview started.
VAR_AccountID = 0011C00001t5Ow4QAE
VAR_Zip = 97212

RECORD QUERY: Find_zip_county
Find one County__c record where:
Zip_Code__c Equals {!VAR_Zip} (97212)
Result
Successfully found record.
{!VAR_County} = Multnomah

RECORD UPDATE: Update_County
Find all Account records where:
Id Equals {!VAR_AccountID} (0011C00001t5Ow4QAE)
Update the records’ field values.
Auto_County__c = {!VAR_County} (Multnomah)
Result
Failed to update records that meet the filter criteria.

Error Occurred: The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: CFL:Too many SOQL queries: 101. For details, see API Exceptions.

My goal in creating the flow was to autopopulate county based on zip code. To do this, I created a custom object with records for each related county and zip code. I will screenshot my flow, but basically, process builder feeds the flow an accounts zip code, which it looks up from the custom records, and then the flow updates the county field.

The flow is set to run when an account is "created or edited" and the criteria labeled "None" says "nothing, just execute!".









Thank you for any help you can provide to get around the limit and get this working!

Many thanks,
​Lindsay
 

Hello!

I created an autolaunched flow that is started via process builder. When trying to create a new contact, I get the following error email:

Error element Update_County (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: CFL:Too many SOQL queries: 101. For details, see API Exceptions.

This report lists the elements that the flow interview executed. The report is a beta feature.
We welcome your feedback on IdeaExchange.

Flow Details
Flow Name: Lookup_zip_county
Type: Autolaunched Flow
Version: 2
Status: Active

Flow Interview Details
Interview Label: Lookup zip/county 1/31/2018 4:19 PM
Current User: General User (00515000006mz1Z)
Start time: 1/31/2018 4:19 PM
Duration: 0 seconds

How the Interview Started
General User (00515000006mz1Z) started the flow interview.
Some of this flow's variables were set when the interview started.
VAR_AccountID = 0011C00001t5Ow4QAE
VAR_Zip = 97212

RECORD QUERY: Find_zip_county
Find one County__c record where:
Zip_Code__c Equals {!VAR_Zip} (97212)
Result
Successfully found record.
{!VAR_County} = Multnomah

RECORD UPDATE: Update_County
Find all Account records where:
Id Equals {!VAR_AccountID} (0011C00001t5Ow4QAE)
Update the records’ field values.
Auto_County__c = {!VAR_County} (Multnomah)
Result
Failed to update records that meet the filter criteria.

Error Occurred: The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: CFL:Too many SOQL queries: 101. For details, see API Exceptions.

My goal in creating the flow was to autopopulate county based on zip code. To do this, I created a custom object with records for each related county and zip code. I will screenshot my flow, but basically, process builder feeds the flow an accounts zip code, which it looks up from the custom records, and then the flow updates the county field.

The flow is set to run when an account is "created or edited" and the criteria labeled "None" says "nothing, just execute!".









Thank you for any help you can provide to get around the limit and get this working!

Many thanks,
​Lindsay
 

Hi There,

I am trying to create a custome object to trigger a county name on entry of an address in Salesforce. I have the steps to do it but I need clear instructions on how to do it. Below is the steps. If someone could please let me know how to do this, it would be great.

1. Create an object that contains the data of the zip codes. (How and where do I create this and how do we connect the zip codes to the county? We are working with 50 county's and around 2400 zip codes that need to be connected)
2. Create a trigger for contact created or edited, and one for account as well.
3. Use the zip code to look up the county in the custom object, and fill in the field on the contact or account record.

Thanks in advance,
Janine