How can I get inserted id of common data service table after form submitted through powerapps

[mjx]

I have a canvas app and the forms are populated from common data service, how can I get inserted id of common data service table and once I get the inserted Id I need to add records to second table which is many to many relationship with first table. 

onSuccess of form I tried the following code but it does not show the ID or guide

          Form1.LastSubmit

[v-siky-msft]

Hi @mjx ,

Please try to use Form1.LastSubmit.GUIDField to obtain the GUID from the record submitted just now. In addition, I would 

Note: Don't use ResetForm() function, it cleans up the form, and Form1.LastSubmit would return blank.

Hope this helps.

Sik

[mjx]

When I type  Form1.LastSubmit.Guid there is no guid field and there is no ID field. it shows other fields. do you know what is the primary key in a common data service table ? or how can I enable it to show in the column list, views, forms ?

[v-siky-msft]

Hi @mjx ,

You can go to CDS/Dateverse Table to find the GUID field which data type is Unique Identifier. For example:

Hope this helps.

Sik

[mjx]

In my tables I don't see Unique Identifier, my tables are custom tables not existing tables.