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 email@example.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.
Solved! Go to Solution.
Hi @carrigan ,
Sorry , here is the expressions.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.