The provided value is of type 'Null in an expresion

[fokooko]

Hello everyone,

Looking for some help. I am stuck with the below flow, the idea is to get only certain records from Salesforce.

1. From specific company names and also time created. (this works)

2. Then the condition to retrieve only the ones that have more than 3 hours of delay between the CreatedDate and Case_Creation_Date__c. (this does not work).

There is the expression used and causing an error.

div(sub(ticks(triggerBody()?['CreatedDate']),ticks(triggerBody()?['Case_Creation_Date__c'])),36000000000)

I have tried with this one two

div(sub(ticks(outputs('Get_records')?['CreatedDate']),ticks(outputs('Get_records')?['Case_Creation_Date__c'])),36000000000)

Here is the error

ERROR

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'ticks' expects its parameter to be a string that represents a timestamp. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ticks for usage details.'.

For me, it seems that I am not using the correct code to retrieve the data from the previous step (Get records from SalesForce)

ticks(outputs('Get_records')?['CreatedDate'])

Any idea how can I call correctly that portion? outputs('Get_records')? and triggerBody()? do not work.

Thanks!

[Expiscornovus]

Hi @fokooko,

Get records will try and retrieve multiple records as an array. Even though it could only be one record in the result you still need would need to specify in your expression from which record you want the CreatedDate.

Can you try either a first function

ticks(first(body('Get_records'))['Created_Date'])

Or you could try and use an index like [0], [1], [2], etc.

First item

ticks(body('Get_records')[0]['Created_Date'])

Second item

ticks(body('Get_records')[1]['Created_Date'])

Btw, the triggerbody is the body from the trigger action. Which in this case is the Manually Trigger a flow action and not the Get Records action 🙂

[fokooko]

Hi @Expiscornovus ,

Thank you so much for your help! Appreciated.

I have tried the mentioned solutions, however, I get the below errors.

1. div(sub(ticks(first(body('Get_records'))['Created_Date']),ticks(first(body('Get_records'))['Case_Creation_Date__c'])),36000000000)

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#first for usage details.'.

2. div(sub(ticks(body('Get_records')[0]['Created_Date']),ticks(body('Get_records')[0]['Case_Creation_Date__c'])),36000000000)

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language expression 'div(sub(ticks(body('Get_records')[0]['Created_Date']),ticks(body('Get_records')[0]['Case_Creation_Date__c'])),36000000000)' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names. Please see https://aka.ms/logicexpressions for usage details.'.

Thanks in advance for any help you could bring.

[Matthy79]

Usually Power Automate creates a loop automatically if the result is an array (what should happen here). How did you create the formular. Did you type it on your own or did you use dynamic content (when the loop should have been created)?

Try to add a compose action after getting the record(s) and just add the dynamic content from the Date-Value you want to compare. After selecting it should create a loop. Let the flow run an see what is in the compose action.

[Expiscornovus]

Hi @fokooko,

Thanks for testing these expressions. Can you share a screenshot of your outputs section of the Get records action of one of your flow runs?

This way I can see the structure of the response and come up with a working expression.

[fokooko]

Hello @Expiscornovus 

Thanks again for your help. Below the requested output.

{"statusCode":200,"headers":{"Pragma":"no-cache","Transfer-Encoding":"chunked","Vary":"Accept-Encoding","Cache-Control":"no-store, no-cache","Set-Cookie":"ARRAffinity=06c56b8471ef26f13c61783eeb00d8e15bf74407238d9c8d8936521d5d5d2dd0;Path=/;HttpOnly;Secure;Domain=salesforce-scus.azconn-scus-001.p.azurewebsites.net,ARRAffinitySameSite=06c56b8471ef26f13c61783eeb00d8e15bf74407238d9c8d8936521d5d5d2dd0;Path=/;HttpOnly;SameSite=None;Secure;Domain=salesforce-scus.azconn-scus-001.p.azurewebsites.net","x-ms-request-id":"3fd78d46-934c-4e5a-92d4-2562f1d4cb3e","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","Date":"Mon, 12 Dec 2022 14:23:36 GMT","Content-Type":"application/json; charset=utf-8; odata.metadata=minimal","Expires":"-1","Content-Length":"13640"},"body":{"@odata.context":"https://flow-apim-msmanaged-na-westus2-01.azure-apim.net/apim/salesforce/6b8701f67fb74f92b57555bef6b582d7/$metadata#datasets('default')/tables('CKSW__Task__c')/items","value":[{"@odata.etag":"","ItemInternalId":"5a8bb33b-d478-48d1-be10-83f083323060","CreatedById":"0052700000649QFAAY","CreatedDate":"2018-03-14T03:38:05Z","CurrencyIsoCode":"USD","Id":"aCx1V0000001yk8SAA","IsDeleted":false,"LastModifiedById":"0051V00000705EqQAI","LastModifiedDate":"2020-08-24T17:23:36Z","Name":"0005487168","RecordTypeId":"01227000000WajAAAS","SystemModstamp":"2022-06-19T01:00:27Z","Access_only_for_HP_engineers_flag__c":false,"Action_Type__c":"Partner Onsite","Activity_Complete_Deviation__c":false,"Activity_Start_Deviation__c":false,"Additional_Site_Access_Time_Sec__c":0.0,"Assigned_Partner__c":"aIh27000000L02yCAC","Blackout_sites_flag__c":false,"Business_Center__c":"aD9G0000000PAtVKAW","CE_Badge_Number__c":false,"CE_Car_License_Plate__c":false,"CE_Email_Address__c":false,"CE_Name__c":false,"CE_Phone_Number__c":false,"CKSW__AccountName__c":"BANGKOK BANK PUBLIC COMPANY LIMITED","CKSW__Account__c":"0012700001lcnuDAAQ","CKSW__BypassUnsetIsProccedTrigger__c":false,"CKSW__City__c":"Pathunthani","CKSW__ContactPhoneNumber__c":"56621197","CKSW__Country__c":"TH","CKSW__Critical__c":false,"CKSW__Current_status__c":"Closed","CKSW__District__c":"aCdG0000000PBy0KAG","CKSW__DueDate__c":"2018-03-16T00:00:00Z","CKSW__Due_Date_Date_Time__c":"2018-03-16T00:00:00Z","CKSW__Due_Date_Date__c":"2018-03-16","CKSW__Due_Date_Time_24__c":"00:00","CKSW__Due_Date_Time_AMPM__c":"12:00 AM","CKSW__DurationDays__c":"0","CKSW__DurationHours__c":"1","CKSW__DurationMinutes__c":"0","CKSW__DurationText__c":"0 day(s) 1 hour(s) 0 minute(s)","CKSW__Duration__c":3600.0,"CKSW__ETA_Number__c":-1.0,"CKSW__EarlyStart__c":"2018-03-13T00:00:00Z","CKSW__Early_Start_Date_Time__c":"2018-03-13T00:00:00Z","CKSW__Early_Start_Date__c":"2018-03-13","CKSW__Early_Start_Time_24__c":"00:00","CKSW__Early_Start_Time_AMPM__c":"12:00 AM","CKSW__IsMST_Chain_Member__c":false,"CKSW__IsReadyForSchedule__c":false,"CKSW__My_Tasks__c":false,"CKSW__NotifyEmail__c":false,"CKSW__NotifyIVR__c":false,"CKSW__NotifyLongTerm__c":false,"CKSW__NotifyMidTerm__c":false,"CKSW__NotifySMS__c":false,"CKSW__NotifyShortTerm__c":false,"CKSW__NumberOfExcludedResource__c":0.0,"CKSW__NumberOfRelatedProduct__c":0.0,"CKSW__NumberOfRequiredResource__c":0.0,"CKSW__NumberOfResourceDependentTasks__c":0.0,"CKSW__NumberOfTimeDependentTasks__c":0.0,"CKSW__Number_Of_Preferred_Resources__c":0.0,"CKSW__Number_Of_Required_Parts__c":0.0,"CKSW__Number_Of_Required_Skills__c":2.0,"CKSW__Number_of_Used_Parts__c":0.0,"CKSW__Open_Date_Date_Time__c":"2018-03-13T00:00:00Z","CKSW__Open_Date_Date__c":"2018-03-13","CKSW__Open_Date_Time_24__c":"00:00","CKSW__Open_Date_Time_AMPM__c":"12:00 AM","CKSW__Region__c":"aCnG0000000Kz1RKAS","CKSW__RequiredTools__c@odata.type":"#Collection(String)","CKSW__RequiredTools__c":[],"CKSW__Stage__c":"Open","CKSW__Status_Icon__c":"<img src=\"/img/msg_icons/error16.png\" alt=\"Cancelled\" border=\"0\"/>","CKSW__Status__c":"Closed","CKSW__Street__c":"BBL-1649 Bangkok University","CKSW__TaskType_Duration_F__c":90060.0,"CKSW__TaskType__c":"aCwG0000000KyjkKAC","CKSW__TasksAssignedToMe__c":false,"CKSW__Time_Zone_F__c":"SE Asia Standard Time","CKSW__WorkOrderName__c":"WO-003519969","CKSW__WorkOrder__c":"aCz1V0000005UUfSAM","CKSW__Zip_Postal_Code__c":"12120","Case_Country_Timezone__c":"(GMT+07:00) Indochina Time (Asia/Bangkok)","Case_Creation_Date__c":"2018-03-14T03:18:50Z","Case_Number__c":"5001V00000uLZaCQAW","Case_Owner__c":"Manpower-somjetr Rangubrok","Case_Severity__c":3.0,"Close_Date__c":"2018-03-16T02:27:34Z","Closing_Summary__c":"YUTTHANA;SETUP CONFIG BIOS PC, Test ok and customer agreed to close the task. / ( sahaphab )","Completion_Date__c":"2018-03-14T04:40:00Z","Complexity__c":"Low","Contact_Email__c":"pradit.kus@bbl.co.th","Contact_First_Name__c":"Nipha","Contact_Last_Name__c":".","Contact_Name__c":"Nipha .","Contact_Phone_Number__c":"6621083151-3","Courier_Assist__c":false,"Customer_Engineer_Acknowledged__c":false,"Customer_Requested_End_Day__c":"16","Customer_Requested_End_Month__c":"03","Customer_Requested_End_Time__c":"10:00:00","Customer_Requested_End_Year__c":"2018","Customer_Requested_Start_Day__c":"16","Customer_Requested_Start_Month__c":"03","Customer_Requested_Start_Time__c":"10:00:00","Customer_Requested_Start_Year__c":"2018","Customer_Timezone__c":"(GMT+07:00) Indochina Time (Asia/Bangkok)","Delay_Code__c":"0-Response Met","Delivery_Contact_Edited_Flag__c":false,"Dependent_Task_External_Task_Identifier__c":"5327794940-531","Diagnosis_Own_by_PSP__c":false,"Dispatch_Contact__c":"+66 2 118 6000 or tha_crr1@hpe.com","Dispatch_Email_Sent__c":false,"Driver_License_Number__c":false,"Enroute_Email_Sent__c":false,"Entitled_Ser_Wind_End_DateTime_Text__c":"03/14/2018 14:18:00","Entitled_Ser_Wind_Start_DateTime_Text__c":"03/14/2018 10:37:54","Entitled_Service_Window_End_DateTime__c":"2018-03-14T07:18:00Z","Entitled_Service_Window_Start_DateTime__c":"2018-03-14T03:37:54Z","Entitlement_Mobile_Text__c":"Contract - (HPE Hardware 4H 9x5 Support) - HPE Hardware Maintenance Onsite Support  4HR Response / 9X5; Country Coverage","First_Time_Schedule_Email_Sent__c":false,"GPS_OFF_flag_for_Onsite__c":false,"Has_SDI__c":false,"Ignore_PSP__c":false,"In_Jeopardy__c":false,"IsCaseExchangeDestination__c":false,"IsWESSrc__c":false,"Is_Clone__c":false,"Is_Escalated__c":false,"Is_Same_Business_Day__c":false,"Latest_Service_Delivery_Time_Text__c":"2018-03-14 07:18:50","Lead_Customer_Contact_Agreed__c":false,"Log_Lead__c":false,"Longitude_Fixed_Point__c":0.0,"Maintenance_Window_Flag__c":false,"Manual_Dispatch_Flag__c":false,"Manual_Schedule_Flag__c":false,"Modifier_Name__c":"RESPONSE_TIME","Modifier_Value__c":"4HR","No_Auto_Dispatch_Flag__c":false,"OPD_Support_Flag__c":false,"Onsite_Contact__c":"0032700002FPVHoAAP","Onsite_Date__c":"2018-03-14T04:10:00Z","Order_Type_Code_Prefix__c":"05R","Order_Type_Code__c":"05R-Norml Contract","Organization_Name__c":"Bangkok Bank Public Co., Ltd.","Partner_Assignment_Reason__c":"Manually Selected","Partner_Email__c":"stradmin.bkk@str-engineeringsp.com","Partner_Rejected__c":false,"Partner_Selected__c":false,"Parts_Request_Pending__c":false,"Pinned__c":false,"Plan_Of_Action__c":"Compaq PRO 6300 - Often Hang","Problem_Description__c":"Compaq PRO 6300 - Often Hang","Product_Number__c":"MVSPCNBZ","Product_Series__c":"408692","ReadyForSyncFlag__c":false,"Repair_Class__c":"AO","Requested_Service_Window_End_DateTime__c":"2018-03-16T03:00:00Z","Requested_Service_Window_Start_DateTime__c":"2018-03-16T03:00:00Z","Reschedule_Manual_Dispatch__c":false,"Resident_24x7__c":false,"Resident_Location__c":false,"Resolution_Code__c":"Onsite Solution","Revisit_Any_But_Me__c":false,"Revisit_Manual_Dispatch__c":false,"Revisit_Only_Me__c":false,"Scheduled_Engineer_Badge_Identifier__c":"20397077","Serial_Number__c":"SGH346SMNB","Service_Delivery_Location__c":"a5P27000000eya5EAA","Service_Location_ID__c":"891153773","Service_Revisit_Flag__c":false,"Service_Window_End__c":"2018-03-16T03:00:00Z","Service_Window_Start__c":"2018-03-16T03:00:00Z","Service_Work_Order_Manual__c":false,"Severity__c":"3-NORMAL","Site_Access_Code__c":false,"Site_Access_Permanent_Change__c":true,"Site_Access_Required__c":"NO","Special_Access_Onsite_Resources__c":false,"Supplier_Resident_Engineer__c":false,"System_Down_Duration__c":0.0,"System_Fix_Time__c":"2018-03-14T04:40:00Z","System_Product_Number__c":"MVSPCNBZ","System_Serial_Number__c":"SGH346SMNB","Task_ID__c":"5327794940-531","Title__c":"Compaq PRO 6300 - Often Hang","Travel_Zone__c":"01","Visible_to_Manager__c":false,"Visible_to_User__c":false}]}}

[fokooko]

Hello @Matthy79 

Thank you so much for your comments and help.

I type my own one, I was not able to use any dynamic content and list from the Dynamic content tab.

Here the compose action.

Thanks again appreciate the time you put into this!

[Matthy79]

Hello @fokooko 

The results in the Compose actions are looking good. If you now use the ticks-function is it working?

Why is there a space between the LabelText of the compose action (Looks like "Created Date" and not "CreatedDate"). Can you hover the expression for it please.

For me it looks like the formular you are searching for is something like:

ticks(first(body('Get_records'))['Created Date'])

But @Expiscornovus also wrote this a view posts ago.

So can you please post the expression of the current two Compose actions and the formular you are currently using.

[Expiscornovus · Accepted solution]

Hi @fokooko,

Can you try this instead. I see the items are stored in the value field of the body. I have added that field to the expression.

ticks(body('Get_records')['value'][0]['Created_Date'])

[fokooko]

@Matthy79 Thank you so much, this has been resolved. Appreciate all your help!

[fokooko]

Hi @Expiscornovus, Many thanks for your help, the below input resolved my issue. Appreciate all the time you put into this, it really means a lot to me.

Take care.