Power Platform Community Forum Thread Details

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.

Categories:

General topics