In Flow, I am able to selectively pull certain columns from the list, put them into a file, attach to an email, and then send the email. But when I click on the 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 rather than manually at the "Save As".
Here's a rough look at the Flow steps:
Step 1: Recurrence Runs at 9:00 on Friday every week Edit Step 2: Get items *Site Address: Materials and Logistics - https://g8pro.sharepoint.com/sites/MaterialsandLogistics *List Name: PAS Parts Tracker List Filter Query: An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). Order By: An ODATA order By query for specifying the order of entries. Top Count: 150 Limit Columns by View: Avoid column threshold issues by only using columns defined in a view Hide advanced options Step 3: Select *From: value× *Map Part Number Part Number× Part Description Part Description× Workflow Status Workflow Status Value× PO Number PO Number× Quantity on PO Quantity on PO× Original PO Date Original PO Date× Vendor Vendor× Next Release Quantity Next Release Quantity× Estimated Release Date Estimated Release Date× Actual Release Date Actual Release Date× Expected Availability Date Expected Availability Date× Galvanizing? Galvanizing?× Date Sent to Galvanizer Date Sent to Galvanizer× Date Expected from Galvanizer Date Expected from Galvanizer× Quantity Received Quantity Received× Date Received Date Received× Modified Date Modified× Enter key Enter value Step 4: Create CSV Table *From: Output× *Include headers: Yes *Columns: Automatic Hide advanced options Step 5: Send an email *To: firstname.lastname@example.org; *Subject: PAS Parts Tracker Weekly Report for formatDateTime(...)× *Body: Please find attached your Weekly Parts Tracker Report. Regards... Administrator From (Send as): email@example.com; CC: Specify email addresses separated by semicolons like firstname.lastname@example.org BCC: Specify email addresses separated by semicolons like email@example.com Attachments Name – 1: PAS Weekly Parts Tracker Report Attachments Content - 1 Output×concat(...)× Add new item Importance Is HTML Hide advanced options