Powerapp : Search function not working on Online excel data source.

Question

Hi, i am using Online excel is external data source(One drive). i have created the gallery and its works perfectly.
Now i tried to create the search function through "Textinput1_search" and gave the formula at gallery Items " Seach(Table1,textinput1_search.text,"Engineer name") ". but when i run it, it will not show anything.
and also it throw error as mentioned below. Could you please help to solve this issue.

Hi, i am using Online excel(Table name: Table1) is external data source. i have created the gallery and its works perfectly.

Now i tried to create the search function through Textinput function(named as "Textinput1_search") and gave the formula at gallery Items Seach(Table1,textinput1_search.text,"Engineer name") . but when i run it, it will not show anything and also it throws error as mentioned below. Could someone help to solve this issue.

Error is :

The requested operation is invalid.Server Response:Table1 failed: Syntax error:Character '&' is not valid at position 10 in 'contains(Engineer name,'s').inner exception:syntax error:Character '&' is not valid at position 10 in 'contains(Engineer name,'s')'.

Answer 1

Power apps is not currently supported here on Q&A. The product group for Power apps actively monitors questions over at
https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

--please don't forget to upvote and Accept as answer if the reply is helpful--