Power Platform Community Forum Thread Details

Hello everyone!

I'm trying to create a flow in Power Automate that integrates with a PowerApps form and moves attachments to specific folders in a SharePoint document library based on information extracted from a SharePoint list. Below, I outline what I'm trying to achieve:

Flow Objective:

When a new form is submitted in PowerApps, I want the flow to:
1. Retrieve the attachment from the item in the SharePoint list.
2. Check the information for Function, Industry, and Client stored in that list.
3. Check in the document library if there is a folder with the name of the Function:
  - If yes, go into that folder and check if there is a subfolder with the name of the Industry:
    - If yes, go into that subfolder and check if there is a subfolder with the name of the Client:
      - If yes, move the attachment to that folder.
      - If no, create the Client folder and move the attachment there.
    - If no, create the Industry folder and the Client subfolder, then move the attachment to the newly created Client folder.
  - If no, create the Function folder, the Industry subfolder, and the Client subfolder, moving the attachment to the newly created Client folder.

Data Sources:

SharePoint List: Contains information about Function, Industry, and Client.
SharePoint Library: Where the folders should be created and where the attachment will be moved.