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
@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?
Awesome! Thank you again for everything. I am not very fast in doing this stuff :)!
@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)
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?
Hi Ahmed! I figured it out. You are a rock star, thanks so much for all of your help!!
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
@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)
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.
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 )
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473