I want to build an app for choosing the correct item based on several filter/conditions/steps.
I have the conditions in excel/sharepoint list.
What I did before was filtering in Excel each column step by step and getting the final result.
What I want to achieve is to be able to choose all the steps in app - something like a walk through all the filters step by step.
I previously did something like this using comboboxes but have a feeling that it was a big workaround and I should use galleries for that.
I attach how my source table looks like.
As you can see there need to be some grouping that I have problem with.
Can you give me some hints and point into right direction?
Solved! Go to Solution.
Hi @Mariollo
Would this sort of concept suit your use case? - i.e. single click to select with each selection filtering the next set of options in a cascading fashion?
If so please see attached
Hi @Mariollo
Would this sort of concept suit your use case? - i.e. single click to select with each selection filtering the next set of options in a cascading fashion?
If so please see attached
Yes, exactly something like this. I will play with it now and rework for my needs.
Thank you!
Great stuff - Have fun 🙂
@AmDev One more thing - what if I'd like one more gallery where will the result of selections will be presented?
Columns Result 1, Result 2 and Result 3from my screen.
And what if Option 2 is not available for some selections?
@Mariollo - for the blank fields scenario, you could add this to the visible property of the third gallery:
varOp1 <> Blank() && !IsBlank(First(Self.AllItems).'Option 2')
With regards showing the results - Do you want to show the values from the row in a Gallery?
I.e. for the above row you want to display your results gallery like this
Results
Result 1 B-1-3-2
Result 2 B-1-3-2
Result 3 B-1-3-2
If so please see attached with some changes with new gallery and changes to the items and visibile properties of the 3rd Gallery
Thank you @AmDev , this very helpful and appreciated! Learned a lot thanks to this
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
197 | |
71 | |
48 | |
42 | |
30 |
User | Count |
---|---|
263 | |
121 | |
92 | |
87 | |
85 |