Dashbord enum-list filtering

AppSheet AppSheet Q&A
1

Hi!

New user in need of some guidance.
“Dashbord filter[Program]” is a Enumlist text basetype with suggested values from “DUMP FRÅN DRIVE[Program]”.

“[Dumpis]” is a VC_Enumlist ref basetype with app formula “Select(DUMP FRÅN DRIVE[Program],[_THISROW].[Grupp- nummer]=[Grupp- nummer])”

The selection works. But only for one selection. If I select two or more from the enumlist, I get a “No items”.

What I want is to show a list of tools connected to each Program.
So if two or more Programs is selected. The list for those programs should be shown.
I’m stuck!

My slice Row filter condition.

OR(
    ISBLANK(Dashbord filter[Program]),
    IN(Dashbord filter[Program], [Dumpis])
  )

2023-02-15 15_10_44-Toolcribz - Google Kalkylark.png
2023-02-15 15_10_44-Toolcribz - Google Kalkylark.png729×151 3.89 KB

2023-02-15 14_51_30-TOOLCRIB - AppSheet.png
2023-02-15 14_51_30-TOOLCRIB - AppSheet.png1303×836 104 KB

2023-02-15 13_03_23-TOOLCRIB - AppSheet.png
2023-02-15 13_03_23-TOOLCRIB - AppSheet.png1044×802 57.6 KB

2

It’s because this is a list-of-lists. You need to flatten it to a single list type. To do so, convert it to text, then split it back.

SPLIT( TEXT( Dashboard filter[program] ) , " , " )

1 Like
3

Yaa i thought it was something like that. Could just not get my head around it.
If I select a singel program it works. The table data tester shows the tools as “Y”.

If i multiselect, and the programs have the same tools. It shows up like it should in the app. But not in the Table data test window. Everything shows as “N”.
If i select two programs with different tools connected. I get a list of 2 tools and its missing the rest. The table data tester shows all as “N”

2023-02-15 16_20_27-Table Data - AppSheet.png
2023-02-15 16_20_27-Table Data - AppSheet.png1748×794 35.2 KB

2023-02-15 16_18_48-Table Data - AppSheet.png
2023-02-15 16_18_48-Table Data - AppSheet.png1797×848 34.2 KB

2023-02-15 16_17_52-Table Data - AppSheet.png
2023-02-15 16_17_52-Table Data - AppSheet.png1777×841 38.8 KB

4

Oh, your IN() is backwards too. First argument is the single item, second is the List.

https://help.appsheet.com/en/articles/2357277-in

1 Like
5

One week later and alot of hair loss, and I still can’t get this to work!

Im trying to filter out a long list of tools connected to the programs im picking in the “Dashbord filter[Program]” enumlist selectionbox.
“Grupp- nummer” is the tools im searching for.

The [Dumpis] is a VC column with appformula: Select(DUMP FRÅN DRIVE[Program],[_THISROW].[Grupp- nummer]=[Grupp- nummer])
This seems to do what i want.

DUMP FRÅN DRIVE - table

Program Grupp- nummer ID
…
0299461T2 243 0299461T2243
0299461T2 241 0299461T2241
0299461T2 815 0299461T2815
0299461T1 239 0299461T1239
0299461T3 119 0299461T3119
0299461T3 118 0299461T3118
0299461T3 801 0299461T3801
0299461T3 242 0299461T3242
0299461T3 815 0299461T3815
0299461T3 513 0299461T3513
0299569T1 201 0299569T1201
0299569T2 241 0299569T2241
0299569T2 243 0299569T2243
0299569T2 817 0299569T2817
0299569T2 501 0299569T2501
0299569T2 118 0299569T2118
0299569T2 120 0299569T2120
…

Selection of programs 0299461T2, 0299569T2
Should show these tools in the dashbordview.

118
120
241
243
815
817
501

But im not really sure its the [Dumpis] I should use as “list-to-search”. Maybe just a formula, but the ones ive tried have not made any sense.

6

Hmmm, I think I missed what the definition of [Dumpis] was from the beginning. It’s another list. So you’re comparing 1 list against another? You want the record to appear if there is even a single common element between the lists? Use:

ISNOTBLANK( INTERSECT( 
  [dumpis] ,
  SPLIT( TEXT( ....
) )
1 Like
7

Woke up in the middle of the night and thought I figured it out.
The ‘Dump från Drive’ is a excel power query, and it was not sorted correctly. Did that. Nothing change really.
But I can now see that it kinda works.
If I select Program1, it gives the right list of tools for that program. If i add Program2 to the enumlist. It only shows the tools that is both in Program1 and Program2. Nothing else.
Program1(1, 3, 4, 5, 6) Program2(1, 2, 5, 7)
It filter out (1, 5)
I whould like it to show (1, 2, 3, 4, 5, 6, 7)
And if all program was selected, it should show ALL tools.

This fomula is what is giving me this.

Tried to change the order, then nothing works like it should.

OR(
	ISBLANK(Dashbord filter[Program]),
    IN(SPLIT(TEXT(Dashbord filter[program])," , "), [Dumpis])
)

Tried Intersect(), but cant get it to work… “subexpressions must be Yes/No conditions”

8

Thus why I included ISNOTBLANK() in my suggested expression.

2 Likes
9

DUH! I missed that, thought it was a part of ISBLANK(Dashbord filter[Program])…

Thank you for the help! It worked immediately. Perfect! :raising_hands:

1 Like