Power Platform Community Forum Thread Details

In PowerApps , I'm connected to a view in my SQL Server. There's a column "SEARCH_STRING" that I want to use in a filter.

I know the column is part of the Data Source's metadata, because I used that Source for a DataTable and the column is in the DataTable.

My filter is: Filter('POWER_APP.FREIGHT_FILE_INVOICE_SHIPMENT', TextInvoiceNumberSearch.Text in SEARCH_STRING)

Using Monitor, I see this situation:

 "request": {
 "url": "https://sqlstuff/tables/%255BPOWER_APP%255D.%255BFREIGHT_FILE_INVOICE_SHIPMENT%255D/items?%24filter=contains%28SEARCH_STRING%2C%2744%27%29&%24select=SEARCH_STRING%2CINVOICE_NUMBER%2CCORRECTION_INDICATOR%2CSCAC%2CINVOICE_DATE%2CINVOICE_AMOUNT_DOLLARS%2CTOTAL_WEIGHT%2CTOTAL_QUANTITY%2CACTUAL_PICKUP_DATE%2CINVOICE_STATUS%2CGL_STATUS%2CAUDIT_STATUS%2CPO_NUMBER%2CBOL_NUMBER%2CEQUIPMENT_NUMBER%2CORIGIN_LOCATION_NAME%2CORIGIN_ADDRESS%2CORIGIN_CITY%2CORIGIN_STATE%2CORIGIN_POSTAL%2CDESTINATION_LOCATION_NAME%2CDESTINATION_ADDRESS%2CDESTINATION_CITY%2CDESTINATION_STATE%2CDESTINATION_POSTAL%2CDESTINATION_COUNTRY%2CORIGIN_COUNTRY%2CFREIGHT_INVOICE_ID%2CFREIGHT_SHIPMENT_ID&%24top=100",

You can see right at the start, it knows SEARCH_STRING is there.

However, this is the error:

"body": {
 "status": 400,
 "message": "The column 'SEARCH_STRING' of the table wasn't found.\r\n inner exception: The column 'SEARCH_STRING' of the table wasn't found.\r\nclientRequestId: e59bc74f-4b76-460d-99ed-313dde26826c",
 "error": {
 "message": "The column 'SEARCH_STRING' of the table wasn't found.\r\n inner exception: The column 'SEARCH_STRING' of the table wasn't found."
 },

I've refreshed the Data Source, I saved the app, closed it. Cleared my Cache. Repeat and Repeat

But I don't know what's wrong.

Categories:

Building Power Apps