Share
Report
96I have a list dataverse rows action pointed at a table that is related to another table in dataverse. I want to get the values and write them to a Create CSV action, however nothin is returned for the lookup column values.
Example:
Table ProjectLifecycle contains a column called 'Stage'.
'Stage' is a lookup type column that looks at the text type column in a table called Projects.
Here is some more detail:
After performing List Rows, the dynamic choices available don't bring back the text value.
If I wrap the output of the list rows action in an XML array I can see that the lookup column is coming back as:
"_activestageid_value@OData.Community.Display.V1.FormattedValue": "XXXXX"where XXXXX is the actual value I need (it's a word).
Is there an expression I need to use in the Select action to get that value returned?
Appreciate any guidance anyone can offer.
All responses (
Answers (
