I am planning to fetch first top level all folders from Doc library in dropdown and based on the selection from 1st Dropdown show the second level libraries in 2nd dropdown (show 2nd dropdown if folder exists else show all files in second level library if again files exists) in the gallery.
If we have 3rd level libraries again same show dropdown else show files else no dropdown should be visible. It goes on based on the level of sub folders.
But for to show the top level folders i receive this delegation message.
Filter(Documents, 'Folder path'= "Shared Documents/" && IsFolder=true)
Message : Delegation Warning, The highlighted part of this formula might not work correctly with column "Folder path" on large data sets
Message: Delegation Warning, The "Filter" part of the formula might not work correctly on large data sets.
