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": {
"parameters/sourceFileId": "@items('Foreach')?['ID']",
"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?
