web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Generate Excel File
Power Apps
Unanswered

Generate Excel File

(0) ShareShare
ReportReport
Posted on by gikido 1,028

Good morning;

I created an application that works as follows:

when the employee has a mission order he must fill in information that will be generated in an excel file as shown in screenshot 1.

 

After his return they must complete the entry of information as indicated in screenshot 2 and the final excel file will be generated.

for travel expenses each employee enters what has been spent and he can leave the other boxes empty.

 

Data is stored in dataverse

 

How can I do this please?

Capture ecran 1.png
Capture d ecran 2.png
Categories:
Building Power Apps
I have the same question (0)
  • mmollet Profile Picture
    mmollet 3,187 on at

    You will more than likely want to use Excel Online for Business connector and Power Automate to do this. Create a template excel doc in SP/OneDrive and use that to build all the other sheets off of. You can fill the excel table by getting data from the Power App user, a SP List, another excel sheet, or a combo of all them. Here is a general step order for this:

    Decide where your data that will go into the excel sheet is. For me it was in SP so I could skip this step and go to the next one as I can access the data in a SP List from Power Automate rather than pass it from powerapps. If you need to pass data from powerapps to a flow then start there by deciding what data (array?, json?, strings?) needs to get passed into the flow. 

    Next you can start making your flow. This is where you will want to make sure that you are capturing the correct data regardless of where it is from. You can use Get Items SharePoint connector to get items, filter them, and sort them all in one step or you can use the Parse JSON function to get the data out of the JSON object you send from Power Apps etc. 

    Now that you have your data you will want to want to add these steps next to get your excel template copied to a new file and start inserting your data:

    1. Get a file from SP/OneDrive -> get your file content from your template here
    2. Create a new file in SP/OneDrive -> create a new file (.xlsx at end of name) using body of previous step as content
    3. Add your datat to the excel table on that document (can use compose function to build the row you are going to add to the excel table then simply add a row to an excel document and pass in that compose object)
    4. Once all your data is added you will have a file that you can email or print etc. 

     

    Example:

    Screenshot 2023-05-15 at 8.48.16 AM.png

     

  • gikido Profile Picture
    gikido 1,028 on at

    @mmollet  thank you for your answer

     

    the problem is that the second array is in canvas form. so for example an employee entered the details of catering expenses and taxi; and the other entered the details of the tramway when I want to fill in the excel file how then fill in the exact box.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans