Generate Excel File

[gikido]

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?

[mmollet]

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:

[gikido]

@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.