QuestionQ18
Build business application logic and automationA company uses a model-driven app to process orders. It uses a custom integration to add orders to Microsoft Dataverse from two separate point-of-sale solutions.
Order numbers are stored in a column named Number on an Order table. Each order number is prefixed with POS1- or POS2-, depending on the point-of-sale system from which it originated.
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?
- A CONCAT(Number, “4”)
- B TRIMLEFT(Number, 4)
- C TRIMLEFT(Number, 5)
- D TRIMRIGHT(Number, 5)
- E TRIMRIGHT(Number, 4)
Community Discussion