Unanswered

Power Automate Creates Corrupt SharePoint Excel Document

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

my flow consists of the triggers to gather the results from a submitted FORMS (MS FORMS), then there are two parallel actions, one is to load the result onto excel file (which is an audit trails to record all submissions from forms - used lated on as source of data for PBI dahsboard), the other one to create a separate excel file xlsx as an individual file for each person submitting the form.

All seems to be working fine, files are being created and updated BUT the excel that gets created cannot be opened as I get an error:

This workbook couldn't be opened because the file format may not be matching with the file extension.

I have properly defined the data objects to be retrieved from results so just for the testing purposes, I am taking employee first name and last name, this should be included within a file created as an excel. Perhaps I should consider not only creating a file but defining a table with headers within a file?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

First make sure that when you create the file you are adding the .xlsx extension to the filename.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It is there actually, so basically it names the files using two objects + adding an extension xlsx

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

1) you should probably Concat() those values to make sure you don't get any extraneous spaces.

2) You can't create an Excel format file by just dumping values as the content. What you are doing will create a .TXT file, not an .xlsx. You can create a .csv file that can be opened by Excel. Here's an article on how to do that.

Quick way to export SharePoint list to Excel file using Power Automate (tomriha.com)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello

thank you for your prompt reply.

I have realized that instead I can just automatically create an entry into the sharepoint list and then I can manually export it as excel/ csv.

Do you think I can automate this to generate the csv/ excel when new entry is added but as a document with single line of text for new entry only (separate document for each new entry).

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

You won't be able to automate that with SharePoint alone. The export is manual only. YOu can do it using a flow if you create the file as a CSV instead of an xlsx

Was this reply helpful? Yes No