Power Platform Community Forum Thread Details

I am performing a ClearCollect on an On Premise SQL Server. There is a search field for a user to look up an account number. The OnSelect of the of the search button looks up the SaleID of the Account Number and then performs a ClearCollect to grab records that match the saleID variable set by the lookup.

ClearCollect(SalesCollection,Filter('[dbo].[tblSaleRecords]',SaleID = fkSaleID ));

When I tried to view the collection in either the PowerApps windows app or the broswer authoring app, I get the following error:

WebAuthoring abnormal termination.
Client date/time: 2017-10-02T16:16:49.092Z
Version: 2.0.707 (v2.0.707.54503216)
Session ID: c65fa953-b9a9-fbff-8cd0-81349fcf62e8
description: {"error":{"isTrusted":true,"detail":{"exception":{}},"message":"Uncaught Error: Exception message: 'Unsupported data type.'\nException call stack:\nError\n at _sourceFromStacktrace (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:857:21)\n at _except (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:870:25)\n at Object.check (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:631:18)\n at Function.ObjectViewerTypeConverter.valueToString (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:37101:54)\n at ObjectViewerData.getCellValue (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36796:79)\n at ObjectViewerData.measureColumn (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36865:66)\n at ObjectViewerViewModel.initializeSizes (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18326:62)\n at ObjectViewerView._initializeWidthsAndHeights (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18108:45)\n at ObjectViewerView.<anonymous> (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18087:90)","filename":"https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216","lineno":871,"colno":9,"error":{},"NONE":0,"CAPTURING_PHASE":1,"AT_TARGET":2,"BUBBLING_PHASE":3,"type":"error","target":"[window]","currentTarget":"[window]","eventPhase":2,"bubbles":false,"cancelable":true,"defaultPrevented":false,"composed":false,"timeStamp":31003.305,"srcElement":"[window]","returnValue":true,"cancelBubble":false,"path":["[window]"],"composedPath":"[function]","stopPropagation":"[function]","stopImmediatePropagation":"[function]","preventDefault":"[function]","initEvent":"[function]"},"errorLine":871,"errorCharacter":9,"errorUrl":"https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216","errorMessage":"Uncaught Error: Exception message: 'Unsupported data type.'\nException call stack:\nError\n at _sourceFromStacktrace (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:857:21)\n at _except (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:870:25)\n at Object.check (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:631:18)\n at Function.ObjectViewerTypeConverter.valueToString (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:37101:54)\n at ObjectViewerData.getCellValue (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36796:79)\n at ObjectViewerData.measureColumn (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36865:66)\n at ObjectViewerViewModel.initializeSizes (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18326:62)\n at ObjectViewerView._initializeWidthsAndHeights (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18108:45)\n at ObjectViewerView.<anonymous> (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18087:90)","setPromise":"[function]","exception":{}}
stack: null
errorNumber: 0
errorMessage: Uncaught Error: Exception message: 'Unsupported data type.'
Exception call stack:
Error
 at _sourceFromStacktrace (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:857:21)
 at _except (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:870:25)
 at Object.check (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/Core.js?v=2.0.707.54503216:631:18)
 at Function.ObjectViewerTypeConverter.valueToString (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:37101:54)
 at ObjectViewerData.getCellValue (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36796:79)
 at ObjectViewerData.measureColumn (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:36865:66)
 at ObjectViewerViewModel.initializeSizes (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18326:62)
 at ObjectViewerView._initializeWidthsAndHeights (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18108:45)
 at ObjectViewerView.<anonymous> (https://cdn-paaprodwus.azureedge.net/v2.0.707.54503216/studio/js/AppMagic.Authoring.js?v=2.0.707.54503216:18087:90)

The data types of the table in the filter function are:

Int
varchar(200)
varbinary(max)
datetime
varchar(max)

Categories:

Building Power Apps

Hi jonathanO,

I am not sure with the fkSaleID. What’s the data type of it? Is it in a different table with SaleID?

I test with two functions on my side, they are both working properly.

The first one, add a data source to one SQL table, then add a button and set its OnSelect property likes below. I can get the row for the specific id.
ClearCollect(test,Filter('[dbo].[a2]',id=50))

The second one, add another table as the data source, then add a button and set its OnSelect property as following. This function returns the items with the same id in two tables.
ClearCollect(test1,Filter('[dbo].[a2]',id in '[dbo].[Table_1]'.ID))

Please share more details to help reproduce this issue on my side. Hope what I did could be a reference for you.

Best regards,
Mabel Mao