I can pull only the list fields I need, put them into a file, attach to an email, and then send the email. But when I click on the eMail attachment it won't open in Excel. If I try to "Save As" and then open with Excel, it puts all columns into the "A" column on each row. But... if I add ".csv" when doing the "Save As" and double-click the saved file, it will open correctly in Excel.
I want to add the file extension .csv automatically in the Flow rather than have the user enter it manually at the "Save As".
Any ideas?
Bill
Hi @wslayton , i see you in other thread 😄
First, thanks to open a new thread, this helps the community!
We have a trick to use dynamic content + expressions7
To complete your quest you can use this expression in Attachament name:
concat(triggerBody()?['Title'],'.csv')
In this case I concat the Title of item that triggered Flow, (using in this sample SharePoint 'When an item was created' trigger)
Best Regards,
Gustavo Moraes
Community Super User
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. And give me a kudo to make me more happy!
Gustavo Moraes, o astronauta brasileiro do Flow!
User | Count |
---|---|
61 | |
52 | |
48 | |
28 | |
18 |
User | Count |
---|---|
26 | |
26 | |
24 | |
22 | |
21 |