Building Excel Reports with PowerAutomate

We need to develop an automatic process, trigered manually, in PowerAutomate that:
- Reads data from excel rows.
-- This excel file (DataOriginExcel) is placed in sharepoint.
-- The process will read data from different tabs.
-- The process will filter info by project code (field of excel).
-- The process will discard info if report field (field of excel) is already fullfilled .


- And generate a new excel file with the info of previous data read from the excel rows.
-- This excel file (ReportExcel) will be placed in sharepoint.
-- This new report file will be crated from a ReportExcel template placed in sharepoint.
-- The name of this new report will be with determined format. "IYYMM-PROJECT_CODE.XLSX".
-- Process will create ad much report files as differents project code are readen in DataOriginExcel.
-- Process will fullfill info from DataOriginExcel to ReportExcel row by row.
-- After info from a from is registered in ReportExcel, the process will fullfill automatilly Report field of the
readen row on DataOriginExcel with the name of the report Excel. Additionally process will create
hiperlink on report field with the report file on sharepoint.
-- Process will have to add rows on ReportExcel if neccesary.

Attached example of files:
- DataOriginExcel.
- Example of a Report file.

Thanks for your interest.

Note. If work is executed properly. Future works will come in PowerApp, PowerBi, M365 and Azure.

Regards.

Raúl SGI.