@MGiles Here are a few recommendations I would make for your flow.
Trigger Conditions
I would recommend that you add a Trigger Condition to your flow. If I'm understanding your flow correctly, you only want to trigger this flow if a folder that starts with JOB_2 or RAP_2 is created.
For testing purposes, create a new flow. This way you can run a test and ensure you've set up the trigger conditions correctly before editing your current flow.
Click on Settings.
Scroll down to the bottom.
Insert this expression.
@and(equals(triggerOutputs()?['body/{IsFolder}'], true), or(startsWith(triggerOutputs()?['body/{Name}'], 'JOB_2'), startsWith(triggerOutputs()?['body/{Name}'], 'RAP_2')))
You need to add at least one other action. For testing purposes, add a Compose action and select any dynamic content. For my test, I selected the Name dynamic content from the flow trigger—this way I can verify the name of the folder created.
Run a test. First, try to:
- Create a file in your document library
- Create a folder that does not start with JOB_2 or RAP_2
See if your flow triggers (it shouldn't). Next, create a folder that starts with either JOB_2 or RAP_2. The flow should trigger.
Replace Variable with a Compose Action
It doesn't look like you are setting your Variable anywhere in your flow (unless I'm missing something). For that reason ... I would recommend using a Compose action instead.
Tip: Rename your actions to keep your flow organized. It's a lot easier to identify which dynamic content belongs with which action when they are named properly.
Manually Triggered Flow for Testing
I would recommend creating a new manually triggered flow for testing. Anytime you are building a flow with an automated trigger—start with a manually triggered flow. This can help to speed up your flow building/testing process as you don't need to trigger your flow by creating a file/folder, sending an email, filling out a form etc.
Also, by having a manually triggered flow—you can make modifications and test it out while triggering it manually and then make changes to your live flow. It's also a lot easier to run tests and troubleshoot early rather than after your entire flow is built.
Compose Folder Id
Add a Compose action to store the ID from the Get folder metadata action. You'll see why near the end of the flow.
Copy Folder
I believe your Copy Folder action isn't set up correctly. The Current Site Address should be the site where the folder (that was created) is currently.
In the Folder to Copy field, insert the output from the Compose action above.
For the Destination Site Address, select the site where you want to copy the folder to. This can be the same site or a totally different SP site.
For the Destination Folder, select the folder in which you'd like to Copy the Folder to.
Run a test. Verify that your folder was copied.
List Folder
Instead of a Get Files (properties only) action I would recommend using a List Folder action—since you are looking for a folder not a file.
Also, the Apply to each action (that you have in your current flow) isn't necessary if you are only returning a single folder. You might find this YT Tutorial helpful: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow
Filter Array
Add a Filter Array action. In the From field, insert the Body dynamic content from the action above.
In the first value field, insert the Name dynamic content from the List Folder action. Leave the operator to is equal to. In the second value field, insert the output from the Compose action that is storing the string of text you'd like to search for.
To learn more about how to use the Filter Array action, please refer to this recent YT Tutorial I uploaded.
Return Filter Array Count
Whenever I use a Filter Array action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow. Insert a Compose action.
Add an Expression. Use the length() function.
Select the Dynamic content tab and insert the body dynamic content from the Filter Array action into the length() function.
Run a test. Verify the output of the Compose action storing the Folder Count is 1.
Condition Check
Add a Condition action to check if the Filter Array action has returned a folder. There isn't a point to continue on with your flow if there isn't a folder that matches your requirements.
Insert the output from the Compose action into the first value field. Change the operator to is not equal to and enter zero into the second value field.
The rest of your actions can go into the Yes branch.
Compose Folder ID from Filter Array
Unfortunately, when you use the Filter Array action the dynamic content form it isn't available to select from. You'll need to use an expression. Add a Compose action to store the Folder ID returned from the Filter Array action.
View the Filter Array output from your previous flow run. For the expression you'll need the dynamic content key.
In the Folder to Copy field insert an expression. Start with the following:
?[0]['']
The Filter Array action will always return an array of items. To select the first item, we'll use the [0] index.
Enter the dynamic content key between the single quotes. In this case you need the Id. Enter Id between the single quotes. Please note, the dynamic content key is case sensitive.
Place your cursor at the start of the expression and select the Dynamic content tab. Insert the body dynamic content from the Filter Array action.
Copy Folder
Your current flow has a Copy File action. This may have been an error or I might be missing something. I'm under the impression you want to copy the folder. In which case, you'll need a Copy Folder action.
For the Folder to Copy, insert the output from the Compose action above.
For the Destination Site Address, select the site you'd like to Copy the folder to. From your post, it should be the site that triggered the flow. In this particular demo, it should be the same site selected in the Get folder metadata action.
For the Destination Folder. You indicated that you want to Copy this folder to the folder that originally triggered the flow (not the copied folder—correct?) If that is the case, you'll need to select the Path dynamic content from the Get folder metadata action (for this demo)—for your flow it would be from the Flow trigger.
We'll adjust the trigger of this flow near the end...
Run a test. Verify the folder has been copied to the correct location.
.....More to come. Ran out of time tonight.
Error Handling
Keep in mind that you might want to build in error handling for the Copy Folder actions. I'm not sure if there will ever be a case where the folder might already exist. Otherwise your flow will fail.
For more flow troubleshooting tips—check out This YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
