I am inserting a record into the "Intercompany Dimension Value" table using an HTTP call in Power Automate. In this table, there is a field named "Map-to Dimension Value Code" that needs to link to a record in the "Dimension Value" table. How can I achieve this lookup and ensure the "Map-to Dimension Value Code" field is correctly populated with the appropriate value from the "Dimension Value" table? Below is the Body of my HTTP call out for the POST method
{
"Code": "@{variables('BC dimension Code')}",
"displayName": "@{variables('Name')}",
"dimensionCode": "@{variables('Dimension Code')}",
"MaptoDimensionValueCode": "???"
}