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 Apps
Suggested Answer

Submission issues

(0) ShareShare
ReportReport
Posted on by 58
Hi All
 
I have a powerapp here which is using a SQL data source. I have a Browse page which leads to an Edit page.

I want the edit page to be able to update a single data card, which is in the form of a Toggle button. the idea being that the user arrives at the edit page and uses the toggle (in this case, the toggle means a works order has been re-planned), user hits submit, success screen, then automatically navigates to home, done.
 
I dont get errors in the code until after i run it. And the error is vague "network patch issues". See my attached image for a visual reference. The error occurs when the submit button is selected, and the page just stays where it is.

Thank you for any suggestions!
 
FYI. I blanked the name out for GDPR purposes so ignore the name field.
I have the same question (0)
  • Suggested answer
    MS.Ragavendar Profile Picture
    5,036 Super User 2025 Season 2 on at
     
    For the patching the SQL, the primary key is mandatory.
     
    Is the Primary Key added in the SQL table ?
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
  • michael_91 Profile Picture
    58 on at
    Hello  

    I have tried what you have suggested. I tried including a primary key field in two places within the code. Both failed. Please see the images attached what i have tried. 
     
     
  • MS.Ragavendar Profile Picture
    5,036 Super User 2025 Season 2 on at
     
    Toggle will return value (True/False) what will the backend type of the column which you created Is it boolean or some other?
  • michael_91 Profile Picture
    58 on at
     
    Please see the image attached of the SQL table. The field is down as BIT. Which should be right?
  • Suggested answer
    MS.Ragavendar Profile Picture
    5,036 Super User 2025 Season 2 on at
     
    A bit will works for sure.
     
    I also find the blog which typically works for you - https://www.mssqltips.com/sqlservertip/7031/sql-server-data-power-apps/
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

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 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard