Assistance with Sort / Filtering

[ianallen13]

Hello, 

I'm working on an app for work which basically connects to an excel file as it's data source (for permissions reasons, this was the best option) and on the whole, it seems to work correctly, HOWEVER, when I check the filtering - it's not giving me the correct fields that correspond with the selected program & concentrations.  

Please see below: 

The IDEA works, but it's not providing the correct results for the boxes below based on the selections above.  My formulas are as follows:

Step 1. 

Step 2. 

"Future Program with No Decision..."

"Future Program with Decision..."

"Exception (If Applicable)"

I'm also attaching the excel file that I'm using as a data source.  If anyone has any guidance as to what I'm doing wrong or what I can do to hopefully correct this, I'd appreciate it. 

Thank you! 

[AJ_Z]

I am so glad I was able to help out 🙂 Good luck with your PowerApp 🙂