Answered

Convert "Creste CSV Table" output to Excel file

(0) Share

Report

Posted on by rkadey

I have a list of excel items. I used filter array to filter the list based on certain criteria. Now I want the filtered result sent in an excel file to a mail.

What I did was to create a csv table from the filter array input. How do I convert the output to an excel file?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rkadey
You can try to send email directly after creating csv table.
I created a simple Flow, you can refer to as below:
This is my test list, I will filter out which date is equal to 7/16/2021 and send an email with attachment.
Flow in details
After flow runs, I will receive an email as below, the attachment can be open use excel.
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
rkadey 66 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-LilyW-msft . Your solution works but the results does not fall into a table. it still gets separated with a comma.

Was this reply helpful? Yes No
rkadey 66 on at

Like (0)

Report
Copy link

Link copied!

@v-LilyW-msft I have sorted it out. Thanks so much.
Apparently you have to add ".csv" to the name.

Was this reply helpful? Yes No