Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Populate Link field "M...
Business Central forum
Suggested answer

Populate Link field "Map-to Dimension Value Code" in IC Dimension Value Table via Power Automate

(1) ShareShare
ReportReport
Posted on by Sghotekar 74
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": "???"
}
 
Categories:
Integration with Dynamics 365 products
Integration to Power BI, Power Apps, Power Automate and Dataverse
  • Sghotekar Profile Picture
    Sghotekar 74 on at
    Populate Link field "Map-to Dimension Value Code" in IC Dimension Value Table via Power Automate
    Hi YUN ZHU,


    Right now, I am retrieving the value of the "Code" field from the Dimension Value table, assigning it to a variable, and then passing this variable to "MaptoDimensionValueCode." However, when I insert the record into the IC Dimension Value table, the "Map to Dimension Value Code" field is not being populated.
     
     
     
    Thanks
    Souras
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    Populate Link field "Map-to Dimension Value Code" in IC Dimension Value Table via Power Automate
    Hi, do you want to add a condition? If the value is not found in the "Dimension Value" table, an error will be reported when you post.
     
    Thanks
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 9,472 Most Valuable Professional on at
    Populate Link field "Map-to Dimension Value Code" in IC Dimension Value Table via Power Automate

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans