Text value in drop down shows in number

[CalvinC]

I actually have two issues in this flow created for Dynamics Sales.

1. The flow would fail if there's no info entered for "Fee Estimate". How can I make the flow ignore the null? The error detail is "Evaluation of inputs for the expression action of kind 'FormatNumber' failed: 'Required property 'number' expects a value but got null. Path ''.'."

2. The "Pursuit Stage" is a dropdown field in Dynamics, however, in the email, it's shown as a number instead of the text value. There's no option to select a 'value'. I think it's the formatting issue.

Any help is appreciated!

[v-xiaochen-msft · Accepted solution]

Hi @CalvinC ,

For the first question, we can add a condition to check if this number is blank.

For the second question, we can check the outputs from 'Get a row' action.

Best Regards,

Wearsky

[Sundeep_Malik]

Hey @CalvinC 

Yes both issues can be fixed.

1) For this. You will have to use error/exception handling in power automate.

You can do this in your flow.

In the send an email action, select the three dots. Click on configure run after. Select the following setting in that:

What this will do is, if the formatted action fails somehow. It will just go forward and not just get stuck there.

Now in send email action. Write the following expression:

if(equals(outputs('Format_number')?['body'],null),'NA',outputs('Format_number')?['body'])

This will check if the formatted number is null then it will give NA otherwise it will give your formatted number.

2) For the second part. I want you to run the flow. Add a compose action. In that add body from dynamic content.

When you run the flow check which value is giving you the text.

It should look like this:

"columnname@OData.Community.Display.V1.FormattedValue"

Now you have to write the expression something like this:

triggerOutputs()?['body/The above value you got']

This will solve both your problems.

Just a suggestion. Use send an email V2 of outlook connector. Dont use send an email V3 action.

V3 has many limitations that it can only send 100 emails every 24 hours.

V2 can send 900 emails every 60 seconds.

Plus V3 has stopped working many times in the last year and many people were annoyed by that.

I hope this helps 🙂

[CalvinC]

Sundeep,

The first issue has been resolved. Thank you and I'm still checking on the 2nd issue.

[CalvinC]

Wearsky,

I will be looking this for the 2nd issue and report back. Thank you!

[CalvinC]

I could not find that particular  "columnname@OData.Community.Display.V1.FormattedValue" and wondered if it's in a different table.

[CalvinC]

I did see the particular line of "columnname@OData.Community.Display.V1.FormattedValue" for my field "Pursuit Stage" in the output. Any suggestion?

[Sundeep_Malik]

@CalvinC 

Yup write it like the expression I have given above in one of my reply:

Your column formatted value:

columnname@OData.Community.Display.V1.FormattedValue

With this expression:

triggerOutputs()?['body/The above value you got']

So it should something look like:

triggerOutputs()?['body/

columnname@OData.Community.Display.V1.FormattedValue']

I hope this helps 🙂

[CalvinC]

Hi @Sundeep_Malik,

There's no info in the output for the dropdown fields I needed. I've identified the field name is ts_pursuitstage so as suggested, I used the expression below but did not get anything from the flow. Any other suggestions are appreciated!

triggerOutputs()?["body/ts_pursuitstage@OData.Community.Display.V1.FormattedValue"]