Unanswered

Show table form details based on filter distinct

(0) Share

Report

Posted on by aminb19

I'm seeking to use PowerApps to filter specific columns from a Table and display specific details based on my selection.

This is the source table imported as the Data Source -

Table used for filtering

And this is the current output I have on PowerApps -

PowerApps view

So what I've achieved so far is filtering results from steps 1 to 4 where based on the 'region' and 'location' and 'program' and 'gender; does the two activities appear.

What I'm after is the ability to select 'Graffiti removal' OR 'environmental cleanup' from step 5, and the form on the right of the screen to show the details from the Activivity, Days...Koori only columns. Can you please assist with the formula required to enable this, with direction on where to enter the said fx.

Thanks in advance,

Amin

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

hpkeong 2,944 on at

Like (0)

Report
Copy link

Link copied!

Hi

Say your DS is name TableDS.
On the right hand side pane, would you replace with a GALLERY, with
- Gallery.items = Filter(TableDS, Region = DropdownRegion.Selected.Value, Location = Dropdpwown....., Program = Dropdown....., Gender = Dropdown....)
- For each TextBox (or called Label now), bind them to:
Thisitem.Regioan,
ThisItem.Location,
,....

Please have a try.

Note:
If you insist to use card, you need to do it such a way:
Region
- Label.Texty = DropdownRegion.Selected.Value,
- ...so on and so forth.

Was this reply helpful? Yes No
aminb19 17 on at

Like (0)

Report
Copy link

Link copied!

Hi thanks for your reply, but sadly I couldn't get it working off your guidance.

Can you please provide some more information, especially on what type to insert (form or gallery) and a bit more details on the formula to use.

Really appreciate your assistance, and thanks in advance.
Amin.

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like (0)

Report
Copy link

Link copied!

Hi @aminb19

Sorry for not be able to describe clearly for you.
Please look at below screenshot with all the formula next to them and you can copy and modify to your needs.

Screenshot from actual created sample apps

Have a nice day and hope you like it.

Was this reply helpful? Yes No