Lookup in a galery

(0) Share

Report

Posted on by s44

687

I have a gallery that filters on my SharePoint list "List1". In this gallery, I have a label that displays a value from my list "List2". I am trying to create a filter on my gallery, but it does not work. I would like to display the items whose return date will expire in 2 months (or the items whose expiration date has passed) and I would also like (condition or) to display the items whose KM is greater than or equal to 20,000.
Can you help me please?

Immat is a lookup column in my List1.

Filter(
        'Liste1';  
    ( ('Date expiration' >= Today() && 
    'Date expiration' <= DateAdd(Today(); 60; TimeUnit.Days))
 || ('Date expiration' <= Today() ) ) || (LookUp(
        Liste2;
        Immat.Value = Immat.Value && KM > 20000;
        true
    ))

Categories:

Employee Ideas app on Teams

Using Apps Using Formulas

All responses (4)

Answers (0)

ronaldwalcott 1,058 on at

Like (0)

Report

Lookup in a galery

You have not explained the filter condition regarding Immat? How are you filtering on this value?
s44 687 on at

Like (0)

Report

Lookup in a galery

Sivaksk147 It's doesn't work. Nothing is displayed in my gallery
Sivaksk147 10 on at

Like (0)

Report

Lookup in a galery

try this

Filter(
'Liste1',
(
('Date expiration' >= Today() && 'Date expiration' <= DateAdd(Today(), 60, TimeUnit.Days))
|| ('Date expiration' <= Today())
)
|| LookUp(
Liste2,
Immat.Value = Immat.Value && KM > 20000,
true
)
)
s44 687 on at

Like (0)

Report

Lookup in a galery

.