Unanswered

PowerApps Collection to Reoccurring Excel File using Power Automate

(0) Share

Report

Posted on by madiiiiip

I created a Power Automate flow to create a new excel file every time my PowerApp runs. It works great except the data in the excel sheet is not formatted. How do I format the data and make it look nice?

The newly generated excel files look like this:

current current

I need them to look like this:

what it's supposed to look like

This is my current flow:

flow flowHelp! Thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

madiiiiip 2 on at

Like (0)

Report
Copy link

Link copied!

@Nived_Nambiar @SudeepGhatakNZ @Pstork1 @ManishSolanki @Rhiassuring - Help Please!

Was this reply helpful? Yes No
Pstork1 69,383 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Unfortunately, you can't do that using .csv A comma delimited file is always going to read as a single set of rows when opened in Excel. To do what you want you'll need to use a sample empty Excel file, then a Create Table for each of the five tables in your spreadsheet. Then Add rows to each table with the values you want. Its doable, but timing can be an issue and it will be fairly complex.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@madiiiiip ,

Does the format need to be Excel? Can it be PDF instead?

You can render the report in PowerApps and use the Print or PDF function to export it in PDF.

Print function in Power Apps - Power Platform | Microsoft Learn

Work with the PDF function (experimental) - Power Apps | Microsoft Learn

Was this reply helpful? Yes No