Creating XLSX file in Table format from CSV

(0) Share

Report

Posted on by MH3

1,059

Hi,

I have a gallery in PowerApps in which I filter the data and then I press a button which creates a CSV table in OneDrive.

But, I want to convert it into XLSX File in Table format (Haven't found anything regarding this.)

I have used that Excel Template approach but I uploaded that file into my OneDrive root folder and then it shows the data in Table XLSX format but the other user cannot run that file because the file is not in its root folder of OneDrive. Hence the flow fails for other users.

can anyone please help me?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MH3 ,

According to your description, I did the test for you.

1\ Build a test flow

2\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
MH3 1,059 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-xiaochen-msft ,

I think I haven't cleared one thing, that I want to create an XLSX document in a Table Format.
can you help me in that? like the customer don't want to convert the sheet data in Table and then apply filters etc.

The xlsx file should be in Table format.
Example:

any Ideas?
@yashag2255
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MH3 ,

At my knowledge, the only way to create excel table is to create it manually.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
MH3 1,059 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft
Well that is correct, but I had created an excel Template by using Plumsail documentation, but the template was uploaded in my Root folder of OneDrive it was working for me, but if someone else tries to generate the report the "Get File Content" fails because the file is in my root folder and ultimately the flow fails.

Any idea how can I overcome this or any other workaround?