Unanswered

Incorrect Trigger

(0) Share

Report

Posted on by Calheiro

Hello everyone,

I'm building a Cloud Flow that whenever I add a file to an specific OneDrive folder I must receive an Email with an Excel File with a list of informations about those documents and I've already figured how to do this part. Now, for this flow I'm using the "When a file is created" OneDrive for Business Trigger. The thing is when I add more than one document, I receive lots of emails. Let's say, if i add 300 documents on the folder I will receive 300 emails. I need this corrected because that folder usually gets added tons of documents in one go. Is there a trigger that runs flows only when that specific folder is updated? I'm kinda new to Automate and I feel this a fairly simple question.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

mattias1172 385 on at

Like (0)

Report

Re: Incorrect Trigger

What exactly do you want the trigger to be against the folder?

The trigger "when a file is created" will fire anytime a file is added to that folder. If you add 300 files, you'll get 300 triggers as you've seen.

Are you trying to get a single email after all xxx files are added and send an email with the Excel document detailing all those xxx files?

Was this reply helpful? Yes No
Calheiro 65 on at

Like (0)

Report

Re: Incorrect Trigger

"Are you trying to get a single email after all xxx files are added and send an email with the Excel document detailing all those xxx files?" - Yes, exactly.

Was this reply helpful? Yes No
mattias1172 385 on at

Like (0)

Report

Re: Incorrect Trigger

Does this dump of files happen on a routine/scheduled basis? Do they get cleared from this folder afterwards?

Was this reply helpful? Yes No
Calheiro 65 on at

Like (0)

Report

Re: Incorrect Trigger

They do not happen on a scheduled basis, but they are cleared from that folder afterwards.

Was this reply helpful? Yes No
mattias1172 385 on at

Like (0)

Report

Re: Incorrect Trigger

Is there any form of consistency for when the files get added? If not currently, is that something that could be done?

If so, one easier way to do this would be to use a scheduled trigger such as hourly, daily, or daily at certain times. When the scheduled time happens, it gets all files in the folder, gets their contents for each file, and appends a new row to an excel table.

A very rough example:

I don't know what information you are trying to get from the files, but you can just change the "Get File Content" action to what's needed. The "List files in folder" will pass both the file ID and file Path as dynamic content.

Was this reply helpful? Yes No