Hello all,
I have been struggling with this and can't find a solution.
I have 2 dataverse tables for 'customers' and 'sites'.
Each site is unique and belongs to it's specific customer. Customers can also have multiple sites.
My 'site' table contains a column 'customer name' referencing the customer it belongs to.
I would like to create sharepoint folders for each customer. Inside each customer folder, subfolders of that customers unique sites.
Example,
Customer Name A /Site A
/Site B
/Site C
Customer Name B/Site D
/Site E
I am starting with get rows from my 'site' dataverse table, then creating folders based on 'customer name'.
When i try and create subfolders for 'sites' in the relevant customer folder, i either get all site folders in all customer folders, or all site folders in just a single customer folder.
Thanks in advance....