Numeric value in email instead of text

[Anonymous]

Hello good afternoon, 

I created a flow to send an email and in the body of that email I have several dynamic values that are returned in the filling of the forms, one of the values is a multiple option field and instead of appearing in the email as the option that was selected appears a the numeric value associated with that selection.

Can you help me?

Best regards 

  

[abm]

Hi @Anonymous 

You need to use the below expression

_yourfieldname_label 

[abm]

Try something like this

item()?['_yourprefix_YourOptionSetField_label']

[Anonymous]

Hello good afternoon @abm 

Thank you very much for your answer.

Can you tell me what do you mean by the prefix and the label please.

I'm new to flow sorry.

Thank you,

Best regards.

[abm]

Hi @Anonymous 

In CRM your field names generally called with a prefix so say for example I got a custom field called test and my solution prefix is aj the field in crm is called aj_test. This prefix is applicable for only custom fields. If your optionset field name is custom then you need to use your name in the below format I mentioned. If it's an out of the box entity then use _fieldname_label

Thanks

[Jcook]

Hello @Anonymous

The best way I found to get the values I want, is to do a Lost records with no filter. Turn on Top count to 1 so you only get 1 record.

Now you can run the flow and check what the exact field names are that have the data/information you want to display.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

Hello good afternoon, @abm 

Thank you very much for your answer.

I tried to use the expression iten()?[_jscfts_project_type_label] and when I check the email the text was black didn't appear the value.

Do you know why?

@Jcook  can you elaborate on Lost records with no filter, how can I do that?

Thank you,

Best regards. 

[Jcook]

Hi,

If you add an action and search for Common Data Service, and look for a List records action.

Than leave the Odata filter blank
But in the top field put 1 so you only get 1 record back so you can view in the flow run history.

Now run the flow and open the List records action. This will display all the field names and what values are associated with them.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[abm]

Hi @Anonymous 

Check your run history. Open the latest run history record. Expand each steps and see the outputs. Check the names in output of the retrieval or get item step. This should reveal which fields (Output) you are getting from the relevant action steps.

Thanks

[Anonymous]

Hello good afternoon, @abm 

Thank you for the answer,

I tried again to run the flow again and check the label and value in the body of the outputs, I tried to run a triggerbody?()['_jscfts_project_type_label'] instead of the item but gave me an error.

The item?()['_jscfts_project_type_label'] still don't work.

Is there anything I can try?

Thank you,

Best Regards. 

[abm]

Hi @Anonymous 

Thanks for your reply.

The easiest way to do is map the 'jscfts_project_type' field which is already available from the dynamic menu. Then move your cursor to the mapped field. This should reveal the tooltip of the field and exact syntax. Once you figured the exact syntax then  remove the earlier mapping then click the expression and type the jscfts_project_type_label similar like your earlier mapping.

Thanks

[Anonymous]

Hello good morning,

@abm 

@Jcook 

Sorry for my delay in the response and thank you for your answers.

I made several changes to my flow to output the records in text form, I add a record list, a select and a create HTML table to output the result and it worked, but now I have another problem.

Every time I add a new project the table send all the records created. How can I clear the table every time a new project is created?

Can you help me?

Thank you.

Best Regards.

(I'm sharing here the changes I made)

[abm]

Hi @Anonymous 

What is your trigger of your flow? If you looking only one record then use the trigger as When a record is created.

Thanks

[Anonymous]

Hello good morning,

Thank you for your answer @abm 

I'm starting my flow with the trigger "when a record is updated" because I want this flow to be triggered when is in the last stage.

If I put that trigger don't allow me to select the last stage of my bpf.

Can I do it with a condition?

Thank you,

Best Regards.

[abm]

Hi @Anonymous 

Could you please explain more about last stage of bpf? What does that meant by?

Thanks

[Anonymous]

Hello good morning,

@abm 

I have 3 stages in my BPF and I want to trigger the flow in the last stage "Project Base Line" when you click on finish.

Here is a print screen.