web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Creating a Dynamics contact from Forms data

(0) ShareShare
ReportReport
Posted on by 8

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.

 

njc_0-1594395316891.png

 

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.

I have the same question (0)
  • Power Platform Communities Profile Picture
    8 on at

    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.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 41

#2
Martin Dráb Profile Picture

Martin Dráb 36 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans