Unanswered

Apply to each only working on smaller numbers

(0) Share

Report

Posted on by 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!?

Categories:

General topics

All responses (4)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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 8,692 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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.