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 -
And this is the current output I have on PowerApps -
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,
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:
Please have a try.
If you insist to use card, you need to do it such a way:
- Label.Texty = DropdownRegion.Selected.Value,
- ...so on and so forth.
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.
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.
Have a nice day and hope you like it.
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!