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

Multiple actions in a formula to show distinct results

 

 

Hi, attempting to have results show for a dropdown and listbox controls based on the previous selection.

 

See powerapps screen -

powerapps2.PNG

 

I want  '2. Select Location' to only show results when a '1. Select Region' is selected, and subsequently, I want '3. Select Program' to show only based on the Location and Region as selected above.

 

The Data souce is an excel spreadsheet that's been imported, looks like this below -

 

table.PNG

 

Note that the results on the right are a list box (without borders) and aligned to look like a table. The idea behind that is once you select the activity from '5. Select Activity' the content on the right screen will also update (but I can do that once I know how to have multiple conditions in a formula)

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hi,

 

I think I have implemented something similar with your request.

In my case I had a scnerio of Branch, Area, Region - Area being filtered based on Region selected and Branch being filtered based on Area and Region selected.

 

So my first drop down "Region" has the following function: 

SortByColumns(Distinct(BranchAreaRegion, Region), "Result")

- which returns all the distinct values from the Region column from my list

 

The second one  "Area" has the following function:

 SortByColumns(Distinct(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result).Area, Area), "Result") 

- which is based on the selection from the "Region" drop down

 

And the final one "Branch" has the following function: 

SortByColumns(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result && Area = [@ddArea].Selected.Result), "Branch").BranchRef1

- which is based on both the previous selections

 

Hope this helps 🙂 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi,

 

I think I have implemented something similar with your request.

In my case I had a scnerio of Branch, Area, Region - Area being filtered based on Region selected and Branch being filtered based on Area and Region selected.

 

So my first drop down "Region" has the following function: 

SortByColumns(Distinct(BranchAreaRegion, Region), "Result")

- which returns all the distinct values from the Region column from my list

 

The second one  "Area" has the following function:

 SortByColumns(Distinct(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result).Area, Area), "Result") 

- which is based on the selection from the "Region" drop down

 

And the final one "Branch" has the following function: 

SortByColumns(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result && Area = [@ddArea].Selected.Result), "Branch").BranchRef1

- which is based on both the previous selections

 

Hope this helps 🙂 

View solution in original post

Thank you, perfect!

tianaranjo
Continued Contributor
Continued Contributor

Can you tell me where you enter the function?  Is it under Items?  

Anonymous
Not applicable

@tianaranjo yes under Items of each drop down.

tianaranjo
Continued Contributor
Continued Contributor

Thank your response.  

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,063)