Internal Server Error Sorting On 'Selected' Ticks Value ( Logic Apps & Power Automate )

[eliot-cole]

Describe the Bug

When using a 'selected' tick value (ie. sort(body('dataArrCNST'), 'ticksVal')) to sort by both Logic Apps and Power Automate fail their run.

Both systems (on multiple tenancies) report the same non-descriptive error:

Encountered internal server error. The tracking Id is '231e801a-e26b-4923-8ffe-cd357ab1bdb3'.

This is likely to be causing PROD issues with integrations that I have built in the past as I typically will sort by ticks rather than a date string.

Plan Type

Consumption

Steps to Reproduce the Bug or Issue

1. Create a 'Parse JSON' action (or Select) action named 'dataArrCNST'
2. Ensure it has an array value with ticks values populating the 'ChangedTicks' key value
3. Sort data in following action using selector (in example that would be: sort(body('dataArrCNST'), 'ChangedTicks'))

Example Data For Ease Of Reproduction

[
  {
    "ChangedTicks": 638756454980794500,
    "changedTime": "2025-02-20T10:51:38.0794554Z",
    "createdTime": "2021-09-29T13:58:43.044436Z",
    "CreatedTicks": 637685207230444400
  },
  {
    "ChangedTicks": 638756462072286600,
    "changedTime": "2025-02-20T11:03:27.22866Z",
    "createdTime": "2021-11-03T17:11:18.1129023Z",
    "CreatedTicks": 637715562781129000
  },
  {
    "ChangedTicks": 639083265164915200,
    "changedTime": "2026-03-05T16:55:16.4915257Z",
    "createdTime": "2021-09-01T09:23:11.3478694Z",
    "CreatedTicks": 637660849913478700
  },
  {
    "ChangedTicks": 637661699320491500,
    "changedTime": "2021-09-02T08:58:52.0491572Z",
    "createdTime": "2021-09-02T08:48:51.1234913Z",
    "CreatedTicks": 637661693311235000
  },
  {
    "ChangedTicks": 637660876524874100,
    "changedTime": "2021-09-01T10:07:32.487415Z",
    "createdTime": "2021-09-01T09:57:31.6198511Z",
    "CreatedTicks": 637660870516198500
  },
  {
    "ChangedTicks": 637716337782588800,
    "changedTime": "2021-11-04T14:42:58.2588776Z",
    "createdTime": "2021-11-04T14:32:57.7119061Z",
    "CreatedTicks": 637716331777119100
  },
  {
    "ChangedTicks": 637685218760869500,
    "changedTime": "2021-09-29T14:17:56.0869451Z",
    "createdTime": "2021-09-29T14:07:54.5391901Z",
    "CreatedTicks": 637685212745391900
  },
  {
    "ChangedTicks": 637685214808049500,
    "changedTime": "2021-09-29T14:11:20.8049535Z",
    "createdTime": "2021-09-29T14:01:19.744089Z",
    "CreatedTicks": 637685208797440900
  },
  {
    "ChangedTicks": 637716335649649900,
    "changedTime": "2021-11-04T14:39:24.9649937Z",
    "createdTime": "2021-11-04T14:28:47.9133383Z",
    "CreatedTicks": 637716329279133400
  },
  {
    "ChangedTicks": 637709481917646100,
    "changedTime": "2021-10-27T16:16:31.7646115Z",
    "createdTime": "2021-10-27T16:06:30.4685822Z",
    "CreatedTicks": 637709475904685800
  },
  {
    "ChangedTicks": 637685218031281700,
    "changedTime": "2021-09-29T14:16:43.1281624Z",
    "createdTime": "2021-09-29T14:06:41.542923Z",
    "CreatedTicks": 637685212015429200
  },
  {
    "ChangedTicks": 637807907825273500,
    "changedTime": "2022-02-18T14:19:42.5273436Z",
    "createdTime": "2022-02-18T14:09:41.1836917Z",
    "CreatedTicks": 637807901811836900
  },
  {
    "ChangedTicks": 637709476465693400,
    "changedTime": "2021-10-27T16:07:26.5693443Z",
    "createdTime": "2021-10-27T16:07:26.5622544Z",
    "CreatedTicks": 637709476465622500
  },
  {
    "ChangedTicks": 637808020953697700,
    "changedTime": "2022-02-18T17:28:15.369769Z",
    "createdTime": "2022-02-18T17:18:14.6911944Z",
    "CreatedTicks": 637808014946912000
  },
  {
    "ChangedTicks": 637891722039868900,
    "changedTime": "2022-05-26T14:30:03.9868922Z",
    "createdTime": "2022-05-26T14:18:02.1342807Z",
    "CreatedTicks": 637891714821342800
  },
  {
    "ChangedTicks": 637891724102324700,
    "changedTime": "2022-05-26T14:33:30.2324786Z",
    "createdTime": "2022-05-26T14:23:29.3542522Z",
    "CreatedTicks": 637891718093542500
  },
  {
    "ChangedTicks": 637891720993519000,
    "changedTime": "2022-05-26T14:28:19.3518947Z",
    "createdTime": "2022-05-26T14:18:18.8709676Z",
    "CreatedTicks": 637891714988709600
  },
  {
    "ChangedTicks": 637914106072416500,
    "changedTime": "2022-06-21T12:16:47.2416452Z",
    "createdTime": "2022-06-21T12:06:46.6657166Z",
    "CreatedTicks": 637914100066657200
  },
  {
    "ChangedTicks": 638786810855281400,
    "changedTime": "2025-03-27T14:04:45.5281375Z",
    "createdTime": "2022-01-28T15:48:05.6866403Z",
    "CreatedTicks": 637789816856866400
  },
  {
    "ChangedTicks": 637934057849608800,
    "changedTime": "2022-07-14T14:29:44.9608856Z",
    "createdTime": "2022-07-14T14:19:44.2018067Z",
    "CreatedTicks": 637934051842018000
  },
  {
    "ChangedTicks": 637891725193298600,
    "changedTime": "2022-05-26T14:35:19.3298518Z",
    "createdTime": "2022-05-26T14:23:14.7761547Z",
    "CreatedTicks": 637891717947761500
  },
  {
    "ChangedTicks": 638568340567237800,
    "changedTime": "2024-07-17T17:27:36.7237777Z",
    "createdTime": "2022-02-04T11:32:13.7068261Z",
    "CreatedTicks": 637795711337068300
  },
  {
    "ChangedTicks": 638568342340660500,
    "changedTime": "2024-07-17T17:30:34.066044Z",
    "createdTime": "2022-02-18T17:07:06.6005604Z",
    "CreatedTicks": 637808008266005600
  },
  {
    "ChangedTicks": 638798357012245800,
    "changedTime": "2025-04-09T22:48:21.2245705Z",
    "createdTime": "2021-09-01T09:54:14.5304403Z",
    "CreatedTicks": 637660868545304400
  },
  {
    "ChangedTicks": 638557753824539800,
    "changedTime": "2024-07-05T11:23:02.4539729Z",
    "createdTime": "2024-07-05T11:13:02.2490213Z",
    "CreatedTicks": 638557747822490200
  },
  {
    "ChangedTicks": 638557735746902400,
    "changedTime": "2024-07-05T10:52:54.6902368Z",
    "createdTime": "2024-07-05T10:42:54.6071673Z",
    "CreatedTicks": 638557729746071700
  },
  {
    "ChangedTicks": 638847331659040800,
    "changedTime": "2025-06-05T15:12:45.9040738Z",
    "createdTime": "2024-07-05T11:21:24.0509856Z",
    "CreatedTicks": 638557752840509800
  },
  {
    "ChangedTicks": 638557897006421000,
    "changedTime": "2024-07-05T15:21:40.6420986Z",
    "createdTime": "2024-07-05T15:11:39.6720988Z",
    "CreatedTicks": 638557890996721000
  },
  {
    "ChangedTicks": 638708973700816800,
    "changedTime": "2024-12-27T11:56:10.0816753Z",
    "createdTime": "2024-07-15T00:25:42.6706645Z",
    "CreatedTicks": 638565999426706700
  },
  {
    "ChangedTicks": 638683888927950100,
    "changedTime": "2024-11-28T11:08:12.7950085Z",
    "createdTime": "2024-10-02T09:34:19.8670284Z",
    "CreatedTicks": 638634584598670300
  },
  {
    "ChangedTicks": 638743469465533000,
    "changedTime": "2025-02-05T10:09:06.5533067Z",
    "createdTime": "2024-10-02T09:44:32.3274487Z",
    "CreatedTicks": 638634590723274500
  },
  {
    "ChangedTicks": 638714350769501800,
    "changedTime": "2025-01-02T17:17:56.9501822Z",
    "createdTime": "2025-01-02T17:07:56.8156516Z",
    "CreatedTicks": 638714344768156500
  },
  {
    "ChangedTicks": 639083238950990100,
    "changedTime": "2026-03-05T16:11:35.0990077Z",
    "createdTime": "2025-04-03T12:56:46.7774802Z",
    "CreatedTicks": 638792818067774800
  },
  {
    "ChangedTicks": 638798161150545300,
    "changedTime": "2025-04-09T17:21:55.0545291Z",
    "createdTime": "2025-04-09T17:11:54.1077148Z",
    "CreatedTicks": 638798155141077100
  },
  {
    "ChangedTicks": 638798179306734300,
    "changedTime": "2025-04-09T17:52:10.6734358Z",
    "createdTime": "2025-04-09T17:42:10.4804277Z",
    "CreatedTicks": 638798173304804200
  },
  {
    "ChangedTicks": 638798348870682200,
    "changedTime": "2025-04-09T22:34:47.0682252Z",
    "createdTime": "2025-04-09T22:24:46.0330863Z",
    "CreatedTicks": 638798342860330900
  },
  {
    "ChangedTicks": 638798355460163600,
    "changedTime": "2025-04-09T22:45:46.0163565Z",
    "createdTime": "2025-04-09T22:35:45.5017993Z",
    "CreatedTicks": 638798349455018000
  },
  {
    "ChangedTicks": 638823017602640000,
    "changedTime": "2025-05-08T11:49:20.263994Z",
    "createdTime": "2025-05-08T11:39:19.9153394Z",
    "CreatedTicks": 638823011599153400
  },
  {
    "ChangedTicks": 638833617163219100,
    "changedTime": "2025-05-20T18:15:16.3219074Z",
    "createdTime": "2025-05-20T18:05:16.1686499Z",
    "CreatedTicks": 638833611161686500
  },
  {
    "ChangedTicks": 638878575077136000,
    "changedTime": "2025-07-11T19:05:07.7135937Z",
    "createdTime": "2025-07-11T18:55:07.5429782Z",
    "CreatedTicks": 638878569075429800
  },
  {
    "ChangedTicks": 638908938711984300,
    "changedTime": "2025-08-15T22:31:11.1984199Z",
    "createdTime": "2025-08-15T22:21:10.2844897Z",
    "CreatedTicks": 638908932702844900
  },
  {
    "ChangedTicks": 638938811152509200,
    "changedTime": "2025-09-19T12:18:35.250918Z",
    "createdTime": "2025-09-19T12:08:34.4784989Z",
    "CreatedTicks": 638938805144785000
  },
  {
    "ChangedTicks": 639092771177738100,
    "changedTime": "2026-03-16T16:58:37.7738056Z",
    "createdTime": "2026-03-05T16:19:47.7090959Z",
    "CreatedTicks": 639083243877091000
  },
  {
    "ChangedTicks": 639088657229397600,
    "changedTime": "2026-03-11T22:42:02.9397631Z",
    "createdTime": "2026-03-11T22:32:02.6769735Z",
    "CreatedTicks": 639088651226769800
  },
  {
    "ChangedTicks": 639088663131067500,
    "changedTime": "2026-03-11T22:51:53.1067496Z",
    "createdTime": "2026-03-11T22:41:52.959975Z",
    "CreatedTicks": 639088657129599700
  }
]

Screenshots or Videos

Additional context

Tracking IDs if helpful

• LA:
  • b82334f2-5930-46e9-9952-c56188e65693
  • 011e1043-9466-40e8-8b1e-9d4b91e84dc6
  • 9e5437d8-443a-4d02-a85d-c028ba9f83ef
• PAuto:
  • 231e801a-e26b-4923-8ffe-cd357ab1bdb3
  • b139f359-24f9-482e-ad27-0c19b9bd971f
  • d47f0e7d-f7f5-4abd-9345-09672f7b59fc

Also, I had a memory that someone else had recent issues with ticks() and I've found where I interacted with them about it on my work account:
#1422
Could these both be related?