Power Platform Community Forum Thread Details

Hey team,

I query a view on a database which returns the path of a file on a file server, then it uses File System 'Get file metadata using path'. The issue is, the database isn't case sensitive so when it looks for 123M456A.docx it is not getting a match to the file 123M456a.docx. There is no pattern to this madness either so I can't just convert the last letter to lowercase.

I was looking at this similar problem but one of the sub folders change frequently and there is about 20000 files spread across 5 sub folders.

I am going to walk away in frustration today and hope someone else can point me in the right direction.

Categories:

General topics