Power Platform Community Forum Thread Details

Hi all,

I was wondering if someone ever face this issue before, I created a model driven app with forms, views, business rules to set some fields by default for the entity. But the main problem is that when I created a new record for the entity "Employees", the field "Id" is an unique identifier and an auto-incrementable number in SQL Server, that means that is supposed to auto-populate the field by itself in CDS Common data services but is not getting populate (Id stays blank), but the new record is created correctly in SQL Server because I created a flow that once a new record is created in CDS it will create a new record in Azure SQL server, this also will apply changes for the update and delete. Any ideas on how to solve this?

1. I created an entity "Employees" with all the fields and I set a business rule in order to set some values by default.
2. I created a form for the entity so the users can create new records.

3. I created a view where the user can visualize all the fields and records from the "Employees" entity.

4. I created a flow in order to connect the CDS and the azure SQL Server once the record is created, updated or delete.

5. I created a new record for the entity "Employees" but the field "Id" (unique identifier and auto-incrementable number) is not being populated in CDS (Common data services) but in SQL server the "Id" is created successfully.