Condition based on Get Files (Properties Only)

[tigertedd24]

I'm trying to check to see if a file exists already in a folder. The file contains the word ANNEX5.

I'm using Get Files (properties only), and then a condition that asks Body Contains ANNEX5.

The next action is to create a new file. If the condition is true (ie ANNEX5 already exists) it'll create a file called FINAL-ANNEX5, if it's false it'll create a file called ANNEX5.

But it's not working, it always comes back as false and I don't know if it's overwriting the old file or just not doing anything, but it's certainly not creating a new file called FINAL-ANNEX5. I've checked the JSON output of the Get Files Action, and the term ANNEX5 appears several times. I assumed this is what I'd be fetching with the Body dynamic content, and it definitely contains what I'm looking for.

Chat GPT suggested I should use Name instead of Body, but this automatically creates an apply to each, so every time it's false it tried to create a new file with the old name. It does eventually create a FINAL document when it cycles through all the names and does find one that matches, which does result in a True. But I'm worried about what it's doing to the original file.

i was hoping I wouldn't need to use Apply to Each, and a simple condition checking the body should work. There are other dynamic field options though, like Value, or Body/Value - Items. I could trial and error it to see which one will work, but I was hoping someone here could help, as it takes ages to run through the whole flow to test it every time I try something new.

[creativeopinion · Accepted solution]

@tigertedd24 

After the Get files (properties only) action, use a Filter Array action instead. It'll be more efficient. Rather than looping through each file, it'll look through all files returned by the Get files (properties only) action and check whether a file contains the word.

Add a Compose action after to check the number of items returned from the Filter Array action. Use an expression:

length([insert filter array body output here])

Condition

In your condition action, check to see if the number of items returned is equal to 0. I've inserted the outputs from the Compose action as the first value.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[tigertedd24]

Success. Thank you so much! Chat GPT is an idiot. Real human beings are far smarter!

[creativeopinion]

You're welcome! ChatGPT is okay.... sometimes. 😏