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!

All responses (3)

Answers (0)

SudeepGhatakNZ 14,318 Most Valuable Professional on at

Like (1)

Report

Re: PowerApps Collection to Reoccurring Excel File using Power Automate

@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
Pstork1 66,174 Most Valuable Professional on at

Like (1)

Report

Re: PowerApps Collection to Reoccurring Excel File using Power Automate

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.
madiiiiip 2 on at

Like (0)

Report

Re: PowerApps Collection to Reoccurring Excel File using Power Automate

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