Hi,
I am looking to create a flow which can run every monday using recurrence and then export a list to excel, once exported, send an email with this excel file as an attachment, is this possible to automate?
Thanks in advance.
You need to import the CSV data into a new Excel workbook in order to view the content correctly; see Import or export text (.txt or .csv) files - Microsoft Support
Can you expand each step so that we can see what you did? Thank you
@luuminhvuong93 Agreed! Just making sure I was not missing anything.
Current, ignore the error when opening the XLS.
Still better than export to CSV
Hello. This works except that when people try to open the spreadsheet from the email, there is an error message:
Message Rec'd When Opening Created Spreadsheet
If I click "Yes" the spreadsheet does open. Also, all the spreadsheets created through this flow will not open within SharePoint, I have to download them to the Excel App to view them.
Is there something more I can do to clean up the results of this flow? Thanks.
Maybe the information in this question and answer chain is outdated, but I used the instructions at https://flow.microsoft.com/en-us/blog/automate-sending-weekly-reports/ to get data from a list, created a spreadsheet file, save spreadsheet to a SharePoint library, send an email to the designated email addresses with the spreadsheet attached to it, and to do all of this on a regularly reoccurring schedule. The link provides instructions on how to create the spreadsheet file in OneDrive, but I was able to easily adapt it to SharePoint by switching out all of the OneDrive locations to SharePoint locations.
Hi! Thanks for this answer. It was very useful, but I Have a question about it: When I Open the .CSV file in Excel it brings a lot of data delimited with ",". When I tabulate the columns all the data are disorganized. It seems to came with the data field some sort of URL for each data input. Am I doing something wrong? Is the a way to edit the format?
I Can´t add a photo with this because the file contains an URL.
@vsolanon please review the accepted answer, currently CSV is supported on the flow side. Give it a try and let me know in case of issues.
Hi @Anonymous ,
I was wondering if you were able to find a solution for this. I am currently looking for the same approach.
Thank you in advance!
Veronica
Hi @Anonymous ,
As you mentioned, .xls or .xlsx are not available.
It is possible to Create file in SharePoint library instead of OneDrive.
Besides, you could also try with action Create csv table. Then create a csv file in the SharePoint library likes below.
Best regards,
Mabel
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional