Auto Export Excel Report From SharePoint List

(0) Share

Report

Posted on by WayneS84

Hello

Having issues here!

I would like PowerAutomate to get items from a SharePoint list, create an Excel file, then create a table in the excel file and populate the table with filtered information from the SharePoint, then attached it to an email and send it daily.

I can't seem to get it to work, however. The file output is not readable, it spits out multiple files, it's a mess!

Can anyone please offer some help?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (1)

Report

Hi @WayneS84
According to your description, you want to export SharePoint List data to excel and attached it to an email.
You can create a csv table first, then create a csv file, and finally send the csv file to an email, it will be easier.
You can take a try with the screenshots as below:
This is my list
Flow in details:
After flow runs the file will be created in Sharepoint and recipient can receive an email.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
WayneS84 13 on at

Like (0)

Report

Thanks this is working!

One more thing however, how can I filter what goes into the .csv, so for example I only want items that match certain criteria?

Was this reply helpful? Yes No
Sakthisp87 9 on at

Like (0)

Report

What should i do if am going to filter the data based on the people picker column and send an exported csv to same as people picker person.

Was this reply helpful? Yes No