Power Platform Community Forum Thread Details

I'm using a few excel connectors to automatically update a report via apply to each but the flow is processing extremely slow. In my flow I list rows present in a table for my report and for the report containing the data used to update my report. My report has around 300 rows and 18 columns. The other report has roughly 3000 rows but only a few columns. I then place an apply to each over my "update a row in a table" connector where I hammer out a few if statements for each column to control the conditions for what should be displayed on my report. I then match column "Colleague" with the other report's column "Employee" to ensure that my rows are lining up with the correct data. Everything works mostly, (I still have a few columns that just never seem to update and I'm completely lost as to why) but man is it slooooooow. It takes several hours for the flow to finish. When it finishes I still have a few columns left over to manually update but honestly it's far faster than it was when I was having to manually enter the data. I'm just curious as to why this flow takes so long. I know one of the spreadsheets is relatively long but I wouldn't think it would be a problem for a computer to scan through since it's only a few thousand rows. I am having to do an apply to each for both reports since my if statements need to leave each column in its original state if the primary condition checks false and the only way I have found to do this is to have the "else" part of my if reference back to the original cell in the column/row. I tried doing if where the else was left blank but I kept getting the "expected 3 parameters only received 2" error, and if I set it to false it actually entered the word false onto my report.

Maybe there is a more efficient way to accomplish what I'm doing? One that takes a fraction of the time and doesn't skip over any of my columns?if(contains(items('Apply_to_each_skills')?['Characteristic'], 'sub_cat'), items('Apply_to_each_skills')?['Current Rating'], items('Apply_to_each_comp')?['sub_cat'])