cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ddarko2215
Level: Powered On

Patch Stopped working after going from 3.19091.18 to 3.19092.12

Patch formula does not appear to be working with sql table any longer  Reverted back to 3.19.091.18 and the same command works correctly. I've attempted removing the connection and rebuilding the connection as well as rebuilding the table it was updating to no avail.  The formula gives an error The requested Operation is Invalid: A value must be provided for an item.

1 ACCEPTED SOLUTION

Accepted Solutions
ddarko2215
Level: Powered On

Re: Patch Stopped working after going from 3.19091.18 to 3.19092.12

Thanks for the reply! After spinning my wheels for a while, I went sleep, woke up and it all starting working. Scratching my head on it.   To answer your question it is a azure sql db.  When the problem was occuring my patch formulas that updated a row were working but the patch formulas that inserted a new row stopped. The troubleshooting steps I took; 1. Run an insert into command on the table with the same service account that the data connection is running. Result was successful. 2. Delete the data source from the power app and re-add: Didn't resolve the issue 3. Revert application back to previous power apps release: Worked! 4. Reverted back to new version: stopped working 5. Went to sleep: 6 Woke up: it started working again on new version:

 

Command
Patch('[dbo].[WR_AppReadinessEmail]',Defaults('[dbo].[WR_AppReadinessEmail]'),{EmailDate:Now(),AppInfoID:First(AppComboBox.SelectedItems).ID,AppName:AppNameLookup.Text, VendorEmail:TextInputVEmail.Text,EmailStage:2,FormsSubmitEmail:User().Email,AppIdentifier:IdentifierLookup.Text,NumberOfAssets:Value(NumofMachLookup.Text),Stage1CompleteBy:First(AppComboBox.SelectedItems).Stage1CompleteBy,BusinessCritical:BCriticalLookup.Text,MsGuidance:MSTelemetryLookup.Text,MsAssessment:MSAssessmentLookup.Text,MsReady:MSAssessmentLookup_1.Text,Stage2Response:VCompLookup.Text,Stage2Comment:CompatCommentsLookup.Text,Stage3Result:TestingResultLookup.Text,Stage3CompleteBy:'TestedBy Lookup'.Text,Stage3Comment:TestingCommentLookup.Text,ReadinessStage:3})

View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: Patch Stopped working after going from 3.19091.18 to 3.19092.12

What does the patch command look like?  Are you using this with azure sql or on-premises through a gateway?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
ddarko2215
Level: Powered On

Re: Patch Stopped working after going from 3.19091.18 to 3.19092.12

Thanks for the reply! After spinning my wheels for a while, I went sleep, woke up and it all starting working. Scratching my head on it.   To answer your question it is a azure sql db.  When the problem was occuring my patch formulas that updated a row were working but the patch formulas that inserted a new row stopped. The troubleshooting steps I took; 1. Run an insert into command on the table with the same service account that the data connection is running. Result was successful. 2. Delete the data source from the power app and re-add: Didn't resolve the issue 3. Revert application back to previous power apps release: Worked! 4. Reverted back to new version: stopped working 5. Went to sleep: 6 Woke up: it started working again on new version:

 

Command
Patch('[dbo].[WR_AppReadinessEmail]',Defaults('[dbo].[WR_AppReadinessEmail]'),{EmailDate:Now(),AppInfoID:First(AppComboBox.SelectedItems).ID,AppName:AppNameLookup.Text, VendorEmail:TextInputVEmail.Text,EmailStage:2,FormsSubmitEmail:User().Email,AppIdentifier:IdentifierLookup.Text,NumberOfAssets:Value(NumofMachLookup.Text),Stage1CompleteBy:First(AppComboBox.SelectedItems).Stage1CompleteBy,BusinessCritical:BCriticalLookup.Text,MsGuidance:MSTelemetryLookup.Text,MsAssessment:MSAssessmentLookup.Text,MsReady:MSAssessmentLookup_1.Text,Stage2Response:VCompLookup.Text,Stage2Comment:CompatCommentsLookup.Text,Stage3Result:TestingResultLookup.Text,Stage3CompleteBy:'TestedBy Lookup'.Text,Stage3Comment:TestingCommentLookup.Text,ReadinessStage:3})

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,941)