Search function not finding specific excel column.

(0) Share

Report

Posted on by PonceletSeba

Dear Power Apps Community,

Ran into following issue whilst configuring a search function: "The specified column does not exist"

Search(
 Wisselstukken;
 txtStockManagementSearch.Text;"STOCK_Description"
 )

The column "STOCK_Description" exists, but was generated trought excel.
If I replace the column with one I added myselve there seems to not be any problem.

Is this a known issue with excel columns or am I missing something.

Edit: I suppose the issue lies within the column being excel generated. Maybe excel gives a different name to a sharepoint column than the actual displayed value.

Kind regards,

Sébastien

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

timl 36,740 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @PonceletSeba

Did you add the STOCK_Description column after you initially created your app? If so, have you tried refreshing the data source through the data panel?

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (0)

Report
Copy link

Link copied!

Hi @timl,
I've tried following fixes:
Removing the data and reading it,
Refreshing data,
Creating a placebo column with the "addcolumn" function, strangely enough within the addcolumn function the "STOCK_Description" column is found, but the result of the addcolumn function cannot be used in the search function for the same reason stated in the original post I suppose.

Thanks for your reply.

Was this reply helpful? Yes No
Verified answer

PonceletSeba 81 on at

Like (0)

Report
Copy link

Link copied!

Found the solution:

Instead of using the self-given name to the column: "STOCK_Description"
I used the internal column name. This can be found under the list settings -> clicking the column and looking in the search bar. The internal column name is found after the 'field=' section.

Was this reply helpful? Yes No