cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aminb19
Advocate II
Advocate II

Show table form details based on filter distinct

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

3 REPLIES 3
hpkeong
Community Champion
Community Champion

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.

 

hpkeong

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
Community Champion
Community Champion

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 appsScreenshot from actual created sample apps

 

Have a nice day and hope you like it.

hpkeong

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,768)