Power Platform Community Forum Thread Details

I'm iterating through an excel and have a condition to compare to Files. When I use the Files variable it uses the path as opposed to File.Name. How can I get it to iterate through the File.Name?

This is my flow:

Get files in folder - Variable: Files
Launch Excel
Get first free column/row form Excel worksheet - variable: ExcelIntance
Read from Excel worksheet - Variable: ExcelData
For each loop --> value to iterate: %ExcelData% -->Variable: CurrentItem2
1. IF
  1. First operand: %Files%
  2. Operator: Contains
  3. Second operand: %CurrentItem2['JCN']%
  4. Display message