Lookup Field Returning Null

[TracyLivingston]

Hello,

I'm hoping someone can help with this issue of blank Lookup type fields.

I have a flow that renders data fine for all fields other than Lookup. The flow runs but the email or Teams channel message renders blank values for those fields.

How do I return the values for Lookup fields?

Thanks in advance!

[Rhiassuring]

Hi there, 

Can you show the flow actions for how you're entering the data? 

Fields like Modified By and Owner will usually have additional fields in Dynamic Content you can select, like Owner Email, or Owner DisplayName or Owner Department. I just want to check and see if it's an issue with that, and also verify if you're talking about true SharePoint Lookup fields.

[TracyLivingston]

Hello @Rhiassuring !

I'm using List Rows and Select Columns. I also tried using Expand Query for to owner name. These fields are part of a form in Dynamics and not SharePoint. I added the "Owner Email" as a string and I can pass that data fine but I'm populating that field with a business rule and static email address which is counter productive since I'm trying to automate the email address being tied to the Owner. The ultimate goal here is to trigger an email and Teams message (which is working) to the record owner, and one other Lookup type field email address.

Thanks for your help!

I've tried using Compose as well to pull the owner value. I know it won't be the email address but just trying to pull any data from the lookup fields and they're all null.

[TracyLivingston · Accepted solution]

I was able to do this by:

-Get a row by ID

-Compose

-Expression: items('Apply_to_each')?['_xxxxx_value@OData.Community.Display.V1.FormattedValue']

This returned the value instead of the internal ID like I needed.