Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Convert CSV file from Outlook email to XLSX file and create table

Posted on by 32

Hi Everyone, I'm working on this flow as everything seems fine with Office Script. However when I run the flow, the file won't able to convert to XLSX. I have a large CSV file from email and would like to convert that into XLSX file and store in Sharepoint. I created an empty XLSX file format and use that in "get file content" step. 

 

Any help or suggestion please? Many thanks!

 

Compose:    

split(base64ToString(items('Apply_to_each')?['contentBytes']),outputs('LineBreak'))
 
anhtrg852_0-1693512837380.pnganhtrg852_1-1693512891810.png

 

anhtrg852_4-1693513016446.png

 

 

  • takolota1 Profile Picture
    takolota1 4,754 on at
    Re: Convert CSV file from Outlook email to XLSX file and create table

    @biboy852 

     

    You can try this template that doesn’t rely on scripts: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard