Referencing File Names In Power Automate

This blog tells what to refer to while updating file properties.

Introduction

While working on the Odata query in Power Automate, I recently came across an error. I was referencing the ‘Name’ column for the OData query.

In Power Automate I was getting the following error saying the ‘Name’ column doesn’t exist. You might already know that when a file gets uploaded to the document library only the ‘Name’ field will be updated and the ‘Title’ remains blank by default.

Below is the error from the flow run for the ‘Get files(properties only)’ action. It says column 'Name' doesn’t exist. It may have been deleted by another user.

Filter query is given as Name eq 'FILENAME',

Fix

In order to get the file properties, you have to refer to the special internal property called FileLeafRef. The filter query becomes FileleafRef eq ‘FILENAME’.