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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SUBMITTING SQL SET GUI...
Power Apps
Unanswered

SUBMITTING SQL SET GUID DATA TYPE TO SQL

(0) ShareShare
ReportReport
Posted on by 4

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! 

S_chap_0-1645524753961.png

Any support would be greatly appreciated. 

 

Thank you 

Categories:
I have the same question (0)
  • timl Profile Picture
    36,391 Super User 2025 Season 2 on at

    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard