You create an automated flow that compares the project item's due dates in the SharePoint project plan list with today's date for the new or updated SharePoint list records.
You use the ticks function to compare dates.
You need to be sure that the ticks function has a valid input if a due date value is missing.
Please select SLOT3 and SLOT4 for the condition expression.
Click on the arrows to vote for the correct answer
A. B. C. D. E. F. G.Correct Answers: B and G
Power Automate expression builder helps users create expressions that contain functions, operators, variables, explicit values, or constants.
All expressions are organized in groups, like String functions, Collection, Logic functions, Manipulation, and others.
Power Automate and Azure Logic Apps use the Workflow Definition Language for their expressions and definitions of their flows.
When you need to compare the date-time expressions, you can use the ticks function.
This function provides the number of 100-nanosecond intervals since midnight of January 1, 0001, like for "2021-05-06T07:00:00Z" timestamp has 637558812000000000 ticks.
If somebody does not provide a "Due date" value, this field's value will be null.
Therefore, you need to use the coalesce function to supply a non-null value as a ticks parameter.
The coalesce function checks the input value (or values) for a null and returns the value instead of null:the input or a predefined value if the input is null or not null.
To add the ‘Due date' field value to the expression, you need to reference it using the triggerBody() function:
triggerBody()?['Duedate']
This expression is the first parameter for the coalesce function.
The second parameter is the predefined value for a date-time.
In our case, it is '01/01/1901' formatted as 'MM/dd/yyyy':
formatdatetime('01/01/1901','MM/dd/yyyy')
Option B is correct because the SLOT3 is triggerBody().
Option G is correct because the SLOT4 is formatdatetime.
Here is the expression:
ticks(coalesce(triggerBody()?['Duedate'],formatdatetime('01/01/1901','MM/dd/yyyy')))
All other options are incorrect.
For more information about Power Automate expressions, please visit the below URLs: