Trying to use a filter query in a Sharepoint "Get Files (properties only)" action and having no luck getting it to function.
I'm trying to filter the sharepoint "Name" column against data in an Excel sheet "Name" column, and it's pulling the excel data properly but I get:
The expression "FileLeafRef eq 018179.pdf" is not valid. Creating query failed
I've used "Name" and "LinkFileName" as well as "FileLeafRef" after various research, but none of them change anything.
The actual expression I'm using is
FileLeafRef eq item()?['Name']
So....how do I get this filter query to work?