Hi,
I have the following flow which is working well;
Short explanation of what is happening;
1 - Connect to Excel table and get the rows
2 - Loop through each Excel row using Apply to Each (Set to Parallelism)
3 - Condition - for each row check if the 'Expiration date' field is equal to the current date
4 - If so, Start an approval process
5 - If response is Approved, then the comments provided are then sent back to the excel table in a field called 'Comments'
Hope that makes sense. Everything is working well, but the problem I have is that the degree of Parallelism is set at 50 within the Apply to Each function, yet I could possibly have from 1-100 possible rows returned when the Expiration Date is compared with the current date.
I have seen many posts regarding the limit of 50. However, I thought that perhaps I could split the processing if over 50 rows were returned. For instance, I could have 2 duplicates of the Apply to each loop described above. Then there could be a condition that says if the rows exceed 50, then jump to the other Apply to Each loop and process the rest there. I understand that this may mean moving the condition that compares the dates, outwith the Apply to Each.
I have looked into using variables to count the number of rows returned and loop through etc, but I'm getting nowhere with it. Any suggestions?
Thanks
