cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

App broke in last 24 hours - Published version works but edit version doesn't?

I have an app that is processing attendance records and doing calculations. Sometime yesterday afternoon until this morning it stopped working for a specific instance where sign-out time is null. I have been troubleshooting it all morning and rolled back to yesterday's version and I can't get it to work. At the same time my published version from yesterday is working that is same version. I don't understand how the editable version and published version are working differently?

 

The problem seems to be the handling of null from SQL being processed. I have and AddColumns function and those rows that have a null Time from SQL are not getting values in some of the Columns of AddColumns statement. However the code is working fine in the published version.

 

I don't know how to proceed since I have this split issue? Just to verify I published it again just now and still the published version works but edit one doesn't

 

The info for the working published yesterday app is 

Session ID: efb3327f-4490-4a65-a71f-e734ba981f75
Power Apps 3.20022.13

 

The info for the working published today app is

Session ID: fe290f13-fa27-4671-9366-0d7728d8771e
Power Apps 3.20022.13

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: App broke in last 24 hours - Published version works but edit version doesn't?

Just a thought - try toggling the Advanced Setting - 'Formula-level error management'. 

I believe that influences how Nulls/Blanks/Empties are handled.

I found some bugs that appear to be related to this setting and as it is experimental, maybe it was recently modified?

View solution in original post

5 REPLIES 5
Post Patron
Post Patron

Re: App broke in last 24 hours - Published version works but edit version doesn't?

Well I re-published it again after making a small change (resized label) and now it no longer works in published version either. I even tried restoring back and it doesn't work. Now it is broken everywhere. In the monitor I can see what is happening:

{
  "time": "13:58:43.063",
  "category": "Network",
  "name": "patchRow",
  "data": {
    "dataOperation": {
      "protocol": "cdp",
      "operation": "patchRow",
      "apiId": "/providers/microsoft.powerapps/apis/shared_sql",
      "dataSource": "[dbo].[Daily Attendance History with Billing Notes]",
      "table": "[dbo].[Daily Attendance History with Billing Notes]"
    },
    "context": {
      "rule": "Build Billing History.OnSelect",
      "nodeId": 1427
    },
    "request": {
      "url": "https://msmanaged-na.azure-apim.net/invoke",
      "method": "POST",
      "headers": {
        "x-ms-protocol-semantics": "cdp",
        "x-ms-user-agent": "PowerApps/3.20022.19 (Web AuthoringTool; AppName=6c96d527-3da4-418a-817a-0b20f4d272b2)",
        "x-ms-client-session-id": "fff3d32a-b9c3-4873-a037-05f94b8077f6",
        "x-ms-client-request-id": "b7484777-7885-4a4f-a849-3bac7cf59aa7",
        "Accept-Language": "en-US",
        "Accept": "*/*",
        "Cache-Control": "no-cache, no-store",
        "Content-Type": "application/json",
        "x-ms-request-method": "PATCH",
        "x-ms-request-url": "/apim/sql/d3ad85579f3e44869b6ee6a0398fc0c9/datasets/default/tables/%255Bdbo%255D.%255BDaily%2520Attendance%2520History%2520with%2520Billing%2520Notes%255D/items/15861"
      },
      "body": {
        "ActivityCancel": null,
        "ActivityOneSigninTime": "3:42 PM",
        "ActivityTwo": null,
        "After6Charge": {
          "kind": 12,
          "severity": 1,
          "dataSourceName": null
        },
        "After6NoCharge": null,
        "AfterBusLoad": null,
        "AfterBusRoute": null,
        "BusMornLoad": null,
        "CarPickup": null,
        "EndTime": "5:00 PM",
        "LastRun": "2020-02-26T21:58:42.787Z",
        "MornBusRoute": null,
        "MorningActivity": null,
        "MorningSlot": null,
        "MSDismissLoc": null,
        "RegAthletics": null,
        "SlotThree": null,
        "Verified": null,
        "Volunteer": null,
        "Walker": null
      }
    },
    "response": {
      "duration": 262.7,
      "size": 258,
      "status": 400,
      "headers": {
        "Cache-Control": "no-cache,no-store",
        "Content-Length": 258,
        "Content-Type": "application/json",
        "Date": "Wed, 26 Feb 2020 21:58:42 GMT",
        "expires": -1,
        "pragma": "no-cache",
        "strict-transport-security": "max-age=31536000; includeSubDomains",
        "timing-allow-origin": "*",
        "x-content-type-options": "nosniff",
        "x-frame-options": "DENY",
        "x-ms-apihub-cached-response": true,
        "x-ms-request-id": "b7484777-7885-4a4f-a849-3bac7cf59aa7",
        "x-ms-user-agent": "PowerApps/3.20022.19 (Web AuthoringTool; AppName=6c96d527-3da4-418a-817a-0b20f4d272b2)",
        "x-ms-client-request-id": "b7484777-7885-4a4f-a849-3bac7cf59aa7"
      },
      "body": {
        "status": 400,
        "message": "A value must be provided for item.\r\nclientRequestId: b7484777-7885-4a4f-a849-3bac7cf59aa7",
        "error": {
          "message": "A value must be provided for item."
        },
        "source": "sql-wus.azconn-wus.p.azurewebsites.net"
      }
    }
  },
  "duration": 262.7,
  "status": 400,
  "responseSize": 258,
  "operation": "patchRow",
  "formula": "Build Billing History.OnSelect",
  "nodeId": 1427,
  "dataSource": "[dbo].[Daily Attendance History with Billing Notes]",
  "id": 928
}

 

The example is this:

        "After6Charge": {
          "kind": 12,
          "severity": 1,
          "dataSourceName": null
        },

My code should be returning 0 but is instead returning something that is neither null or a value it is like the absence of a value?

 

I just can't figure out what changed from yesterday to today?

Highlighted
Super User
Super User

Re: App broke in last 24 hours - Published version works but edit version doesn't?

Just a thought - try toggling the Advanced Setting - 'Formula-level error management'. 

I believe that influences how Nulls/Blanks/Empties are handled.

I found some bugs that appear to be related to this setting and as it is experimental, maybe it was recently modified?

View solution in original post

Highlighted
Post Patron
Post Patron

Re: App broke in last 24 hours - Published version works but edit version doesn't?

THANKS SO MUCH! That was it. It appears there was some change / regression from 3.20021.29 to 3.20022.19 related to the Experimental feature Formula-level error management. Now my concern is I think the ability to Patch Blank() into SQL and get a null is related to this feature. If I disable it do I lose that as well?

 

Also this is connected to https://powerusers.microsoft.com/t5/Building-Power-Apps/Converting-null-Time-from-SQL-results-in-not... as those functions now work properly.

Highlighted
Super User
Super User

Re: App broke in last 24 hours - Published version works but edit version doesn't?

@BrianHFASPS - my understanding is that if you want to patch over nulls in SQL you need to have the 'Formula-level error management' option enabled.

I have taken to turning that option on by default as I have been caught out by the SQL null patching issue on many occasions (as an aside, I believe patching over nulls in local collections is still an issue, but this option doesn't help with that case).

Highlighted
Post Patron
Post Patron

Re: App broke in last 24 hours - Published version works but edit version doesn't?

I need the null patching as well for SQL. However I am stuck now with this feature breaking my code in other ways. Waiting for support to get back to me.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,219)