8
Dears,
I have following issue: We have an excel file with a lot of data updating everyday. There is a column "Date".
I need to create a flow which checks everyday (recurrency flow already created), if column "Date" matches for today's date, the other columns should be extracted and send as attachment by email to recipients.
At the moment I cannot save these data as an attachment
thank you very much!!!!
Hi,
Thank you for your reply. Flow is working well, I received an email with excel attachment, however as you can see from attachment it has extracted all data, instead of today's data. Maybe there is some error in function formatDate? Email and output
Filter array and Create CSV
Result
Section
I basically gave you everything you need in the reply above. But here is the full flow.
1) Trigger the flow manually and then do a List Rows in Table from your file. Make sure to set the Date Format to ISO 8601
2) This next thing is an optional step, but if you don't do it you'll end up with an extra column with a GUID in it. Do a Data Select to choose and Map only the columns you want in the file.
3) Filter the output of the data select . The Left side is the Date Column from Excel, the comparison is StartsWith and the Right side is formatDateTime(utcNow(),'yyyy-MM-dd')
4) Use the output of the Data Select to Create a CSV Table.
5) Send the Email. Fill in the File Name with something appropriate and use the output of the CSV table as the file content.
If you click on the .csv file extension in the email it opens in Excel.
please show me how to do this by example, How to make today's dates read from excel and send as excel attachment by mail?
Instead of the Create HTM you can either use Create CSV to create a CSV file and send that or actually create another worksheet, create a Table and add the array as rows. Creating the CSV is much easier and it can be opened directly in Excel.
Thanks for your reply. List rows is working properly. But I need to extract the data as an excel file attachment not HTML. Do you have any idea how to do it?
There are a couple of things you need to do to make this work.
1) In the List Rows action you need to set the date format to ISO 8601. (See last field in advanced)
2) UtcNow will contain the current time in addition to the date. So you need to use a FormatDateTime() to filter that out.
Share
Report
All responses (
Answers (
formatDateTime(utcNow(),'yyyy-MM-dd')3) The date column value will also contain a time element pointing to Midnight if your Excel column only had the date. So the ISO 8601 value will look something like this. '2023-12-04T00:00:00.0000Z'. So your comparison needs to be StartsWith, not Equals.
4) Once you have the Filtered array you can use a Select to get the columns you want and then a Create HTML table to get the output you want in the email. Loops will not be necessary.
This is my current flow
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,026
Most Valuable Professional
