OK, now I understand a little more. Here are some additional questions.
How do you manage if an entry in your list was deleted? You don't have any step to delete items that are in the vendors list but not longer in the Dynamics table.
How do you manage new entries in the lookup table/list?
What logic is in the compose steps?
What else did you change from the first screenshots? It looks like "Get legal entities" is also in an "Apply to each".
If you want to sync the table maybe it would be better to create a trigger that checks if an item is created, modified or deleted. In that case you would immediately have a sync and not wait for the scheduled job.
But of course you can also do it your way to always sync everything. In that case I would suggest that you only search and sync data that is really needed to be synchronized. You could load the complete sharepoint lists and compare it to the dynamics tables. I think this would be possible with only one select action.
So in my opinion it is possible to shorten the flow from 10000 of actions to only a view. But to do this you would have to rebuild it. If this is too much challenge we could of course also have a look at the other steps inside the loop and I'm sure it is possible to get rid of some of them without changing the current logic.
