
Announcements
Hi,
I have a Rowpointer primary key in my database which is set as a GUID data type. When I load the data into powerapps this is a view text field. However, when I try and submit my form it states that the row pointer field is required. I have tired adding GUID() into the datacardvalue and still have no luck submitting data. I have also tried a patch vs submit form with no luck!
Any support would be greatly appreciated.
Thank you
Hi @S_chap
A workaround for this is to take a data card for an existing field, and to modify the properties of the card to update your RowPointer column.
For example, you can unlock and customise the zone_stored data card by setting the following properties:
Set the Datafield property to "RowPointer"
Set the Default property to ThisItem.RowPointer
Set the Update property to the following:
If(EditForm1.Mode = FormMode.New,
GUID(),
ThisItem.RowPointer
)
You can then re-add your zone_stored field via the Fields>Add Field dialog and hopefully, you should be able to create records using the form.