
Hi there, I'm new to the Power Platform and I'm struggling with something that I thought would be very simple.
I have a Form that collects new contact information (title, forename, surname, etc), which then triggers a new Flow to create a new Dynamics contact record using the data captured by the Form.
The issue I have is that in the Common Data Service 'Create a new record' step in Power Automate, the dynamic content from the Form isn't available to me when I click on certain fields, like those associated with option sets, e.g title.
I've been researching this issue for hours, and not found a solution yet but from what I've read so far, it could be something to do with labels versus values, but I'm not sure.
In Dynamics, I've found that the contacts title is an option set with labels of 'Mr', 'Mrs', 'Miss', etc and their accompanying values '315910000', '315910001' ,'315910002', etc. Do I need to somehow map the title entered on the Form, e.g. 'Mr' to it's value in the option list, e.g. '315910000', then use that?
Any help would be greatly appreciated.
So optionset values take values like 100000, 100001 etc. So, you need to fill it there. What you can do is initialize a variable. Put a switch condition and get response data from the form. Based the response you get set the value of title to 10000,10001 etc. And then put that value in the Title Value field.