cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Numeric value in email instead of text

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 

 

Flow 1.JPGFlow 2.JPG  

15 REPLIES 15
Super User III
Super User III

Hi @Anonymous 

 

You need to use the below expression

 

_yourfieldname_label 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Super User III
Super User III

Try something like this

 

item()?['_yourprefix_YourOptionSetField_label']



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Anonymous
Not applicable

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.

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Super User III
Super User III

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




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Anonymous
Not applicable

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. 

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




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Anonymous
Not applicable

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?

ticket flow 1.JPG

 

Thank you,

 

Best Regards. 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Anonymous
Not applicable

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)

 

ticket flow 3.JPG

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Anonymous
Not applicable

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.

 

 

Super User III
Super User III

Hi @Anonymous 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Anonymous
Not applicable

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.

 

ticket flow 4.JPGticket flow 5.JPG

 

ticket flow 6.JPG

 

 

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (61,011)