I don't know if anyone can help me or direct me a site that can help me do this, I would appreciate both.
I am trying to make an app for my company to filter our plant selection. I made a mock up of the basic function I am supposed to shoot for and attached it. Basically I want three or four pages where I can filter or narrow down the our inventory until we get to the last page where it gives the result of those filters. Basically we want it to do what we can from an excell sheet in app form.
It would be nice if the last page was pictures with plant info next to it.
I can input the basic data into the powerapp but I don't know how to filter each page and have those results carry over to the next page until you get to the last result page.
If anyone has any ideas where I can look I would appreciate it.
By the way I will also attach some of the data i need to use from the excel sheet.
Hey @esbomba, sounds like a great app idea!
You could probably make good use of the Set function, which stores a global variable which can be used from any screen in the app, and then have the gallery of plants filtered by the various things stored in these global variables. It is pretty easy to use Set as it takes two items, the name you want to give what you are storing and the information you want to store. So if the label that showed the max height the user selected in your first screen was called MaxHeightLabel, the function might look like this:
Note the Value wrapped around the MaxHeightLabel.Text; it makes text into numbers. You would simply put each of these Set functions for the respective screen in the OnSelect field of the checkmark icon on that screen.
Then, to filter the final screen (or to filter the screens as you progress in selecting traits), you would include each of those global variables in a Filter function that is placed in the Items section of the gallery showing the plants. So, if your Excel table with the plant information was titled PlantTable, you would put something like this in the Items field of the said gallery:
Filter( PlantTable, 'HM Height Max' <= MaxHeightInput, 'WM Width Max' <= MaxWidthInput, ... )
The "..." represents the other filter statements you may put in.
How the filters are written depends a lot on how your data source is structured but from looking at your example data you seem to have it pretty well figured out and may just need to try a couple things to find the right filters to get where you need to be.
Now, for the pictures, I don't know too much of how you do that within Excel, but I am sure there is a way to do it. I don't know if you can store them in the Excel document or if you would need to use storage like OneDrive to store and reference them from. Hopefully, someone with more knowledge on that will chime in with some help! I did find this thread which sounds like a separate storage is needed.
As far as places to look for information and help, this site is a really great one. There are lots of people willing to share what they know to help others out and the forum team is great in that regard as well. Searching YouTube for PowerApps videos can also be very helpful.
Hopefully, that helps a little bit! If I can explain anything about what I put here or you need help with any specific parts, I will be glad to check in on this topic as I am able.
Have you solved your problem?
Do you want to filter your plant selection through three or forth pages, and then display the filtered result within the last page using Gallery control?
You could consider take a try to save your Excel table data source as a Collection when your app is started up, and then filter this Collection based on filter conditions within each page (except the last page), finally, within the last page, display the filtered result/collection within Gallery control.
I have made a test on my side, please take a try with the following workaround:
Set the OnVisible property or OnStart property of the first screen of your app to following formula:
Within the First screen (page), set the OnSelect property of the "Navigate" button to following formula:
"HM Height Max"<=HeightMax.Text,
"WM Width Max"<=WidthMax.Text
Within the Second screen (page), set the OnSelect property of the "Navigate" button to following formula:
Within the Last Screen (page), add a Gallery control, set the Items property of the Gallery control to following:
More details about the ClearCollect function in PowerApps, please check the following article:
I have been working through the solution wyotim provided. I am a beginner with powerapps so I have been having to review a lot of what was suggested.
I will try your solution as well.
I am hoping to spend this weekend working on it, so by chance I might be able to leave an update on how these suggestions worked out.
I am really grateful for your suggestions. I am trully amazed at how helpful people are on these forums.
I am sorry to bother you, I tried following your instructions this weekend but I could not get it to work. I know it is error on my part but I don't know what I am doing wrong. I made a video of my self doing it. I did the whole process just so you could see.
I tried to solve myself because I don't want to take advantage of your generosity.
I feel like I am going insane, because I am doing the same thing over and over hoping for something different to happen.
If you could give any pointers I would be really grateful.
Here is the video link on youtube:
Based on the vedio that you provided, I think there is something wrong with the formula within the OnSelect property of the "Navigate" button.
The "HM Height Max" and "WM Width Max" represent the columns within your PlantCollection as below:
On your side, you should replace the "HM Height Max" and "WM Width Max" with corresponding column name in your PlantCollection .
If you want to display the filtered result within the Gallery control, please set the Items property to following:
More details about the Gallery control, please check the following article: