Unanswered

Create flow to send excel attachments with manual trigger

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I've been working on this small flow. The ideal scenario is that the user manually triggers the flow, submits 2 numbers and then the flow sends emails based on other criteria but I'm having trouble with 2 specific steps.

1. Get file content: For some reason, I cant set this flow to get the content of the files correctly in a one drive folder if I change the trigger to trigger manually. Currently, the trigger is "When files are created" but is there a way to get the content of the files in that folder without having to rely on this type of trigger?
2. Loops: I'm having a hard time understanding these. When I test my flow, sometimes it sends the same email twice or thrice. Could you give me some tips on how to make this flow more efficient?

Here's a screenshot of the current flow:

Basically, it triggers when someone adds excel files to a one drive folder. The flow goes to that folder, checks if the excel file contains an ID that matches a customer and if that's the case, it sends the excel file as an attachment.

Thank you so much for your time!!

I have the same question (0)

All responses (2)

Answers (0)

swathirajan 93 on at

Like (0)

Report

Re: Create flow to send excel attachments with manual trigger

Hi,

Can you explain a bit about what trigger you would like to use?
Do you want the workflow to start every time when the file is added or do you want to schedule the trigger so we can set the recurrence of the flow.

You are receiving multiple emails because of the inputs you give in loop.
For example, when I create a approval workflow, if the files that needs to approved are two, two emails are triggered. If there are four approval files, four emails triggered to the approver, with each file data mentioned in each email.

We need to make sure all details are covered in same email that one email is triggered to the approver with four approval files.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Create flow to send excel attachments with manual trigger

Hey @swathirajan! Thank you so much for taking your time to help me with this!

Sure! Either when the file is added or by manual input, both of them are ok, I just need to have the option for the 2 inputs.

Thank you! That's what I thought but I just can't figure out how to create the flow without adding extra loops 😥. For example, If I change the trigger to manual trigger (To have the option of the 2 inputs) the "Get file content" creates an extra loop (Please refer to the image below). Honestly, I don't know how to retrieve the content of the files in a folder without relying on the "When a file is created" step. Do you have any ideas of how to make this work?

Also, by changing the "Get File Content" step, the option to attach content in the "Send email" step disappears:

Thank you so much for your time again!

Was this reply helpful? Yes No