Good afternoon,
I have a flow set up where the trigger in CRM is a creation of a property in our Properties custom module.
When a new property is created, the flow creates a folder in Workdrive and a series of sub-folders using data from the CRM record.
So for example a new property is created called "123 Some Street"
A Workdrive structure in a team folder is as follows: -
(Team Folder - Properties Under Management)
123 Some Street
-- Certificates (123SS)
-- Documents (123SS)
-- Tenancies (123SS)
(The property code "(123SS)" is a field within the properties module.)
I then want to create another flow where the trigger is a new opportunity created in CRM.
So for example, if there were two apartments within 123 Some Street, a new opportunity may be set up called "Apartment 1 (123SS) - Tenant Name"
Within CRM, this opportunity would be linked to the property and therefore getting ZohoFlow to search for the property folder is fine as "property" is one of the fields within the opportunity, but I actually want the opportunity folder to be created inside the -- Tenancies (123SS) sub folder and there doesn't appear to be a way to fetch this folder.
I would need the ability to fetch a folder based on keywords, where I could fetch the main property folder and then just search for a folder containing "Tenancies" within it (of which there will only ever be one).
There doesn't appear to be a way of looking up this Tenancies sub folder and wondered if there is a custom function which would allow me to find it?
Thanks
Rich