You’re offline. This is a read only version of the page.
Announcements
I need to combine data from the same cells from daily reports these reports are hosted on a company share drive and I need to put them into one master excel file. I need to go through the last 4 months worth of reports.
Hi,
To combine data from the same cells from daily reports hosted on a company share drive and put them into one master Excel file, you can use Power Automate. Here are the steps you can follow:
Use the “List files in folder” action to get all the daily reports from the company share drive folder.
Use the “Filter array” action to filter out the reports that are older than 4 months.
Use the “List rows present in a table” action to get the data from each report.
Use the “Append to array variable” action to append the data from each report to an array variable.
Use the “Create table” action to create a table from the array variable.
Use the “Create file” action to create a new Excel file in the company share drive folder.
Use the “Add rows to a table” action to add the table data to the new Excel file.
Here are some best practices and considerations you should be aware of when implementing this workflow:
Use the “Filter array” action to filter out the reports that are older than 4 months. This will ensure that only the relevant reports are processed.
Use the “List rows present in a table” action to get the data from each report. This action can handle structured and unstructured data.
Use the “Append to array variable” action to append the data from each report to an array variable. This will make it easier to create the table.
Use the “Create table” action to create a table from the array variable. This will make it easier to add the data to the new Excel file.
Use the “Create file” action to create a new Excel file in the company share drive folder. This will ensure that the new file is created in the correct location.
Use the “Add rows to a table” action to add the table data to the new Excel file. This action can handle structured and unstructured data.
Br,
Gill
Share
Report
All responses (
Answers (
372
