Get files (properties only) returns files and folders, and allows you to add a Filter query, so this is what I'd use to find the folder based on a name.
For this example, I've got the following folder structure and will try to find the folder with the name "XYZ Corp".
See full below. I'll go into each of the actions.
For this example I've used a Compose that contains the folder name we want to find.
Get files (properties only) returns all folders where the folder name is equal to the folder name we are looking for.
//FSObjType eq 1 means only return folders (not files)
//FileLeafRef refers to the folder name
FSObjType eq 1 and FileLeafRef eq '@{outputs('Compose')}'
Condition checks to see if a single folder was found by checking the length of items returned.
length(outputs('Get_files_(properties_only)')?['body/value'])
If only one folder found, then we go into the Yes branch and retrieve the properties we want. In this example, I've just used another Compose to retrieve the Full Path.
//Gets the first item returned and retreives the value for FullPath
first(outputs('Get_files_(properties_only)')?['body/value'])?['{FullPath}']
If I ran the flow, the output from Compose Full Folder Path would be:
If you wanted a different property value, then you could chose from any of the ones below that suit your requirement. This is just a sample set of properties/data returned from my flow.
{
"ItemInternalId": "120",
"ID": 120,
"Modified": "2023-11-05T00:51:37Z",
"Created": "2023-11-05T00:51:37Z",
"{Identifier}": "Shared%2bDocuments%252fFolder%2bA%252fFolder%2bB%252fXYZ%2bCorp",
"{Link}": "https://xtrdev.sharepoint.com/sites/PowerAutomateExamplesV1/Shared%20Documents/Folder%20A/Folder%20B/XYZ%20Corp",
"{Name}": "XYZ Corp",
"{FilenameWithExtension}": "XYZ Corp",
"{Path}": "Shared Documents/Folder A/Folder B/",
"{FullPath}": "Shared Documents/Folder A/Folder B/XYZ Corp",
"{IsCheckedOut}": false,
"{VersionNumber}": "1.0"
}
