Case sensitivity in file name and extension in managed File System Connector using Data Gateway

Germán Mendoza 0

Hello everyone,

I have a workflow in a standard Logic App that reads a file content from a Windows file share. The reading is done thanks to the managed File System Connector, which is configured to use a Data Gateway. It works great.

But, when getting the data or metadata for a file using its path, I noticed that the file name and extension parts in the path are treated in a case sentitive manner. How can I make the connector to deal with the path in a case insentitive way?

Thanks!

Shireesha Eeraboina (Quadrant Resource LLC) 755 Reputation points Microsoft Vendor

2025-01-21T07:10:03.18+00:00
Hi @Germán Mendoza,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

To address the issue of case sensitivity when using the managed File System Connector in your Azure Logic App, you can follow these simple steps:

Before passing the file path to the connector, ensure that the file name and extension are in a consistent case (e.g., all lowercase or all uppercase). You can use the toLower() or toUpper() functions in your Logic App to achieve this.

For example, if you are constructing the file path dynamically, you can do something like this:

{

filePath": "@{toLower(variables('yourFilePath'))}

}

If you are checking for the existence of a file or comparing paths, make sure to convert both the input path and the stored path to the same case before comparison.

Also, for your reference and better understanding please follow the below document

https://learn.microsoft.com/en-us/rest/api/storageservices/Naming-and-Referencing-Shares--Directories--Files--and-Metadata

I hope this helps! Let me know if you have any further questions or need additional assistance.
Shireesha Eeraboina (Quadrant Resource LLC) 755 Reputation points Microsoft Vendor

2025-01-22T07:56:09.8133333+00:00

Hi @Germán Mendoza,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Case sensitivity in file name and extension in managed File System Connector using Data Gateway

Your answer