Question 101 of 130 from exam PL-400: Microsoft Power Platform Developer

Question 101 of 130 from exam PL-400: Microsoft Power Platform Developer

Prev Question Next Question

Question

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 SLOT1 and SLOT2 for the condition expression.

SLOT 2 SOS) |? ['Duedate'], SLOT 4 |('@1/01/1901', 'MM/dd/yyyy')))

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F. G.

Correct Answers: F and H

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 to ticks.

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.

Option H is correct because the SLOT1 is ticks.

Option F is correct because the SLOT2 is coalesce.

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:

Prev Question Next Question