A time based flow that loops through a row and, based on the data, copies certain corresponding values to a new spreadsheet

(0) Share

Report

Posted on by GavinFins

I would like to create a flow that runs each week, loops through an excel column which contains forms response dates and if this date is within the last 7 days, takes certain corresponding cell values and adds them to a new excel sheet.

So my response form will look like this:-

If I ran the flow today, it would pick up all four rows, but I only want those columns in green to be transferred across to a new sheet (and a new tab on that sheet) to look like this:-

Is this functionality even possible in Flow? (I have come from a Google environment and are better versed with Google Script). If it is possible, what sort of connectors do I need to familiarise myself with?

Thanks

All responses (1)

Answers (1)

Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: A time based flow that loops through a row and, based on the data, copies certain corresponding values to a new spreadsheet

@GavinFins

Hi there. Totally possible. Look for a Recurrence trigger and then read up on either OData filters, or use a Filter Array action after your Get Items. This article has some extraneous stuff for you, but covers the core of what you're after:

Birthday Bot - Part One - Send eMails, SMS, or Physical Cards with Power Automate

Rather than looking back 7 days, that one is looking forward, but it might be enough to get you started. Be sure to check out the one right after that, too, in case there's some improvements that affect your build.

Good luck, and keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.