How to build "Step by step Guide" App?

(0) Share

Report

Posted on by Mariollo

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.

Screenshot 2022-01-26 115244.png

Can you give me some hints and point into right direction?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

Gerard Simpson 2,987 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

CascadeFilterTest...
ExcelCascadeTest....
Mariollo 96 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, exactly something like this. I will play with it now and rework for my needs.
Thank you!
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Great stuff - Have fun 🙂
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

CascadeFilterTest...
Gerard Simpson 2,987 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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

CascadeFilterTest...
ExcelCascadeTest1...
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @AmDev , this very helpful and appreciated! Learned a lot thanks to this