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
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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,441)