Notifications
Announcements
Ok so fairly new to Power Apps. I am using a flow button to collect data and enter it into a SQL server table. All that is working great and next I made a gallery to show all of the items entered into the database. I added a delete button to the gallery that ties back to the database and will delete the record. Next I want to make it where once the arrow button is selected, it will take you to a detail page that will also allow you to edit the data. I believe I have all of that figured out as well to allow editing. Next I would like to be able to click the confirm button and patch the selected gallery items back to the SQL table. Am I looking at this the wrong way? I know patch was working fine when I was just using the built in collection in lieu of SQL table. I was thinking maybe it had to do with my inputs? For inputs I was using a mixture of combo boxes and drop downs and now with the edit page I have it all in text only form.
Didn't mean to add the "items" snip it was suppose to be this one.
Hello,
Please refer to the links below, which you should give some more information around how to use patch to update SQL table and general guidance.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Patching-to-a-Single-Record-in-an-SQL-Table/td-p/30634
https://www.youtube.com/watch?v=0xZ4fMJbLvk
https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 793 Most Valuable Professional
Michael E. Gernaey 333 Super User 2025 Season 2
Power Platform 1919 268
