Answered

Generating an Excel with Data from PowerApps

(2) Share

Report

Posted on by j-steinkamp

Hey there,

I've created a kind of Order List for components of a camera system. This list is made of Text for the amount of parts and 10 forms for the names and serial number of the parts. Is it possible to create a function where you can create an excel table with the data from the text fields and forms which could be downloaded by the user after he finisched his Configuration.

Best Regards

Jannes

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

KeithAtherton 3,707 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @j-steinkamp,

An option would be to call a Power Automate flow from your Power App, and populate a table in an existing Excel document with the data.

Check out the Excel Online (Business) connector, Add a row into a table action: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#add-a-row-into-a-table

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
j-steinkamp 31 on at

Like (1)

Report
Copy link

Link copied!

Yeah I've read about this option but I want to create an own excel document with every configuration and not just add a table to an existing document.
Is there an possibility with PowerAutomate to do this?

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,707 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

There are options to create new files using Power Automate, depending where the file needs to be stored.

Here is one example: https://www.youtube.com/watch?v=RB_ySjhm9Sg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No