Power Platform Community Forum Thread Details

Hi,

Step 1: Initialize Variables

Actions:
1. Initialize variable - SiteURL (String)
2. Initialize variable - LibraryNames (Array) 
3. Initialize variable - TargetDSContentType (String): "Document Set"
4. Initialize variable - ProcessedCount (Integer): 0
5. Initialize variable - ErrorLog (Array)
6. Initialize variable - SuccessLog (Array)
7. Initialize variable - CurrentLibrary (String)

Step 2: Process Each Library

Apply to each - LibraryNames:
  Set variable - CurrentLibrary: @{item()}
  
  Get files (properties only):
    - Site Address: variables('SiteURL')
    - Library Name: variables('CurrentLibrary')
    - Folder: / (root)
    - Include Nested Items: Yes
    - Limit: 5000
    
  Apply to each - Files:
    Condition - Check if Document Set:
      @equals(item()?['ContentType'], variables('TargetDSContentType'))
      
      If Yes:
        - Call Child Flow: "Process Document Set"
        - Pass Parameters: SiteURL, LibraryName, ItemPath, ItemName

Flow 2: Process Document Set (Child Flow)

Input Parameters:

SiteURL (String)

LibraryName (String)

ItemPath (String)

ItemName (String)

Flow Logic:

Step 1: Try Direct Conversion

Actions:
1. Initialize variable - ConversionSuccess (Boolean): false
2. Initialize variable - OriginalDSPath (String): @{parameters('ItemPath')}
3. Initialize variable - OriginalDSName (String): @{parameters('ItemName')}

Try Block:
  Update file properties:
    - Site Address: parameters('SiteURL')
    - Library Name: parameters('LibraryName') 
    - Id: triggerOutputs()?['body/ID']
    - Content Type: "Folder"
    
  Set variable - ConversionSuccess: true
  
  Append to array - SuccessLog:
    - Message: "Direct conversion successful"
    - Item: @{parameters('ItemName')}
    - Library: @{parameters('LibraryName')}
    - Timestamp: @{utcNow()}

Catch Block:
  Set variable - ConversionSuccess: false

Step 2: Fallback Method (If Direct Conversion Fails)

Condition - Check ConversionSuccess:
  If No (false):
    
    # Step 2a: Get all items in Document Set
    Get files (properties only):
      - Site Address: parameters('SiteURL')
      - Library Name: parameters('LibraryName')
      - Folder: @{parameters('ItemPath')}
      - Include Nested Items: Yes
    
    # Step 2b: Rename Document Set
    Update file properties:
      - Site Address: parameters('SiteURL')
      - Library Name: parameters('LibraryName')
      - Id: [Document Set ID]
      - Name: @{concat(parameters('ItemName'), '_OLD_DS')}
    
    # Step 2c: Create New Folder
    Create new folder:
      - Site Address: parameters('SiteURL')
      - Library Name: parameters('LibraryName')
      - Folder Path: @{parameters('ItemPath')}
      - Name: @{parameters('ItemName')}
    
    # Step 2d: Move All Content
    Apply to each - Items in Document Set:
      Condition - Skip if it's the Document Set itself:
        @not(equals(item()?['ContentType'], 'Document Set'))
        
        If Yes:
          Copy file:
            - Source Site: parameters('SiteURL')
            - Source Library: parameters('LibraryName')
            - Source File: @{item()?['Path']}
            - Destination Site: parameters('SiteURL')
            - Destination Library: parameters('LibraryName')
            - Destination Folder: @{concat(parameters('ItemPath'), '/', parameters('ItemName'))}
            - Overwrite: Yes
          
          Delete file:
            - Site Address: parameters('SiteURL')
            - Library Name: parameters('LibraryName')
            - File: @{item()?['Path']}
    
    # Step 2e: Delete Old Document Set
    Delete file:
      - Site Address: parameters('SiteURL')
      - Library Name: parameters('LibraryName')
      - File: @{concat(parameters('ItemPath'), '/', parameters('ItemName'), '_OLD_DS')}
    
    # Step 2f: Log Success
    Append to array - SuccessLog:
      - Message: "Fallback conversion successful"
      - Item: @{parameters('ItemName')}
      - Library: @{parameters('LibraryName')}
      - Method: "Rename and Move"
      - Timestamp: @{utcNow()}

Flow 3: Advanced Nested Document Set Handler

For handling nested Document Sets specifically:

Flow Name: "Nested Document Set Processor"

Trigger: Manual or Scheduled

Actions:
1. Initialize Variables:
   - ProcessingQueue: []
   - CurrentDepth: 0
   - MaxDepth: 5

2. Get All Items with Hierarchy:
   Get files (properties only):
     - Include Nested Items: Yes
     - Filter: ContentType eq 'Document Set'
     - Select: Id, Name, Path, ContentType, ParentPath
   
3. Build Processing Queue:
   Apply to each - Document Sets:
     Compose - Depth Calculation:
       @length(split(item()?['Path'], '/'))
     
     Append to array - ProcessingQueue:
       - Id: @{item()?['Id']}
       - Name: @{item()?['Name']}
       - Path: @{item()?['Path']}
       - Depth: @{outputs('Compose_-_Depth_Calculation')}
       - ParentPath: @{item()?['ParentPath']}

4. Sort by Depth (Deepest First):
   # Process deepest Document Sets first to avoid conflicts
   
5. Process Queue:
   Apply to each - Sorted Items:
     # Call Document Set Processor Flow
     # Pass item details as parameters

Flow 4: Monitoring and Reporting Flow

Flow Name: "Document Set Conversion Monitor"

Trigger: When main flow completes

Actions:
1. Create Summary Report:
   Compose - Report:
     - Total Libraries Processed: @{length(variables('LibraryNames'))}
     - Total Document Sets Found: @{variables('ProcessedCount')}
     - Successful Conversions: @{length(variables('SuccessLog'))}
     - Failed Conversions: @{length(variables('ErrorLog'))}
     - Processing Time: @{formatDateTime(utcNow(), 'yyyy-MM-dd HH:mm:ss')}

2. Send Email Report:
   Send an email (V2):
     - To: [Admin email]
     - Subject: "Document Set Conversion Report"
     - Body: @{outputs('Compose_-_Report')}
     - Attachments: 
       - Success Log (JSON)
       - Error Log (JSON)

3. Log to SharePoint List:
   Create item:
     - Site: [Monitoring Site]
     - List: "DS Conversion Log"
     - Title: "Conversion Run - @{utcNow()}"
     - Summary: @{outputs('Compose_-_Report')}
     - SuccessCount: @{length(variables('SuccessLog'))}
     - ErrorCount: @{length(variables('ErrorLog'))}

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍. Regards, Riyaz