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?
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.
@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.
Reference: Filter, Search, and LookUp functions in Power Apps
Additional Information: Filter 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.
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)'.
User | Count |
---|---|
174 | |
112 | |
86 | |
44 | |
41 |
User | Count |
---|---|
238 | |
150 | |
132 | |
77 | |
73 |