Solved: Get a list of Folder names from Sharepoint based on criteria

Im not sure why so fundamentally simple is proving so difficult!

Im trying to retrieve a list of folder names from a sharepoint library using power automate. i have a custom column in sharepoint which is a yes/no column to indicate if its a job file and should be included in the list but i just cannot get the thing to work.

Ive tried http requests, get files (properties), everything i can think of but i just cannot get it to work.

basically we have a folder system where job files are always stored 3 levels deep from the base url:

https://company.sharepoint.com/sites/shared/Jobs/W10000+/200+/This is where files are

The /W10000+/ and the /200+/ can change but the job file is always 3 levels deep from /Jobs/

if theres a folder at that third level its marked with yes/no as yes to indicate that its a job file. my thought process was that it would be easy to filter on that column to search and return all the folders in that library and stick them in a combo box.

ive tried co pilot to guide me through steps but no use, surely there's an easy way to achieve this?

Thanks,

Categories:

General Questions