Hello All,
Thank you for reading today and thank you in advance for your help/insights - it is much appreciated!
What I need to do is take two collections and export them into an Excel file.
My scenario is that I am building a timesheet application as seen here:
The user inputs information into the gallery and I am using a "ForAll( Collect " on those selections/inputs to store them into a collection. I then want to take those collections and have Power Automate transform them into Excel files or if possible just take the combo boxes and save their selections to a newly created Excel sheet.
A more detailed rundown of what is happening:
So the reason I have two collections is because there are two aspects to this timesheet app. It functions as a timesheet for both employees
and equipment
- the stacked rows will be invisible to the end user as they are automatically filled with info that relates to the first combo box - I just have those there while developing. The two galleries, one for equipment and one for employees populate two different collections with this:
and the corresponding collections look like this:
and this
The app's data source is Dataverse and I also have a page that allows the management of those data tables that look like this:
Ideally, the two collections are then compiled through a button push into two separate Excel files that an administrator would then email directly to payroll.
I had them collected into collections purely because I thought that was what I had to do to deliver them to Power Automate. If I can accomplish this in a more simple way that would be awesome!
Thank you!
