I have been playing around with powerapps and my first app is a fact!
To further improve it I would like to expand the form.
The app is meant as an order management app
I have created a couple of screens, starting with a start screen.
Is this possible to do, if so I would appreciate it if someone could push me into the right direction!
I have been trying to get the first cascading lookup done for the order screen but i keep getting errors.
The formula I used in dropdown-list1 is: Filter(lijst1; categorie=Category_dropdown.Selected.Value)
If you have two dropdown, you can write in such a way
1. dd-list1 = Distinct(lijst1, categorie)
- Always use DISTINCT to generate a Non-duplicating table, and show the desired FIELD (here, Categorie)
2. dd-list2 = Distinct(Filter(secondtable, categorie = dd-list1.Selected.Result), categorie)
- Then, again, using DISTINCT to generate another Table for Dropdown, with categorie = first dropdown selected value, and show only those filtered's "categorie")
I hope this is what you are looking for.
Thanks and have a nice day.
Thanks for your fast reply @hpkeong.
I tried it right away but in my dd-list2 I get the following error:
"Warning: The colums produced by this rule are all nested tables and/or records, however the property expects at least some colums of simple values (such as text, or numbers)"
The field "categorie" is a lookup in SharePoint to the "dd-list1" list, so the references are exact the same (text).
So ddlist1 - OK?
for dd-list2, just to share
- Distinct(Table1, Field) are used to generate table for selected field in Dropdown.
Table1 can be just a pure table or filtered table from dd-list1.
ddlist1 here can be = Dropdown1.Items = Distinct(Table1, Category) and you can see 3 items in the dropdown = A1, A2, A3
then for ddlist2, Dropdown2.Items = Filter(Table1, Category = Dropdown1.Selected.Results).Items
or = Distinct(Filter(Table1, Category = Dropdown1.Selected.Results), Items).
Maybe I quoted incorrectly of your table name, but i hope the above sample is clear.
I followed your example but I keep getting errors. It seems like Powerapps is not recognizing the loopup column I have created in the list "lijst1".
"lijst1" is my list with the following columns : title, category_lijst1, price, where "category_lijst1" is a lookup to the category list in SP.
I have used the following formulas:
On dropdown1 i get the following error: The property cannot consume the type of Tables that this rule produces, due to incompatible schemas
dropdown2 gives the invalid argument type error.
If I change the formula for dropdown1 to Distinct(category, Title), it shows all categories of the category list, but still dropdown 2 won't work.
You mentioned "where "category_lijst1" is a lookup to the category list in SP"
OK, looks like I misunderstood you.
In my years of practice, I have never used PowerApps CDS (and i have no SPL) and select "LookUp" option.
- I would prefer to use my own FREE WAY to write formula and using
Distinct, Filter and LookUp to create all those formula.
In your case, MAYBE because you have predefined in SPL, hence, you have to ensure it follows to the rules.
In such case, I am sorry that I can;t help as I have no way yo know SPL scenario.
Hope PG will help
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021