Answered

Sharepoint list auto export to excel

(0) Share

Report

Posted on by Community Power Pla...

Would anyone have a flow suggestion that will, in Powerapps, when a button is pressed, that the data from my SharePoint list could be exported to an excel workbook and then send the excel file as an attachment in Outlook?

Categories:

General topics

I have the same question (0)

All responses (33)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @Anonymous,

I have made a test on my side and the flow works well. Please take a try with the following workaround:

Use Get items to get all the items, then configure the insert row, and insert the contents of the corresponding field of the list item into the corresponding Excel table.

Configure Get file metadata/Get file content to get the file name and file content respectively.

Configure the content obtained above in Attchments.

Image reference:

Please take a try.

Best Regards,

Barry

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

Like (0)

Report

@v-bacao-msft Thank you for the tips! Do I need to have an excel workbook already created?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Anonymous,

Yes, you need an Excel file that has already been created, which needs to contain an Excel table.

Best Regards,

Barry

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Anonymous,

Have you tried the workaround I provided? I want to know if this will help you.

Or you need further assistance, please feel free let me know.

Best Regards,

Barry

Was this reply helpful? Yes No
dkent 33 on at

Like (0)

Report

I was attempting your solution but for some reason I do not have an action to insert row. I only have the following excel actions,
DO I have the wrong license?

DWTK

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

Like (0)

Report

@dkent look for Excel Online (Business) - Add a row into a table

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

Like (0)

Report

I'm stuck on this part (see image):
I chose OneDrive Business for Location (I assumed it wanted a local location to store the excel!?)
I chose One Drive as Document Library (same logic as above)
Now comes the tricky part .. at File ... I assumed I would choose the (already created excel file, on my onedrive) excel file that will be used to deposit the list's items (but no... i have to choose some nonsense "files" that appear there)
For Table whatever i chose i got an error.
How do i go about just : get the items of the list and dump them into an Excel file stored locally!?

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

Like (0)

Report

@Anonymous I suppose the file you want to write to already has a table in it. But of course you first need to find it
Do you have multiple libraries in your OneDrive (like me, I just made a test, as I normally use SharePoint)?

If you try each of them, you may find what you're looking for.
Another explanation is that you have too many files in the root directory of your OneDrive.
I had this issue in a flow of mine (it still worked, but when wanted to change the file, I couldn't find it in that browse list). It seems there is a limitation of how many files it can retrieve. It turned out that there were more than 256 files in my folder. After deleting enough of them, I could find the file again. So I suggest you cleanup your OneDrive root folder by deleting files or moving them into a folder. Please let me know if this did the trick.

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

Like (0)

Report

You are correct. I had 2 'OneDrive' choices (i assumed it's just a mistake). Choosing the second one, did the trick.
I did create an Excel file, I did create a table (keeping default naming Table1). I even put my headers inside the table.
Next issue ... the flow doesn't pull all data and for some columns instead of values (text, numbers, etc) .. i get some stuff with {} and @

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

Like (0)

Report

How to fix this? I get these instead of the actual value ... it happens for more columns

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":8,"Value":" Healthcare"}

Was this reply helpful? Yes No