Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

How to display result based on a condition

I have a task to list down all the alternative materials based on the user input. Alternative materials depends on the temperature. For example, when user input is 60, then the alternative materials should display the materials that is higher than 60. All information obtained from excel document.

Is there any way on how to code this?

Super User III
Super User III

The information you have provided is not detailed enough. But assuming you have 2 input fields, InputB and InputA.


When you input 60 in InputA field, use the following formula on the fill property as a validation;

If(Value(InputA.Text)< Value(InputB.Text), Red,white)


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Super User
Super User

@Batrisyia_ As per my understanding you want to filter the excel data based on user input. let's say you are storing the user input in varUserInput variable. Then you can filter your data using below formula:


Filter(ExcelDataSource, Temperature > varUserInput)


Assuming you have Temperature field in your excel data source. Then you can pass this filtered data to your control where you are showing alternative materials.

ReferenceFilter, Search, and LookUp functions in Power Apps 

Additional InformationFilter on Excel Datasource (NonStatic) that has >500 records 

Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍



Based on first picture, when user choose 60 in 'max operating temperature, the alternative materials should display the material for 70,90,100,120 and 200 (in order). The third picture is the data.


Batrisyia__0-1604382597207.png     Batrisyia__1-1604382711838.png 






I see that materials field is a Textbox. You wan to display all the material for 70,90,100,120 and 200 if the user selects a 60 in the same Textbox?


I suggest materials field should be a dropdown not a Textbox unless am misunderstood your request. 


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.


the alternative materials field is a list box. So, when user choose 60 in 'max operating temperature (dropdown)', it will display the material for 60 in 'suitable material (listbox1)' and at the same time the materials for the other temperature will display in 'alternative material (listbox2)'. 

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,544)