web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery based o...
Power Apps
Unanswered

Filter gallery based on two lists

(0) ShareShare
ReportReport
Posted on by 1,512

I have two list one is Archive data and one is the new stuff.  I am filtering based on the Created>=DateAdd(Today(),-60,Days) as well as if data is not in the Invoice Processing Historical that matches DataCardValue53_5.Text then look in Invoice Processing.

 

I have tried this and it is not working I have the syntax wrong but cant figure out how to make it work

Filter('Invoice Processing Historic',Created>=DateAdd(Today(),-60,Days), (DataCardValue53_5.Text', NOT(DatacardValue53_5.Text in 'Invoice Processing' )))

 

Any help would be apprecaited.

 

Dorinda

Categories:
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Dorinda 

    Please consider changing your Formula to the following:

    Filter('Invoice Processing Historic',
     Created>=DateAdd(Today(),-60,Days) &&
     !(DatacardValue53_5.Text in 'Invoice Processing'.someColumn)
    )

    Change the someColumn to the name of the column that you are trying to check against in the other list.

     

    I hope this is helpful for you.

  • Dorinda Profile Picture
    1,512 on at

    @RandyHayes I tried this and nothing came up and I am confused on the ! before the column it is supposed to be matching.  Why is the NOT equal being used?

     

    This formula seems to be missing stuff

     

    Filter('Invoice Processing Historic', Created>=DateAdd(Today(),-60,Days) && (DataCardValue24.Text in 'Invoice Processing'.ContractNumberId) )

     

    In the Historic list it needs to look in the Direct Short Description and in the Invoice Processing the ContractNumberID, the data in both is identical but I am not getting anything back at all from either list

  • Dorinda Profile Picture
    1,512 on at

    @RandyHayes so I got this first part to work

     

    Filter('Invoice Processing Historic', Created>=DateAdd(Today(),-60,Days) && 'Direct Short Description'= DataCardValue24.Text) and it returned some of the information as expected, I am just not sure how to also have it look at the other list Invoice Processing in the ContractNumberID column.

     

    Almost there

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Dorinda 

    I am not entirely clear on the logic you are trying to do.

    My understanding is that you want to Filter the historic list for records that are newer than 60 days ago and where the DataCardValue53_5.Text (whatever that may be) is not in the 'Invoice Processing' list - which needs to specify a column.

    Is that incorrect?

  • Dorinda Profile Picture
    1,512 on at

    @RandyHayes I need to return the values from both lists not just one or the other.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Dorinda 

    Can you expand on what that means (values from both lists)?

    Your formula, I assume, is in a Gallery Items property - in which you can only have one schema (i.e. not two datasource schemas).  You can combine them in a way, but I am not sure what your goal is on this.

  • Dorinda Profile Picture
    1,512 on at

    @RandyHayes  can we do a collect of both list and then use that for the filter.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Dorinda 

    You don't need a collection, you need to define more about what you mean by values from two lists.  The filter will work fine, but there is no definition about the values from both lists.  

    A collection is a snapshot of a table (in this case you're saying from a datasource) - it still is two different schemas - which you cannot do in a formula just by adding them in.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 188 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 120

Last 30 days Overall leaderboard