Sending Daily Morning Reports

(0) Share

Report

Posted on by tezzeldin

Hello Flownauts!

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?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @tezzeldin

If in your Excel file you've stored the submission response date, you could filter the items in Excel using an expression:

Where the expression would be:

@and(less(item()?['Request Date'], formatDateTime(utcNow(), 'yyyy-MM-dd')),greater(item()?['Request Date'], formatDateTime(addDays(utcNow()-1), 'yyyy-MM-dd'))

Which basically checks that the date (Request date column in this example) is greater than yesterday at 0h, and less than today at 0h.

After that, you would create the html table and send it by email.

Be careful when getting the rows of excel and using the ISO 8601 Date format!

Hope it helps!

Ferran

Was this reply helpful? Yes No