I'm making a flow that copies a file but the file name is fetched from a large list (10K<20K). The list restriction/threshold is 5k so I am forced to make views to stay within that threshold. How can I make sharepoint get list items using a filter on views instead of the entire list since that is impossible. Increasing the threshold is not an option.
I've tried replacing the sharepoint list name input to the list uid and full view URL provided in the view-settings for the list and even '<LIST_NAME/VIEW_NAME>' without success.