Hi @martinnpenn1 ,
Sorry for the incomplete explanation in the previous message.
Step 1: initialize variables
You will initialize 2 array variables in the beginning of your process. You just have to go to the top of the flow, place your cursor on one of the arrows that connect 2 actions, and then click on the '+' when it appears.
Once you do this, you will look for the 'Initialize variable' action, and after click it, select the type of the variable as 'array'. Feel free to name them by your convenience and you do not need to assign any 'value' to the variables:
Step 2: Append general array variable
You have two nested loops in your process: 'apply to each' (external loop) and 'apply to each 2' (internal loop). Inside the internal loop, you have a condition, where you check if the file name matches with the name contained in your Excel table. inside this internal loop, but before the condition you will add an 'append to array variable' action (be careful, because there is also an 'append do string variable'). If you do not see the '+' icon as in the image from the 1st step, you can click in 'add an action' and then just drag and drop it to before the condition:
Once you add your 'Append to array variable' action, you will select one of the arrays variables that you created in step 1st and, in the value, add the dynamic contents from the Onedrive file name and the Excel table file name column (the same dynamic content that you inserted in your conditional action).
To make the array reading easier in the future, I recommend you to add a '-' between the 2 dynamic contents.
Step 3: Append to the individual array
Using the other array, you can repeat the step 2, but this time placing the 'append to array variable' function inside the 'if yes' block from your condition. Instead of passing the both dynamic contents to the value, you can pass only one of them (as they may be identic, it is irrelevant which one you will select).
Step 4: Show the outputs from both arrays
There are several ways to check the output from the arrays. One easy way to do it is to assign the array variables to 'Compose' actions. You will add this actions at the end of your flow, out of all the loops (internal and external).
The process is the same of adding any other action and your input will be each array variable (our goal here is just to make the output from these variables easier to read after the dozens of loops):
After the composes, your flow is ready and you can run it. Once you run it, check the outputs from the compose actions (the same way that you did to check the outputs in the previous messages) and you will be able to check in the arrays (especially in the general one) if there is any unexpected value.
Let me know if you need any additional clarification on the process.
