Unanswered

Moving Files from SharePoint Library to Another with Met Conditions

(0) Share

Report

Posted on by 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?

All responses (14)

Answers (0)

KML 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

Can anyone provide more assistance or is more information necessary?
KML 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

Archived Contracts library is the destination once the file has been updated under Status to Signed & Sent not when it's created.
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

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 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

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:
KML 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

That would be great. Perhaps sometime tomorrow?
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

Want me to take a look?

https://teams.microsoft.com/l/meetup-join/19:meeting_ODhjM2E1NGQtNzYwZS00NTFkLTg3YzItZGViZTg0MjU4NDAw@thread.v2/0?context=%7B%22Tid%22:%22d1af847b-2ce1-44cb-bb50-d5802bb43c8b%22,%22Oid%22:%228e1962d6-5c17-4c03-a5c6-45e9bb81af78%22%7D
KML 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

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 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

@KML ,

I see you are still referring the incorrect field. Just add the Identifier in there.
KML 26 on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions

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 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Moving Files from SharePoint Library to Another with Met Conditions