Exam AB-410 Topic 1 Question 67 Discussion

Actual exam question for Microsoft's AB-410 exam
Question #: 67
Topic #: 1
A company is using a model-driven app to process orders. The company uses a custom integration to add orders to Microsoft Dataverse from two separate point-of-sale solutions.
Order numbers are stored in a column on an Order table named Number. The order numbers are prefixed with the value POS1- or POS2- depending on which point-of-sale system they originated from.
The company creates a calculated text column to store the clean order number. The clean order number must remove the point-of-sale system prefix.
You need to configure the action on the calculated column.
Which formula should you use?

Suggested Answer: C Vote an answer

To remove the point-of-sale system prefix, you should use the TRIMLEFT formula.
The exact configuration requires passing the Number column as the first parameter and the number of characters to remove (5) as the second parameter: TRIMLEFT(Number, 5).
Reference:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields

by Kevin at Jul 29, 2026, 06:05 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10