Where does the "Party Number" field in the Contacts table come from?

[jasonyeung87]

Hi,

I currently have a Power Automate flow that inserts a record in the Contacts table of our Dynamics CRM when a Microsoft Form is filled out. The fields in this form consists mainly of the first / last name, organization and company. It was created a couple of years ago, but started failing when the owner of the flow left our company. I've been tasked to look into it.

When I did, I found that it was using a deprecated Dynamics 365 connector and recommended I use a Dataverse connector to insert the record. I did this, but noticed there's an additional field named "Party Number" in the contact table and it's required. 

I had a look at the dynamics CRM and initially I didn't see a Party Number in the field, but when I edited the columns in the Contacts list view, I found there is a column named "Party Number":

I added this column to the view to see what values are stored. They appear to be auto-generated data:

I was wondering if you know where this field is from? I searched for information about this and found this link, which mention dual-write party model:

Dataverse customers, vendors and contacts with dual-write party model and global address book app (P...

I'm not sure if this is where it's from or whether there's a way to check if this is installed in our environment. Because this field is required and the Microsoft Form doesn't have this field, I can't update the flow and am not sure if there's a way to not make the Party Number required or enter some dummy value.

Jason

[Expiscornovus]

Hi @jasonyeung87,

Yes, it is possible Party Number (which is an auto number type of field) is coming from that Global Address model azure template:

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/upgrad...

Normally with autonumbers you don't have to provide any value yourself. That is the whole purpose of an autonumber.

However, it looks like that field is business required. That's why it is asking you to provide a value in your action.

You can try and workaround that by setting the value to null via an expression. In the background it should still generate a new autonumber for that new row.

null

[pavanmanideep]

Hi,

This is an autonumber field in Dynamics, you can go to form properties and set this as optional. You may refer to below posts for more detailed information.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Autonumber-in-Common-Data-Service-Primary-Fi....

https://www.c-sharpcorner.com/article/create-auto-number-field-in-dynamics-crm/

Hope this helps..

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

Blog:https://ecellorscrm.com

Cheers,

PMDY