Need Help with Dependent Drop Down on Power Apps

Like (0) Share

Report

Posted on 25 Apr 2023 16:18:17 by Brian_S

216

Hi everyone!

I am hoping someone can please help me. I am really new to PowerApps and am creating a form with dependent dropdowns. I did the Distinct(Filter) formula but it was not showing all the options. I read online that if you have over 2000 records it is recommended to use a lookup formula. My sheet will have appx 3000 records when all said and done.

I have a total of 6 columns. The column titles are Price Model (Title) / Call Order / Task / Position / PoP / Call Order Rate

All the columns are single lines of text except the one with title and Call Order Rate

I am struggling with the formula that when a person selects the Pricing Model selection (one of two selections) that the Call Order choices will be based on the option selected in the Pricing Model dropdown.

Any guidance and help would be appreciated.

Brian

Categories:

General Questions

Using Apps Using Formulas

All responses (10)

Answers (2)

Verified answer

AhmedSalih

6,678 Moderator on 25 Apr 2023 at 16:38:28

Like (1)

Report

Re: Need Help with Dependent Drop Down on Power Apps

@Brian_S, do you mean the Unique values of this Formula: Sort( Filter( YourDataSource, Title = DropDown1.Selected.Value ), CallOrder )? If so, use the Distinct function:

Distinct(Sort( Filter( YourDataSource, Title = DropDown1.Selected.Value ), CallOrder ),ColumnHasDublicates)

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Verified answer

AhmedSalih 6,678 Moderator on 25 Apr 2023 at 17:12:39

Like (1)

Report

Re: Need Help with Dependent Drop Down on Power Apps

@Brian_S, here is this treasure by @RezaDorrani https://youtu.be/GoF3vfP3YTM

You email body can include the data from the form and last line of code in the Button.OnSelect is to Reset(YourFormName)