Hi all, (just heads up, I’m brand new to Thunkable… I have PowerApps experience but quite limited outside of that)
I am building a shopping list app for myself. My table is a local DB and consists of 10 columns with unlimited rows potentially. Some cells can be empty.
There are empty cells. There are duplicate items.
I was able to take all items across these 10 columns and put them into a list - which I was over the moon about. For example, my list looks like this (With loads of commas at the end which I assume are the blank cells)
“Carrot,Brocolli,Curry Block,Potato,Milk,”
Edit: I’ve added a screenshot as Thunkable won’t allow me to write commas in a line like that
When I try to remove empty cells by following a guide I saw here on Thunkable community, the output is still the same as above!
I want to:
take my allIngredients list
remove blanks
then remove duplicates
create a new list called uniqueIngredients which should be clean of blanks and no duplicates
Sorry again, I know this is probably something super simple that I’m missing or doing wrong but I’m not very experienced with Thunkable yet. Thanks for any help in advance and can provide more screenshots if needs be.
Thanks for the reply. I didn’t realise I was actually putting multiple lists into allIngredients, but that makes sense. It’s essentially 10 lists rather than 1 list of all items in those 10 lists.
I tried your solution, the app was crashing.
So I moved the problem area into a button click as shown below. When I click the button, the app crashes. So it must be something going on here.
*Edit, I was messing around with some things and changed some variables in the blocks below. Then I put them back the way you recommended. The app doesn’t crash anymore, but the resulting text in Label2 is the same as before.
Since I didn’t realise I was putting 10 lists into a variable, is there an easier way?
Basically, 10 columns of data containing Shopping Items (Ingredient1 → Ingredient10).
I’m trying to export all the ingredients from those 10 columns and only have the unique ingredients.
Though I suppose too, if you can spot something minor wrong I can fix, would appreciate the help again! Thanks so much.
I got it! I found a few things that needed to be changed with your solution but you put me on the right track.
This is a screenshot of the (messy but works) solution.
It’s unnecessary to have the Label text being set, but it’s just for me to see the before and after.
This takes a 10 column local table, removes duplicates and blank cells and puts them into one list.
