Skip to main content
Community site session details

Community site session details

Session Id : F6oLHqMoEwoeYmCtkrb8KC
Power Apps - Building Power Apps
Answered

Need Help with Dependent Drop Down on Power Apps

Like (0) ShareShare
ReportReport
Posted on 25 Apr 2023 16:18:17 by 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

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 17:55:49
    Re: Need Help with Dependent Drop Down on Power Apps

    @AhmedSalih I am so sorry to ask you another question.  Everything is working perfectly thanks to you.  However, in the Bill Rate text box I have a Lookup formula, and its currently showing like 24.7.  I want it to show $24.70.  I looked online and everything is telling me to put a formula in my Default area under Data but that already has a formula.  Can you help me please?

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 17:17:57
    Re: Need Help with Dependent Drop Down on Power Apps

    Awesome!  Thank you again for everything.  I am not very fast in doing this stuff :)!

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Moderator on 25 Apr 2023 at 17:12:39
    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)

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 17:08:02
    Re: Need Help with Dependent Drop Down on Power Apps

    Sorry Ahmed, but have a totally different question.  If I want to add a button that will allow me to email the completed form with content to a certain email address via Outlook from the persons email completing the form, and want to clear the information from the form at the same time do you know how I can do that?

  • AhmedSalih Profile Picture
    6,678 Moderator on 25 Apr 2023 at 16:52:36
    Re: Need Help with Dependent Drop Down on Power Apps

    @Brian_S , Always happy to help 🙂

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 16:51:22
    Re: Need Help with Dependent Drop Down on Power Apps

    Hi Ahmed!  I figured it out.  You are a rock star, thanks so much for all of your help!!

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 16:46:38
    Re: Need Help with Dependent Drop Down on Power Apps

    Hi Ahmed, this is working wonderfully, except there is one other question.  Sorry!  The dropdown seems to be working great, but the drop down is only showing 8 choices, when it should be showing 14 choices.  For example, when I put in the pricing model option 1, there are 14 Call Orders that should be showing, but the drop down is only showing 8 choices.  Is this a setting I need to change.

    Thank you so much for all your help!

    Brian

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Moderator on 25 Apr 2023 at 16:38:28
    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

     

  • Brian_S Profile Picture
    216 on 25 Apr 2023 at 16:33:03
    Re: Need Help with Dependent Drop Down on Power Apps

    Hi Ahmed!  Thank you so much this worked great.  One last thing.  How can I show only the Unique values with this formula?  I tried adding UNIQUE(SORT..... but that did not work.

  • AhmedSalih Profile Picture
    6,678 Moderator on 25 Apr 2023 at 16:26:08
    Re: Need Help with Dependent Drop Down on Power Apps

    Hello,@Brian_S , try this and let me know if we are geting close:

    First DropDown: Distinct(YourDataSource,Price Model (Title))

    Second DropDown: Sort( Filter( YourDataSource, Title = DropDown1.Selected.Value ), CallOrder )

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete