+ Start a Discussion
Alex Waddell 17Alex Waddell 17 

Collection Assignment is not passing ID in Visual Workflow

Hello,

My flow suddenly stopped working and when I went to debug the error the only thing that seems out of place is that when I am done assigning the sObj variables and I pass those values into the Collection Variable NO ID appears in the collection variable for the new services I am trying to create

The Flow's Lookup is functioning properly as well as the loop. But something happens when the final assignment takes the sOBJ variables and passes them to the final create sOBJ Collection variable called {Collection_Service_New}

Below is a screenshot of the flow and the debug log showing the first iteration of the flow

User-added image

How the Interview Started
Alex Waddell (0051N000005gBa1) started the flow interview.
Some of this flow's variables were set when the interview started.
varPayer = 0011N00001IC9YBQA1
varAuthFrom = January 1, 2019
varRegion = a0A1N00001K8s1EUAR
varAuthTo = January 31, 2019

FAST LOOKUP: lookup_Authorizations
Find all Authorization__c records where:
PERS_Status__c Equals On Service
PERS_Status__c Equals Termed
Valid_From__c Less than or equal {!varAuthTo} (January 31, 2019)
Valid_To__c Greater than or equal {!varAuthFrom} (January 1, 2019)
Payer__c Equals {!varPayer} (0011N00001IC9YBQA1)
RecordTypeId Equals 0121N0000019CFLQA2
Install_Date__c Is null false
Install_Date__c Less than or equal {!varAuthTo} (January 31, 2019)
Region__c Equals {!varRegion} (a0A1N00001K8s1EUAR)
Assign those records to {!Collection_Authorizations}.
Save these field values in the variable: Id, Modifier_Tax_Id__c, Modifier_NPI__c, ICD_10__c, Billing_Code__c, Payer__c, Price__c, Region__c, Service_Plan__c, First_Name__c, Last_Name__c, Medicaid_ID__c, Date_Of_Birth__c, Billing_Street__c, Billing_City__c, Billing_State_Code__c, Billing_Zip__c, Gender__c, Authorization_Number__c
Result
Successfully found records.

LOOP: loop_Through_Auths
Loop Through: [a0H1N00000LmlCuUAJ,a0H1N00000LmlDGUAZ,a0H1N00000LmlDLUAZ,a0H1N00000LmlDOUAZ,a0H1N00000LmlEBUAZ,a0H1N00000LmlEIUAZ,a0H1N00000LmlFwUAJ,a0H1N00000LmlHUUAZ,a0H1N00000LmlHYUAZ,a0H1N00000LmlHjUAJ,a0H1N00000LmlHpUAJ,a0H1N00000LmlHzUAJ,a0H1N00000LmlI4UAJ,a0H1N00000LmlI7UAJ,a0H1N00000LmlIFUAZ,a0H1N00000LmlIKUAZ,a0H1N00000LmlIOUAZ,a0H1N00000LmlIPUAZ,a0H1N00000LmlIUUAZ,a0H1N00000LmlIoUAJ,a0H1N00000LmlIpUAJ,a0H1N00000LmlIrUAJ,a0H1N00000LmlIuUAJ,a0H1N00000LmlIyUAJ,a0H1N00000LmlIzUAJ,a0H1N00000LmlJ0UAJ,a0H1N00000LmlJ1UAJ,a0H1N00000LmlJDUAZ,a0H1N00000LmlJFUAZ,a0H1N00000LmlJMUAZ,a0H1N00000LmlJNUAZ,a0H1N00000LmlJTUAZ,a0H1N00000LmlJUUAZ,a0H1N00000LmlJYUAZ,a0H1N00000LmlK5UAJ,a0H1N00000LmlKFUAZ,a0H1N00000LmlKIUAZ,a0H1N00000LmlKMUAZ,a0H1N00000LmlKNUAZ,a0H1N00000LmlKbUAJ,a0H1N00000LmlL0UAJ,a0H1N00000LmlL7UAJ,a0H1N00000LmlLAUAZ,a0H1N00000LmlLBUAZ,a0H1N00000LmlLGUAZ,a0H1N00000LmlLNUAZ,a0H1N00000LmlLSUAZ,a0H1N00000LmlLgUAJ,a0H1N00000LmlLrUAJ,a0H1N00000LmlLyUAJ,a0H1N00000LmlM7UAJ,a0H1N00000LmlMMUAZ,a0H1N00000LmlMSUAZ,a0H1N00000LmlMaUAJ,a0H1N00000LmlMiUAJ,a0H1N00000LmlMqUAJ,a0H1N00000LmlN8UAJ,a0H1N00000LmlNIUAZ,a0H1N00000LmlNMUAZ,a0H1N00000LmlNPUAZ,a0H1N00000LmlNQUAZ,a0H1N00000LmlNXUAZ,a0H1N00000LmlNZUAZ,a0H1N00000LmlNrUAJ,a0H1N00000LmlOlUAJ,a0H1N00000LmlOvUAJ,a0H1N00000LmlPBUAZ,a0H1N00000LmlPGUAZ,a0H1N00000LmlPLUAZ,a0H1N00000LmlQyUAJ,a0H1N00000LmlQzUAJ,a0H1N00000LmlUvUAJ,a0H1N00000LmlV3UAJ,a0H1N00000LmlV5UAJ,a0H1N00000LmlV7UAJ,a0H1N00000LmlVsUAJ,a0H1N00000LmlVxUAJ,a0H1N00000LmlW2UAJ,a0H1N00000LmlWEUAZ,a0H1N00000LmlWQUAZ,a0H1N00000LmlWlUAJ,a0H1N00000LmlXTUAZ,a0H1N00000LmlXUUAZ,a0H1N00000LmlagUAB,a0H1N00000LmlbrUAB,a0H1N00000Lmlc0UAB,a0H1N00000LmlcwUAB,a0H1N00000Lmld0UAB,a0H1N00000Lmld1UAB,a0H1N00000Lmld4UAB,a0H1N00000Lmld5UAB,a0H1N00000Lmld6UAB,a0H1N00000Lmld7UAB,a0H1N00000Lmld9UAB,a0H1N00000LmldFUAR,a0H1N00000LmldJUAR,a0H1N00000LmldSUAR,a0H1N00000LmldaUAB,a0H1N00000LmleLUAR,a0H1N00000LmlgFUAR,a0H1N00000LmlgJUAR,a0H1N00000LmlgNUAR,a0H1N00000LmlgRUAR,a0H1N00000LmlgYUAR,a0H1N00000LmlgaUAB,a0H1N00000LmlgcUAB,a0H1N00000LmlggUAB,a0H1N00000LmlghUAB,a0H1N00000Lmlh9UAB,a0H1N00000LmlhNUAR,a0H1N00000LmlhOUAR,a0H1N00000LmlhSUAR,a0H1N00000LmlhiUAB,a0H1N00000Lmli4UAB,a0H1N00000Lmli9UAB,a0H1N00000LmliAUAR,a0H1N00000LmlicUAB,a0H1N00000LmliuUAB,a0H1N00000Lmlj0UAB,a0H1N00000LmljZUAR,a0H1N00000LmljhUAB,a0H1N00000LmljjUAB,a0H1N00000LmljlUAB,a0H1N00000LmljwUAB,a0H1N00000LmlkkUAB,a0H1N00000Lmll6UAB,a0H1N00000LmllKUAR,a0H1N00000Lmlm9UAB,a0H1N00000LmlmAUAR,a0H1N00000LmlmBUAR,a0H1N00000LmlmFUAR,a0H1N00000LmlmGUAR,a0H1N00000LmlmIUAR,a0H1N00000LmlmKUAR,a0H1N00000LmlmLUAR,a0H1N00000LmlmMUAR,a0H1N00000LmlmQUAR,a0H1N00000LmlmWUAR,a0H1N00000LmlmdUAB,a0H1N00000LmlmmUAB,a0H1N00000Lmln8UAB,a0H1N00000LmlnYUAR,a0H1N00000LmlnkUAB,a0H1N00000LmloDUAR,a0H1N00000LmloaUAB,a0H1N00000LmlohUAB,a0H1N00000LmloiUAB,a0H1N00000LmlokUAB,a0H1N00000LmlosUAB,a0H1N00000LmlpKUAR,a0H1N00000LmlpNUAR,a0H1N00000LmlpRUAR,a0H1N00000LmlqAUAR,a0H1N00000LmlqBUAR,a0H1N00000LmlqGUAR,a0H1N00000LmlqmUAB,a0H1N00000LmlqrUAB,a0H1N00000Lmlr4UAB,a0H1N00000Lmlr7UAB,a0H1N00000LmlrCUAR,a0H1N00000LmlrQUAR,a0H1N00000LmlujUAB,a0H1N00000LmlukUAB,a0H1N00000LmlunUAB,a0H1N00000Lmlv3UAB,a0H1N00000LmlvcUAB,a0H1N00000LmlvmUAB,a0H1N00000LmlvwUAB,a0H1N00000Lmlw4UAB,a0H1N00000Lmlw5UAB,a0H1N00000LmlwGUAR,a0H1N00000LmlwIUAR,a0H1N00000LmlwQUAR,a0H1N00000LmlwUUAR,a0H1N00000LmlwaUAB,a0H1N00000LmlwnUAB,a0H1N00000LmlwqUAB,a0H1N00000Lmlx2UAB,a0H1N00000LmlxNUAR,a0H1N00000LmlxYUAR,a0H1N00000LmlxZUAR,a0H1N00000LmlxcUAB,a0H1N00000LmlxjUAB,a0H1N00000Lmm1eUAB,a0H1N00000Lmm2vUAB,a0H1N00000Lmm3dUAB,a0H1N00000Lmm3zUAB,a0H1N00000Lmm40UAB,a0H1N00000Lmm4AUAR,a0H1N00000Lmm4UUAR,a0H1N00000Lmm4WUAR,a0H1N00000Lmm4dUAB,a0H1N00000Lmm4oUAB,a0H1N00000Lmm4qUAB,a0H1N00000Lmm4rUAB,a0H1N00000Lmm4sUAB,a0H1N00000Lmm5CUAR,a0H1N00000Lmm5EUAR,a0H1N00000Lmm5FUAR,a0H1N00000Lmm5IUAR,a0H1N00000Lmm5JUAR,a0H1N00000Lmm5KUAR,a0H1N00000Lmm5MUAR,a0H1N00000Lmm5UUAR,a0H1N00000Lmm5VUAR,a0H1N00000Lmm5WUAR,a0H1N00000Lmm5eUAB,a0H1N00000Lmm5uUAB,a0H1N00000Lmm6FUAR,a0H1N00000Lmm6IUAR,a0H1N00000Lmm6OUAR,a0H1N00000Lmm6aUAB,a0H1N00000Lmm6bUAB,a0H1N00000Lmm6dUAB,a0H1N00000Lmm6fUAB,a0H1N00000Lmm6hUAB,a0H1N00000Lmm6iUAB,a0H1N00000Lmm6qUAB,a0H1N00000Lmm6wUAB,a0H1N00000Lmm6yUAB,a0H1N00000Lmm74UAB,a0H1N00000Lmm7BUAR,a0H1N00000Lmm7CUAR,a0H1N00000Lmm7DUAR,a0H1N00000Lmm7OUAR,a0H1N00000Lmm7QUAR,a0H1N00000Lmm7TUAR,a0H1N00000Lmm7yUAB,a0H1N00000Lmm7zUAB,a0H1N00000Lmm86UAB,a0H1N00000Lmm89UAB,a0H1N00000Lmm8AUAR,a0H1N00000Lmm8GUAR,a0H1N00000Lmm8HUAR,a0H1N00000Lmm8RUAR,a0H1N00000Lmm8qUAB,a0H1N00000Lmm8tUAB,a0H1N00000Lmm8zUAB,a0H1N00000Lmm9HUAR,a0H1N00000Lmm9IUAR,a0H1N00000Lmm9JUAR,a0H1N00000Lmm9KUAR,a0H1N00000Lmm9LUAR,a0H1N00000Lmm9QUAR,a0H1N00000Lmm9UUAR,a0H1N00000LmmA5UAJ,a0H1N00000LmmAKUAZ,a0H1N00000LmmALUAZ,a0H1N00000LmmAMUAZ,a0H1N00000LmmANUAZ,a0H1N00000LmmASUAZ,a0H1N00000LmmAeUAJ,a0H1N00000LmmAoUAJ,a0H1N00000LmmApUAJ,a0H1N00000LmmAyUAJ,a0H1N00000LmmAzUAJ,a0H1N00000LmmB0UAJ,a0H1N00000LmmB5UAJ,a0H1N00000LmmB8UAJ,a0H1N00000LmmBCUAZ,a0H1N00000LmmBKUAZ,a0H1N00000LmmCCUAZ,a0H1N00000LmmCDUAZ,a0H1N00000LmmCTUAZ,a0H1N00000LmmCUUAZ,a0H1N00000LmmCVUAZ,a0H1N00000LmmCWUAZ,a0H1N00000LmmCXUAZ,a0H1N00000LmmCYUAZ,a0H1N00000LmmCaUAJ,a0H1N00000LmmCbUAJ,a0H1N00000LmmCcUAJ,a0H1N00000LmmCdUAJ,a0H1N00000LmmCeUAJ,a0H1N00000LmmCoUAJ,a0H1N00000LmmCpUAJ,a0H1N00000LmmCqUAJ,a0H1N00000LmmCrUAJ,a0H1N00000LmmCvUAJ,a0H1N00000LmmDAUAZ,a0H1N00000LmmDGUAZ,a0H1N00000LmmDIUAZ,a0H1N00000LmmDLUAZ,a0H1N00000LmmDNUAZ,a0H1N00000LmmDQUAZ,a0H1N00000LmmDRUAZ,a0H1N00000LmmDjUAJ,a0H1N00000LmmE4UAJ,a0H1N00000LmmEXUAZ,a0H1N00000LmmEuUAJ,a0H1N00000LmmFgUAJ,a0H1N00000LmmFhUAJ,a0H1N00000LmmFoUAJ,a0H1N00000LmmFpUAJ,a0H1N00000LmmFqUAJ,a0H1N00000LmmFvUAJ,a0H1N00000LmmFwUAJ,a0H1N00000LmmFxUAJ,a0H1N00000MJprBUAT,a0H1N00000MJprkUAD,a0H1N00000MJsxvUAD,a0H1N00000MKBs2UAH,a0H1N00000MKS8KUAX,a0H1N00000MKU9nUAH,a0H1N00000MKUACUA5,a0H1N00000MKUC3UAP,a0H1N00000NU1F8UAL,a0H1N00000NU1HYUA1,a0H1N00000NU1HnUAL,a0H1N00000NU1MDUA1,a0H1N00000NU1N1UAL,a0H1N00000NV7AXUA1,a0H1N00000NV7CvUAL,a0H1N00000NV7E8UAL,a0H1N00000NV7ESUA1,a0H1N00000NV7FVUA1,a0H1N00000NV7FaUAL,a0H1N00000NV7G9UAL,a0H1N00000NV7HEUA1,a0H1N00000NVxXYUA1,a0H1N00000NW5mQUAT,a0H1N00000NW5niUAD,a0H1N00000NW5o7UAD,a0H1N00000NW5ogUAD,a0H1N00000NW5qCUAT,a0H1N00000NW5qWUAT,a0H1N00000NW5quUAD,a0H1N00000NW5qzUAD,a0H1N00000NW5rJUAT,a0H1N00000NW5riUAD,a0H1N00000NW5sRUAT,a0H1N00000NW5woUAD,a0H1N00000NW8HvUAL,a0H1N00000NW8HwUAL,a0H1N00000NWBAZUA5,a0H1N00000NbIIZUA3,a0H1N00000Nbc4SUAR,a0H1N00000Np6PKUAZ,a0H1N00000NptruUAB,a0H1N00000NpwBGUAZ,a0H1N00000Npz38UAB,a0H1N00000Nq04EUAR,a0H1N00000Nq8zPUAR,a0H1N00000NqZf4UAF,a0H1N00000NqZoeUAF,a0H1N00000NqZrOUAV,a0H1N00000NqZt7UAF,a0H1N00000NqZuPUAV,a0H1N00000NqZvSUAV,a0H1N00000NqZwLUAV,a0H1N00000NqZyAUAV,a0H1N00000NrLfOUAV,a0H1N00000NrLh5UAF,a0H1N00000NrLhyUAF,a0H1N00000NrLiSUAV,a0H1N00000NrLj6UAF,a0H1N00000NrLkTUAV,a0H1N00000NrLlmUAF,a0H1N00000NrLn4UAF,a0H1N00000NrRE2UAN,a0H1N00000NrRnOUAV,a0H1N00000NrRtoUAF,a0H1N00000NrRv1UAF,a0H1N00000NrRwJUAV,a0H1N00000NrRwTUAV,a0H1N00000NrS0PUAV,a0H1N00000NrS3dUAF,a0H1N00000NrV5uUAF,a0H1N00000NrV9EUAV,a0H1N00000NrVB0UAN,a0H1N00000NrVBUUA3,a0H1N00000NrVL6UAN,a0H1N00000NrVMOUA3,a0H1N00000NrazYUAR,a0H1N00000Nrb0qUAB,a0H1N00000NrhiIUAR,a0H1N00000NrhnjUAB,a0H1N00000NrhpPUAR,a0H1N00000NrkuBUAR,a0H1N00000Nrx7HUAR,a0H1N00000NrxQ1UAJ,a0H1N00000Ns0LFUAZ,a0H1N00000Ns4gRUAR,a0H1N00000NsMCCUA3,a0H1N00000Nspn3UAB,a0H1N00000Nstx3UAB,a0H1N00000Nsu0qUAB,a0H1N00000Nt7heUAB,a0H1N00000OZId9UAH,a0H1N00000OZPRJUA5,a0H1N00000OZh2BUAT]
Iteration: 0
Current value of {!Collected_Authorizations}: a0H1N00000LmlCuUAJ

ASSIGNMENT: assign_Service_fields
{!sOBJ_Services.Service_Plan__c} Equals {!Collected_Authorizations.Service_Plan__c}
{!sOBJ_Services.ICD_10_Code__c} Equals {!Collected_Authorizations.ICD_10__c}
{!sOBJ_Services.Price__c} Equals {!Collected_Authorizations.Price__c}
{!sOBJ_Services.Payer__c} Equals {!Collected_Authorizations.Payer__c}
{!sOBJ_Services.Billing_Code__c} Equals {!Collected_Authorizations.Billing_Code__c}
{!sOBJ_Services.Modifier_NPI__c} Equals {!Collected_Authorizations.Modifier_NPI__c}
{!sOBJ_Services.Modifier_Tax_Id__c} Equals {!Collected_Authorizations.Modifier_Tax_Id__c}
{!sOBJ_Services.Region__c} Equals {!varRegion}
{!sOBJ_Services.Monthly_Billing__c} Equals {!varRecordId}
{!sOBJ_Services.Billing_Month__c} Equals {!varAuthTo}
{!sOBJ_Services.Billing_Medicaid_ID__c} Equals {!Collected_Authorizations.Medicaid_ID__c}
{!sOBJ_Services.First_Name__c} Equals {!Collected_Authorizations.First_Name__c}
{!sOBJ_Services.Last_Name__c} Equals {!Collected_Authorizations.Last_Name__c}
{!sOBJ_Services.Date_of_Birth__c} Equals {!Collected_Authorizations.Date_Of_Birth__c}
{!sOBJ_Services.Billing_Street__c} Equals {!Collected_Authorizations.Billing_Street__c}
{!sOBJ_Services.Billing_City__c} Equals {!Collected_Authorizations.Billing_City__c}
{!sOBJ_Services.Billing_State_Code__c} Equals {!Collected_Authorizations.Billing_State_Code__c}
{!sOBJ_Services.Billing_Zip__c} Equals {!Collected_Authorizations.Billing_Zip__c}
{!sOBJ_Services.Gender__c} Equals {!Collected_Authorizations.Gender__c}
{!sOBJ_Services.Authorization_Number__c} Equals {!Collected_Authorizations.Authorization_Number__c}
{!sOBJ_Services.Authorization__c} Equals {!Collected_Authorizations.Id}

I have blacked out data relating to our patients. but you can trust me that there is data in all of those fields
User-added image
ASSIGNMENT: update_the_collection
{!Collection_Service_New} Add {!sOBJ_Services}
Result
{!Collection_Service_New} = "[Services__c (No ID)]"

Any Ideas on what can be causing this error?
Andrew Bishop 10Andrew Bishop 10
I need assistance on a flow, would you be able to help me?
Sam Richardson-VineSam Richardson-Vine
Did you ever find a solution to this? I've got the same problem
 
Karen BurdetteKaren Burdette
I'm also experiencing the same issue. The record ID is found in the loop:

Loop Through: [a1t0m000000GfdCAAS]
Iteration: 0
Current iteration item: a1t0m000000GfdCAAS

But then it fails to add that same value to the collection variable:

{!RecordsToBeUpdated} Add {!loopRecords}
Result
{!RecordsToBeUpdated} = "[MSPQuote__c (No ID)]"
Karen BurdetteKaren Burdette
I figured out my issue, and I don't think it's the same problem. I had copied and pasted elements from one loop assignment to another and didn't change the collection variable used in the assignment.