Gallery Items from 2 tables and using conditional

[MatheusRuiz]

Hello everyone, hope someone can help me out with this...

I have two tables:

• PowerBiIntegration.Data: a table from PowerBI with 3 columns:
  1. 'Service_Key'
  2. 'Chassis_Number'
  3. 'Customer_Name'

• Table1: it is from Excel and is populated by a form in PowerApps that displays data from PowerBiIntegration.Data's columns. This Excel table has 4 columns:
  1. 'Service_Key'
  2. 'Chassis_Number'
  3. 'Customer_Name'
  4. 'STATUS'

1. What I need to do is display all PowerBiIntegration.Data items in a gallery but I want to exclude from the view the items (looking for each Service_key) that are in Table1 (Excel) and that have the value 'Finalized' in the 'STATUS' column. 

Which formula can I use to do that?

Thanks in advance!

[Gochix · Accepted solution]

Hi @MatheusRuiz ,

You could do something like this to resolve your issue:

Filter(PowerBiIntegration,Not('Service_Key' in Table1.Title) && Not("Finalized" in Table1.STATUS))

 Not sure how powerbi integration works as not using it.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!