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:

General Questions

All responses (3)

Answers (0)

hpkeong 2,944 on at

Like (0)

Report

Re: Show table form details based on filter distinct

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.
aminb19 17 on at

Like (0)

Report

Re: Show table form details based on filter distinct

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.
hpkeong 2,944 on at

Like (0)

Report

Re: Show table form details based on filter distinct

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.