Getfile with specific date from Excel file in onedrive business and send with email

(1) Share

Report

Posted on by JB-30071924-0

Hi everyone,

I set up a flow to send an email with a file every month. The flow works—it sends the right file at the right time. However, the issue is that the PDF file is empty (no content).

Ofcourse I checked the file and the files are not empty.

It seems like the file is being created instead of being grabbed.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

NsL Coder 475 Moderator on at

Like (0)

Report
Copy link

Link copied!
Your flow is definitely in a mess.

I don't see any reason for your Apply to each action, as there is no action in there

Your For each have another For each 1 loop, which does not make sense, what array are you looping in each of these?

I also don't know what you trying to do as well. Are you trying to loop each rows (multiple rows) in the excel file, get a column of the rows which is part of the file name that you are trying to get from a folder location in onedrive?

If so, there is no reason why you would have the List files in folder action.

List rows present in a table

Apply to each row

Get file content - composing the File field using the column of info from excel and knowing what folder these files are in

send email with file content as attachment

Was this reply helpful? Yes No
JB-30071924-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @NSL Coder,

I followed this video: Automate Emailing Excel Task Reminders with ZERO Coding! - YouTube

And then I made some specific changes.

So the goal of this flow = Send an email on the in Excel specified date with an specific attachment.

Here you can see the Excel file.

These files are in an onedrive folder.

But now; The email is send on the right date with the right name and also with an email attachment with that name.

But the attachment is emphty.. It seems like it generates this PDF file instead of grabbing it from the onedrive folder.

Was this reply helpful? Yes No
NsL Coder 475 Moderator on at

Like (0)

Report
Copy link

Link copied!

did you add the file content into the send an email action?

show screenshot of the get file content action in a run history, in edit mode

do the same with the send an email v2

Was this reply helpful? Yes No
JB-30071924-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nsl Coder,

Seems that we action was not triggered.

Action send email:

Overview history:

Get File Content:

Send an Email:

Was this reply helpful? Yes No
NsL Coder 475 Moderator on at

Like (0)

Report
Copy link

Link copied!

As I mention in my first post, the logical sequence of your flow is flawed.

The reason your "get file content" and "send email" didn't work is b/c it didn't go down the "Yes" path of your condition. You are using too many apply to each unneccessarily. So either (1) completely revamp your flow and align with what I sent in my first post recommendation. or (2) continue to go down this and diagnose why your condition is not working. (show screenshot of edit mode of the condition).

Was this reply helpful? Yes No
JB-30071924-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hereby the overview of the condition:

Was this reply helpful? Yes No