Get Text Values in PowerAutomate

I’ve been using Power Automate a lot recently. I’m loving it. I’m addicted to this thing! One of the challenges I found was getting the text-value of the option set or lookup so that I could use the text in an email or other record.

If you’re using the Common Data connector, you may see the text you need in the body-result;

<fieldname>@OData.Community.Display.V1.FormattedValue

The data is not available in the Dynamic Data popup pane. Here’s how to reference it.