cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcfDaniel
Frequent Visitor

Lookups display value in flows - Dataverse

Hi,

 

This might be old news but I have realised it just now and haven´t found a thread on it, so I decided to share...

 

In the dynamic content only a subset of keys are made available from a previous step like get row by id for selection on the following steps. However, if you take the entire JSON object response from that get row by id you will find many more key/value pairs.

 

Lets take the modified by, for example:

 

  "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "User Name",
  "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
  "_modifiedby_value@odata.type": "#Guid",
  "_modifiedby_value": "a5082285-de4a-ec11-8f8e-000d3ab748f1",

 

From these 4, dynamic content will show you only the last 2, hiding the name of the user and in this case that was what I was looking for.

 

One option would be to make a list rows step and get the record of of the user, but there is another option:

 

- take the key you need: "_modifiedby_value@OData.Community.Display.V1.FormattedValue"
 - Insert a compose and use a concat() with one of the available values from dynamic content and then edit the portion that instanciates de key: 
concat(outputs('Get_a_row_by_ID_Subscriptions')?['body/_modifiedby_value@OData.Community.Display.V1.FormattedValue'])

 

The output of the compose will be the user's display name.

 

Again, not sure this will help anyone but I hope so.

Regards.

0 REPLIES 0

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (2,980)