I am building a data and metrics sharepoint for my organization. The main goals are to report metrics with powerbi, integrate power apps for users to review material and determine action on them. I have a flow mapped out that I would like to know if it is possible below.

Step 1: 500k lines of excel CSV data are saved on the sharepoint one drive

Step 2: power automate grabs the file and chunks out the data to to SPO lists based on material location (25 separate locations)

Step 3: power automate feeds data to already build power app where first level material owners mark what to do with the material (3 options)

Step 4: power automate grabs all 25 separate lists and chunks them out again based on second level ownership (15 options)

Step 5: repeat step 3 with second app for final approval of material action

Step 6: power automate grabs all 15 lists puts them into excel appends them together and feeds powerbi dashboards

I do not currently have access to premium space only pro versions of the software.