Answered

Filters - filtering on multiple data sources

(0) Share

Report

Posted on by ET-04121333-0

Still a little stuck here!

I have two data sources, both containing a 'Tasks' column. I want to set the items property of my gallery to filter both data sources on 'Tasks' according to the selected values.

The statement also contains a lookup which is working fine (thanks a contributor on this forum!)

AddColumns(
   Filter(
      'Engagement Tasks',
      Title = Gallery2_1.Selected.Value),
&&
    Filter(
        'Engagement Phases',
      Title = TabPhases.Selected.Value),
),
   Description, 
   LookUp(
      'Engagement Phases' As _Data, 
      _Data.Tasks = Tasks
   ).Description
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ravi-Prajapati 416 Moderator on at

Like (1)

Report
Copy link

Link copied!
It looks like you're trying to filter two different data sources ('Engagement Tasks' and 'Engagement Phases') based on selections from Gallery2_1 and TabPhases. However, the way you've structured the Filter functions with && is causing an issue because you're trying to apply two independent filters to separate tables at the same level.

Corrected Approach:

Instead of filtering both tables together with &&, you need to:

Filter 'Engagement Tasks' based on the selected value in Gallery2_1.

Filter 'Engagement Phases' based on the selected value in TabPhases.

Use AddColumns to add a Description column from 'Engagement Phases' by looking up the matching Tasks.

Here’s a revised version of your formula:

AddColumns( Filter( 'Engagement Tasks', Title = Gallery2_1.Selected.Value ), "Description", LookUp( 'Engagement Phases', Title = TabPhases.Selected.Value && Tasks = ThisRecord.Tasks, Description ) )

Explanation:

Filter 'Engagement Tasks'

It selects only tasks where Title matches Gallery2_1.Selected.Value.

AddColumns adds the "Description" column.

LookUp('Engagement Phases', ...)

Finds the corresponding Description where:

The Title matches TabPhases.Selected.Value

The Tasks match the current record's Tasks from 'Engagement Tasks'.

Expected Behavior:

The gallery will now display tasks from 'Engagement Tasks' filtered by Gallery2_1.Selected.Value, along with their matching Description from 'Engagement Phases'.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @ET-04121333-0,

I think you are trying to do this - I will give you a HI (human intelligence) response as the first post appears to be straight from ChatGPT.
AddColumns( Filter( 'Engagement Tasks', Title = Gallery2_1.Selected.Value || Title = TabPhases.Selected.Value ), Description, LookUp( 'Engagement Phases' As _Data, _Data.Tasks = Tasks ).Description )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
ET-04121333-0 26 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the responses! Yes, AI has gotten me into this muddle :)

Using either of the suggested approaches works fine to apply the first filter on the 'Engagement Tasks' data source.

However, the gallery is still not filtering Tasks based on the value selected in TabPhases (this references a different data source called 'Engagement Phases'.

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ET-04121333-0,

Now I see that, I am trying to work out exactly what you want. If you want the two filtered data sets in the Gallery, you can do this
Table( AddColumns( Filter( 'Engagement Tasks', Title = Gallery2_1.Selected.Value ), Description, LookUp( 'Engagement Phases' As _Data, _Data.Tasks = Tasks ).Description ), Filter( 'Engagement Phases', Title = TabPhases.Selected.Value), ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No