CRM addicted

Substrings Today we will look at an example, how to extract a substring from a given string. Our aim is to extract the file extension of a note (attachment in CDS) from the mime/type field. Single vs. multiple records First we fetch our underlying note using either the get record or the list records CDS action: Depending on the action you choose, the formulas below differ, since "Get record" returns just one single record, while "List records" can return multiple records. For a single record you will reference your fields like outputs('<Name of your action>')?['body/<'name of your field'>']. While for multiple records you will have to put your actions into an apply to each "group" and will reference your fields like items('<name of your apply to each action>')?['<fieldname>']. Extract substring Once we have added an action to fetch our underlying record: we are ready to ...