Unable to receive Excel File and How can i create new Excel File in OneDrive

[HashamKhalid786]

Hi Everyone,

Currently I am working on Power Automate Project, I have already created My Flow Model.

I am facing couple of issues, Kindly please help me to find out the way to solve this issue.

Short Description of my Model: When I receive a new email with (PDF)  -> Get some specific details from that pdf and save in Excel sheet on OneDrive. Automatically that Excel Sheet send it to me. My Flow is working but facing 2-3 issues.

Problems are: When I receive Excel Sheet it doesn't open with excel extension, if I send same PDF file in Auto email generate it works perfectly.

Another issue is, how can I create every time a new Excel Sheet on Cloud instead of different worksheet in the same Excel File on Cloud?

I have attached my Flow Model.

[ArchitectMadhan]

Hi @HashamKhalid786 ,

In the Excel file creation process, please check whether you are using the below thing.

Step:1 Add the rows to existing excel file used a template (in this example the template I have used TaskBook.xlsx)

Step:2 After adding all the rows to the table in the excel file (template), copy the entire content.

Step:3 Creating a new excel workbook dynamically in the SharePoint Document Library.

Hope the above steps will be helpful for you to create a excel file with correct file extension. You can also add new worksheet in the existing excel workbook, Instead of creating new excel workbook every time.

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.