Hi, I am trying to build a flow which will update a checkbox on the user record to indicate if a permission set has been assigned or not. This is then used for Communities reporting.

I ran the flow as a scheduled flow pulling from the PermissionSetAssignment object and relating it to the user by using the Assignee ID of the user. However when I try and debug the flow I get the below error and I am not sure why.

;nested exception is: common.exception.ApiQueryException: = 'permissionsetID' ) ORDER BY CreatedDate ASC LIMIT 1 ERROR at Row:1:Column:93 No such collumn 'CreatedDate' on entity 'PermissionSetAssignment'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name, Please reference your WSDL or the describe call for the appropriate names.

Can anyone help dechipher the above please? we have not referenced any of these fields in the flow so not sure why it is throwing an error.

Any help would be greatly appreciated.

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



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

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?