Simplify filter with the same condition

How To
1

Hello

how can I simplify this?

grafik
grafik457Ă—816 35.7 KB

I thought something like this could work?
grafik

kind regards

2

Hi @TylonHH ,

You could use this:
image

First, you define an array with all your values to exclude (with add function).
Then test if this array doesn’t contain your variable.

Hope this helps.

Philippe

5 Likes
5

I tried your solution
this is my output wich I wanna filter

image
image450Ă—621 26.9 KB

And this is filter
image

After the filter I send an eMail, but in this case both attachment were send

image
image1399Ă—692 53 KB

6

Hi @TylonHH ,

I agree with you, it’s a bit misleading: it checks that the variable belongs to a given array.

In your case, if you are sure that the name of your “File name” is always -blabla.pdf, where keyword is one of the word in the array, you could use:
image

Please, find in attachment my blueprint.
Simplify filter with the same condition.json (4.4 KB)

BR,

PBI

3 Likes
7

Not really. The filename is not always the same.
I just wanne exclude some file wich contains in the name onbe of the words. For example “receipt”, no matter in wich position the word in the filename is. Never thought this would be so difficult.
I guess I have to look to the text operator?

8

It’s often a good idea to rationalize file names, it avoids a lot of subsequent difficulties.

2 Likes
9

So I ended up to do it the old school way

grafik
grafik453Ă—901 27.8 KB

:shushing_face:

3 Likes
10

Hello there @TylonHH :wave:

It’s great to see that you got that condition working! Oldschool’s always cool :sunglasses:

Also, thanks a lot for stepping back in here and sharing your final setup with the community. This is super valuable stuff :pray:

2 Likes