cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aminb19
Level: Powered On

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
Level 10

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.

 

hpkeong
aminb19
Level: Powered On

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
Level 10

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 (138).pngScreenshot from actual created sample apps

 

Have a nice day and hope you like it.

hpkeong

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,836)