web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update a row from look...
Power Automate
Unanswered

Update a row from lookup field

(0) ShareShare
ReportReport
Posted on by 894

Hey,

 

I have this indata: 

{

  "_key_area_value": "c6b78d25-0a37-ec11-8c64-000d3a22e25d",

  "_key_area_type": "key_areas",

}

In the outdata I have this:

{

  "_key_area_value@OData.Community.Display.V1.FormattedValue": "West",

  "_key_area_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "key_Area",

  "_key_area_value@Microsoft.Dynamics.CRM.lookuplogicalname": "key_area",

  "_key_area_value@odata.type": "#Guid",

  "_key_area_value": "c6b78d25-0a37-ec11-8c64-000d3a22e25d"

}

The string I would like to fetch is "West".

 

I have been working with:

 

 

triggerOutputs()? ['body']['xxx']

 

 

where xxx has been the field I have been trying to fetch, like "_key_area_value". But this will not give me "West", it gives "c6b78d25-0a37-ec11-8c64-000d3a22e25d". 

 

I have also tried to use this form the output:

 

 

triggerOutputs()? ['body']['_key_area_value@OData.Community.Display.V1.FormattedValue']

 

 

But this one it can't find as it's not been created yet.

 

This is how the flow looks, if it makes it easier to help. The triggerOutputs added are working fine, but adding this one, doesn't work. Unfortunately, the language doesn't change to English even after I have changed it in the settings so, hope that you can still understand:

Skärmavbild 2021-10-28 kl. 12.53.47.png

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 237 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 194

Last 30 days Overall leaderboard