Apply to each only working on smaller numbers

[BWNow]

Hi,

I use the flow below to send emails to clients with there specific Excel spreadsheet attached and two other attachments that don't change. It works well 75% of the time. But, it can get very sporadic sometimes. The problem I'm running into today is that files in the name range of 00001 - 10000 work, but when I get to 20000+ it start returning a incorrect "false" expression. I can confirm the file it is looking to match is in the correct folder, but it continues to say it is not. Help!?

[Rhiassuring]

Hi there, 

It will all depend on this:

Is a name getting truncated in OneDrive, maybe? Is it formatted differently somehow? 

Can we see an example of the file name from Excel & from OneDrive for something in the +20000 range? 

Also, are  you doing this sequentially? Like, going from 00001, to 00002, to 00003........ to 100099, etc? Or is it all over the place?

R

[BWNow]

Thanks for your assistance!

I don't think they are formatted differently, all files are all created by running a macro on the same Excel sheet. I run them sequentially, and try to limit what is in the folder to the series I am running(10000, 20000, etc.) 

The condition is supposed to just be File Name(Formatted) is equal to Display Name(from list files in folder), I added the other two lines to try and troubleshoot/capture more.

[Rhiassuring]

And that OneDrive folder is always the same? That's where all of the files exist? 

I ask because I see you've mentioned, "...try to limit what is in the folder to the series I am running", but in your screenshot from the OP, it looks like it's hardcoded to /Tsomething.

Or are there subfolders in there? 

[BWNow]

Yes, it's always that folder, and it has no subfolders. I create the file on my desktop, then move the files into the folder Tony when I run the flow.