I have a list of strings that start with a number in one drop down and what I want to do is filter the next drop down by like items. For instance,
Choices(EAPT_Apps.Business_x0020_Category) has 14 options.
For instance 9.0 Manage Financial Resources.
If I select 9.0 Manage Financial Resources, I want the next drop down Choices(EAPT_Apps.L2Processes) to be filtered by the first dropdown with items that begin with 9.
I then have a third dropdown that should be filtered by the selection of Choices(EAPT_Apps.L2Processes).
Also, since these are strings, the sorting of the options is off. It starts with 1.xxxx, 10.xxxx, 11.xxxx, 2.xxxx and so on. I would like to sort logically 1,2, 3, etc. Anyway to do that with strings in PowerApps?
See screenshot. Again, choose first dropdown, it filters the next dropdown with options only related to the first. Choose the options in the second dropdown and it filters the choices in the third dropdown. These are all in separate columns in sharepoint and their is no relationship in Sharepoint.
This partially worked. While it did filter the results, it only filtered the last option entered not all of the options. Since this is a multi-select and there could be multiple values, I want to filter the next dropdown by all values for each item selected. For instance, if I choose 9.8 and 10.2, I should see all possible values for 9.8 and 10.2 not just 10.2 as it is now. It should take all values selected.
Also, the logical sorting is not sorting properly. It is still sorting 1, 10, 11, 2, 20, 3, 30, etc. instead of 1,2,3,4,5 etc.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Continue your learning in our online communities.
Next Wednesday, September 18th at 8am PDT
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200