I am working on a flow to collect daily reports from our field crews and email a compiled list of responses from the previous day to management every morning. I created a Form from Excel Online so the responses are synced automatically. Here's the scenario:
Day #1 (midnight to midnight): crews are working
Day #2: night shift will fill out the Form covering the Activity in Day #1 (they usually submit their responses between 1am-6am of Day#2)
Day #2: At 8am of Day #2, send new responses from all crews in one single email to management team (either as an HTML table or as an Excel attachment)
I set up a recurring flow which runs every morning at 8am. Is there a way to only send the responses of the previous day? If not, how can I share share the compiled excel sheet daily?