Two Galleries against one data source

[akharns]

I have two galleries that I want to use for the same data source.  I have defined filters in the Items statements to be mutually exclusive: 

Filter(VendorStatus,SubmissionMonth='SubmissionMonth combo'.Selected.SubmissionMonth && Entity<>"Outbound")

Filter(VendorStatus,SubmissionMonth='SubmissionMonth combo'.Selected.SubmissionMonth && Entity="Outbound")

The 1st gallery shows data and the 2nd does not.  The fields do not show at all, indicating that it did not find any records.  I have confirmed that the fields on both galleries are mapped to fields in the data source.  

Since each filter command creates a copy of the source table, I wouldn't think there should be any linkage between the two.  Where else should I look for the source to this problem?

[RezaDorrani]

Hi @akharns 

There is no linkage between the 2 (mutually exclusive)

Check your data source to see if there are any records that match the criteria 

SubmissionMonth = your value and Entity = "Outbound"

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[mdevaney]

I’d wager it’s this portion of your code

'SubmissionMonth combo'.Selected.SubmissionMonth&&Entity="Outbound"

To add multiple conditions on the filter separate them by commas rather than &amp;&amp;. You’ll need to rewrite it like this:

Filter(VendorStatus,SubmissionMonth='SubmissionMonth combo'.Selected = SubmissionMonth, Entity="Outbound")



—
Please Accept as Solution if this post answered your question so others may find it quicker. If you found this post helpful consider giving it a Thumbs Up!

[akharns]

Ok, guys.  I feel stupid.  We're all wrong.  The field heights were set at zero, so the fields were not visible.  LOL.  I had deleted the field that I was using to drive the height.  

One more lesson learned.   😉

[mdevaney]

Dontcha hate when that happens? LOL.

[akharns · Accepted solution]

Cheers, guys.  Thanks for helping me slug through this.