Looking for something in particular?
Categories
- AI Builder 3
- Azure 10
- Canvas Power Apps 4
- Custom Pages 5
- Customer Voice 6
- Dataverse 25
- Dynamics 365 39
- Dynamics 365 Marketing 86
- Dynamics 365 Portals 11
- Dynamics 365 for Outlook 3
- JavaScript 9
- Marketing (Non Dynamics 365) 7
- Micro Enterprise Financials 2
- Microsoft Excel 2
- Microsoft Forms 2
- Microsoft PowerPoint 2
- Microsoft Teams 2
- Model-driven Power Apps 37
- Office 365 3
- OneDrive 1
- Outlook 2
- PCF & Custom Controls 14
- Power Automate 73
- Power BI 3
- Power Platform 5
- SharePoint 4
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.
Choices: Spreadsheet or CSV into Dynamics 365 JSON
Extending the previous post ‘Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings’ to populate Choice (Option Set) values in the Dataverse JSON, rather than just strings.
Lookups and Owners: Spreadsheet or CSV into Dynamics 365 JSON
Extending the previous post ‘Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings’ to populate Lookup values in the Dataverse JSON, rather than just 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.
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.
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.
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.