First time posting so if I'm doing something incorrectly please have patience.
We have created a new Lookup field that is on the Opportunity and I need to populate with a value this is a related table. We need to run a flow to update all the opportunities with the new lookup value. I am able to get the correct list and can expand the values in the related entity but whenever I try to access the GUID, it returns as empty.
I have tried many different ways to access the guid but I can't seem to get the GUID so I can update the new field. Can someone see what I'm doing wrong?
The code of my List action is:
{
"inputs": {
"host": {
"connectionName": "shared_commondataserviceforapps",
"operationId": "ListRecords",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps"
},
"parameters": {
"entityName": "opportunities",
"$select": "name",
"$filter": "customentity1 ne null",
"$expand": "New_Lookupfield($select=new_name, cdx_Project)",
"$top": 2
},
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
},
"runtimeConfiguration": {
"paginationPolicy": {
"minimumItemCount": 10000
}
}
}
When I try to load the results into an HTML table, I can see the name (string) from the related table but the GUID (called cdx_Project) is blank. Here is the peek code from the HTML to show the syntax I'm using.
The code for the HTML table showing how I am referencing the ID is:
"columns": [
{
"header": "Opportunity",
"value": "@item()?['name']"
},
{
"header": "new_Name",
"value": "@item()?['New_Lookupfield/new_name']"
},
{
"header": "cdx_Project",
"value": "@item()?['New_Lookupfield/cdx_Project']"
}
]
}
}
