We have a SharePoint document library which contain around 100 main sub-folders, now i want to implement a scheduled flow which loop through all the main sub-folders >> and check if each main folder contain at-least one file (of any type) >> if so to set the folder status to "Completed" >> if not (the folder is empty or contain only sub-folders) to set the status as "Pending"?
Is this possible?