Mapping Lookup values from Dynamics 365 Marketing Form Submissions with Power Automate


This article explains how to make lookup values human-readable in Dynamics 365 Marketing Form Submissions with Power Automate. The post covers how to parse the marketing field response value as JSON, find the correct pluralised name and primary name values, and get the name of the row. Finally, the article explains how to append the form field response to a variable that may hold a text summary of the form submission or a JSON summary. This post is intended as a stepping stone to be used as part of something else, such as exporting marketing form submissions to Excel, and to extend custom field mappings flow to create marketing form submission summaries.


Article 21m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time