Moving Files from SharePoint Library to Another with Met Conditions

[KML]

Hello

This is my first attempt with Power Automate (I'm more familiar with SharePoint Designer)...I am trying to create a flow that will move files from one library to another when a specific field is modified to show a specific value. Right now, the flow works in I manually add the file name but I want the flow to identify all files that meet the criteria and then move them all.

My flow currently looks like this:

When I run the flow, I get an error on the Foreach:

The current code reads like this:

{

  "type": "Foreach",

  "foreach": "@triggerOutputs()?['body/value']",

  "actions": {

    "Condition": {

      "type": "If",

      "expression": {

        "equals": [

          "@items('Foreach')?['Status/Value']",

          "Signed & Sent"

        ]

      },

      "actions": {

        "Move_file": {

          "type": "OpenApiConnection",

          "inputs": {

            "parameters": {

              "dataset": "https://iconergyco.sharepoint.com/sites/Contracts",

              "parameters/sourceFileId": "@items('Foreach')?['ID']",

              "parameters/destinationDataset": "https://iconergyco.sharepoint.com/sites/Contracts",

              "parameters/destinationFolderPath": "/Archived Contracts",

              "parameters/nameConflictBehavior": 1

            },

            "host": {

              "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",

              "connection": "shared_sharepointonline",

              "operationId": "MoveFileAsync"

            }

          },

          "metadata": {

            "%252fActive%2bContracts%252fAD12%2bREFERENCE%2b-%2bC9901-FY21%2bIconergy%2bLTD_Consultant%2bAgreement%2b(GPE)%2b-%2bFully%2bExecuted.pdf": "/Active Contracts/AD12 REFERENCE - C9901-FY21 Iconergy LTD_Consultant Agreement (GPE) - Fully Executed.pdf"

          }

        }

      },

      "else": {

        "actions": {}

      }

    }

  },

  "runAfter": {}

}

In Editing the Flow, the ForEach parameters doesn't provide any options. 

What do I need to change in the Foreach parameter to make this flow work?

[SudeepGhatakNZ]

@KML 

Since you are using a "File is modified" trigger, it will execute for each file in the library separately. You do not need a loop. You might need to use a trigger condition because you only want to trigger the flow for a specific value in the field.

Trigger conditions - just what I needed - Powering your Apps (sudeepghatak.com)

[KML]

I'm afraid I'm going to need some more specific assistance. I tried modifying the Foreach to match what was in the link you provided and changed to my field, but it's still failing:

[SudeepGhatakNZ]

You don't need the loop

[KML]

I removed the loop and it is still failing:

The Condition code (that cannot be edited):

{
  "type": "If",
  "expression": {
    "and": [
      {
        "equals": [
          "@triggerBody()?['Status']?['Value']",
          "Signed & Sent"
        ]
      }
    ]
  },
  "actions": {
    "Move_file": {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "dataset": "https://iconergyco.sharepoint.com/sites/Contracts",
          "parameters/sourceFileId": "/Active Contracts",
          "parameters/destinationDataset": "https://iconergyco.sharepoint.com/sites/Contracts",
          "parameters/destinationFolderPath": "/Archived Contracts",
          "parameters/nameConflictBehavior": 1
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
          "connection": "shared_sharepointonline",
          "operationId": "MoveFileAsync"
        }
      }
    }
  },
  "else": {
    "actions": {}
  },
  "runAfter": {}

The Move file code that also cannot be edited:

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "dataset": "https://iconergyco.sharepoint.com/sites/Contracts",
      "parameters/sourceFileId": "/Active Contracts",
      "parameters/destinationDataset": "https://iconergyco.sharepoint.com/sites/Contracts",
      "parameters/destinationFolderPath": "/Archived Contracts",
      "parameters/nameConflictBehavior": 1
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "connection": "shared_sharepointonline",
      "operationId": "MoveFileAsync"
    }
  }
}

The field being used as the basis for whether a file is moved is the Status field. It's a choice field and if it is changed to Signed & Sent, I want the file to be moved to the other library.

The only way I have gotten it to work is to change the Parameters under Move file to indicate the exact file to move, which eliminates the whole purpose of an automated flow.

[SudeepGhatakNZ]

[KML]

I found the Identifier field as you show above, and I added what I thought that field was looking for...

And although the Flow saves just fine and doesn't return an error, when I test it, I still receive a Bad Request.

 

 

[SudeepGhatakNZ]

@KML ,

I see you are still referring the incorrect field. Just add the Identifier in there.

[KML]

Can you please tell me how I'm referring the incorrect field? The field that should trigger the move is the Status field that shows as Signed & Sent on any given file. I've tried it without the library name before the identifier and received the same error message.

[SudeepGhatakNZ]

Want me to take a look?

https://teams.microsoft.com/l/meetup-join/19:meeting_ODhjM2E1NGQtNzYwZS00NTFkLTg3YzItZGViZTg0MjU4NDA...

[KML]

That would be great. Perhaps sometime tomorrow?

[KML]

Hello. I've made some progress in that the flow claims to be running successfully, but the files are not actually being moved. Here is the Move file set-up:

Here is the Active Contracts library where the files should have been moved from:

[SudeepGhatakNZ]

What library is the flow running on?

From what I can see you have set up the Archived Contracts folder as your destination folder.

So the documents are meant to be copied to this folder when they are created.

Isn't that what you want?

[KML]

 Archived Contracts library is the destination once the file has been updated under Status to Signed & Sent not when it's created.

[KML]

Can anyone provide more assistance or is more information necessary?