Answered

Use Google Spreadsheet with Google Drive folder to send multiple attachments to user

(0) Share

Report

Posted on by carrigan

I want to build a flow that is looking at a spreadsheet (Google Sheets) and a Google Drive Folder. In my spreadsheet, I have 2 columns named "ReportName" and "Email". In my Google Drive Folder I have about 50 reports to choose from. I want to look at each row in the spreadsheet and email all the reports from Google Drive to that person. I put a table below as an example of what I have. You can assume that the Google Drive Folder file names/reports are named the same as the report name on the spreadsheet. So in Google Drive, the report name for "GoogleReport1" is GoogleReport1.pdf. I have tried for a couple days but I cannot figure out how to get a flow to run and look at each row and combine all the reports for, lets say john@email.com, then look for all his reports in Google Drive Folder and email them to him. I am thinking there is a way to build an array but pulling from two sources is over my beginners head. Any help would be great.

ReportName	Email
GoogleReport1	john@email.com
GoogleReport2	john@email.com
GoogleReport3	john@email.com
GoogleReport1	janedoe@email.com
GoogleReport1	joe@email.com
GoogleReport2	joe@email.com

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @carrigan ,

I've made a test for your reference:

1\My Google sheet

2\My Google Drive

3\My flow

4\Result

Best Regards,

Bof

Was this reply helpful? Yes No
carrigan 6 on at

Like (0)

Report

I could be overlooking it but what do the expressions you are using look like?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @carrigan ,

Sorry , here is the expressions.

1\union(body('Select_2'),body('Select_2'))

2\items('Apply_to_each')['Email']

3\item()['ReportName']

4\items('Apply_to_each')['Email']

Best Regards,

Bof

Was this reply helpful? Yes No
carrigan 6 on at

Like (0)

Report

I wrote it up exactly like you did and it works perfectly!! However, if I modify the name of the ReportName in the spreadsheet, say I change the name of "text1.txt" on the spreadsheet to "text1", it only finds text2.txt and attaches it. Is there a limitation to the "contains" rule I am missing? Also, I used a few more files with multiple email addresses, that is what you are seeing in my filter array 2 input.

I make a small change to name on spreadsheet to report name.

Join Output is right.

Filter array input..

Filter Array output only shows test2.txt.

Was this reply helpful? Yes No