cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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 😉

3 REPLIES 3
bdodu
Responsive Resident
Responsive Resident

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

The entire post is the one question, how do I achieve what I have e listed above?
v-xida-msft
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:

NoRecord

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:

Barcode1.Text

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

If(IsEmpty(Search(ProductLists,TextInput1.Text,"ProductName")),UpdateContext({NoRecord:true}),Navigate(Screen2,ScreenTransition.Fade,{SearchText:TextInput1.Text}))

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:

Form1.DataSource=ProductLists

Form1.DefaultMode=FormMode.Edit

Form1.Item=First(Filter(ProductLists,ProductName=SearchText))

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,

Kris

 

 

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

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,867)