Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Lookup in a galery

Posted on by 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
    ))
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,058 on at
    Lookup in a galery
    You have not explained the filter condition regarding Immat? How are you filtering on this value?
  • s44 Profile Picture
    s44 687 on at
    Lookup in a galery
    Sivaksk147 It's doesn't work. Nothing is displayed in my gallery
  • Sivaksk147 Profile Picture
    Sivaksk147 10 on at
    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 Profile Picture
    s44 687 on at
    Lookup in a galery
    .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard