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

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

How to make sense of lookup responses in a Marketing Form submission, when the form response says {"Id":"b580cd20-8e2a-ee11-bdf4-0022482578b5","LogicalName":"amey_country"} but what it actually means is ‘Australia’. If your users can’t speak GUID then this ones for you.

Read More
Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings

Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings

How to import a spreadsheet list of contacts or leads, into a marketing list in Dynamics 365 or Dataverse. If they are all new rows, its not too bad, but otherwise its a very manual export/import/VLOOKUP hodgepodge.

This post will show you how to create a flow which turns a CSV file with display names, into a populated marketing list in Dynamics 365. The fields are flexible. Import Contacts or Leads. Use New or Existing rows. Populated Standard or Custom fields.

Read More
Mapping Option Sets/Choice Labels from Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Mapping Option Sets/Choice Labels from Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

How to make sense of option set/choice responses in a Marketing Form submission, when the form response says ‘15’ but what it actually means is ‘My dog ate my homework’. If your users can’t speak integer then this ones for you.

Read More
Set Dataverse Choices in Power Automate  dynamically - without a switch statement!

Set Dataverse Choices in Power Automate dynamically - without a switch statement!

Setting the value of a Dataverse choice option set or choices multi-select option set column field in Power Automate can be a little tricky. Flow expects either a static choice or the choice ‘Value’ rather than the ‘Label’. Smaller choices work ok with a switch statement but what about when your choice has 10+ choices? Here is a way to avoid cumbersome switch statements to handle larger choice lists.

Read More
Mapping Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Mapping Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Marketing forms in Dynamics 365 are great for creating and updating contact and/or lead records, but not much else. The documented way to handle form submissions beyond lead or contact is to build a classic workflow but that in itself is very restrictive. By moving the automation into a Power Automate flow it opens up many more doors in terms of generation submission reports, notifications and sophisticated record manipulation that cannot be achieved with classic workflows alone.

Read More