Showing results for 
Search instead for 
Did you mean: 
Not applicable

OnChange Search a datasource and navigate if it finds a match

The title really says all, what I am trying to do is scan an EAN using the barcode feature which updates a text input and will then search a datasource on another page. If there is a match it will navigate to the "Product_Review" page, else, it will display a static label saying no product was found.


New to powerapps, don't be too harsh 😉

Responsive Resident
Responsive Resident

So what’s the question? Tell us how we can help you, where are you stuck?
Not applicable

The entire post is the one question, how do I achieve what I have e listed above?
Community Support
Community Support

Hi @Anonymous,


Could you please share a bit more about your scenario?

Do you want to search a datasource based on the formula that you filled within the OnChange property of the TextInput control?

Further, could you please show a bit more about your PowerApps app's configuration?


If you want to search a datasource based on the formula that you filled within the OnChange property of the TextInput control, I afraid that it could achieve your needs. 


I have made a test on my side and my PowerApps app's configuration as below:11.JPG


I add two Label controls, a Barcode control, a TextInput control and a Button control within my Screen1.


The Text Property of Label1 control set to following formula:

"Search Text:"


The Text property of Label2 control set to following formula:

"No Product was found!"

The Visible property of Label2 control set to following formula:


Note: The NoRecord is a variable which initialized within OnSelect property of Button control.


The Default property of the TextInput1 control set to following formula:


The OnSelect property of the Button1 control set to following formula:


Note: The ProductLists represents the datasource (SharePoint list datasource on my side) in another page, "ProductName" represents a column in the datasource. 


The Screen2 (Another page) within my PowerApps app as below:12.JPG

 Add a EditFrom (Form1) within the Screen2, set DataSource, DefaultMode and Item property for the EditForm control as below:




Note: The SearchText variable is passed from Screen1.


Please take a try with above solution that I provided, then check is it could solve your problem.


Best regards,




Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,591)