Schedule create folders for monday to friday?

[sudosaurus]

Hello,

I'm looking to create a flow where on a weekly schedule trigger, would it be possible to create folders; Monday; Tuesday; Wednesday; Thursday; Friday. 

Ideally we'd like to append the date with a "-" between the day and the date.

Then at the end of the week have these folders moved to an archive folder, followed by the above re-running and creating new folders for the following week with their dates.

It sounds doable in theory but not sure where to start.

[Expiscornovus]

Hi @sudosaurus,

Great to hear that it works 🙂

[sudosaurus]

@Expiscornovus 

Hi Dennis,

The Move folders part of the workflow has broken - it doesnt appear to have worked for a few weeks.

This is the error:

Failed to verify the existence of destination location at 'https://mydomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/Sent' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.
clientRequestId: 8162eaa7-3eb9-4126-9559-d654060453f0
serviceRequestId: 8162eaa7-3eb9-4126-9559-d654060453f0

Any thoughts?

[Expiscornovus]

Hi @sudosaurus,

I need to refresh my memory on this specific automation 😁

That folder to move value looks a bit weird. It appears it tries to move something from the Sent folder. And the destination has two Sent folders in the path.

I thought we were excluding the folders within Post/Skypark Hub/Sent location from this move folder action? I remember using expression within the Filter Array for that? Can you check the expression in your Filter Array action?

[sudosaurus]

@Expiscornovus 

This is the filter array expression:

@and(and(and(and(and(not(equals(item()?['{Path}'], 'Post/Skypark Hub/Sent/')),equals(item()?['{IsFolder}'], true)), not(equals(item()?['{Name}'], 'Sent'))), not(equals(item()?['{Path}'], 'Post/'))),not(equals(item()?['{Path}'], 'Post/Tolvaddon Hub/Sent/'))),not(equals(item()?['{Path}'], 'Post/Worle Hub/Sent/')))

Essentially this is the folder structure:

Document library: Outgoing Post
 

Sub folder: Skypark Hub

Sub folders:

01-05-2022 - MONDAY - Cut Off 14.30pm
02-05-2022 - TUESDAY- Cut Off 14.30pm

03-05-2022 - WEDNESDAY- Cut Off 14.30pm

04-05-2022 - THURSDAY- Cut Off 14.30pm
05-05-2022 - FRIDAY- Cut Off 14.30pm

SENT

The script is supposed to move the above MON-FRI folders to the SENT folder.

[sudosaurus]

@Expiscornovus any ideas?

[Expiscornovus]

Hi @sudosaurus,

Apologies for the delayed reply.

It is odd that this specific folder is not filtered out based on the Path value filtering we are using in the Filter Array. Can you look up the Path and FullPath properties of this specific folder in the Outputs section of the Get files action in your flow run?

The errors suggest that these fields have different values than we were expecting them to be. I would also have expected that the target folder in the the move folder action would be 'Post/Skypark Hub/Sent', which it isn't.

[sudosaurus]

Hi @Expiscornovus 

Does this help?

"{Link}":"https://ondomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark%20Hub/Sent","{Name}":"Sent","{FilenameWithExtension}":"Sent","{Path}":"Post/Skypark Hub/","{FullPath}":"Post/Skypark Hub/Sent"

Bearing in mind this is affecting all 3 folders with a Sent folder within them.

[Expiscornovus]

Hi @sudosaurus,

That looks like a different folder. That would be the Sent folder, which should be ignored based on the not equals 'Sent' in the Name property in the Filter Array.

I am looking for the folder to move from your screenshot, which is causing the bad request (the value is not completely visible in your screenshot).

I guess it is something like:

Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/Mr N P

Can you check what the values are for this folder in the {Path} & {FullPath} properties?

[sudosaurus]

@Expiscornovus ah right ok, this should be it:

I've got the snippet from the Friday entry.

"{Link}":"https://ondomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark%20Hub/Sent/11-03-2022%20-%20FRIDAY%20-%20Cut%20Off%2014.30pm","{Name}":"11-03-2022 - FRIDAY - Cut Off 14.30pm","{FilenameWithExtension}":"11-03-2022 - FRIDAY - Cut Off 14.30pm","{Path}":"Post/Skypark Hub/Sent/","{FullPath}":"Post/Skypark Hub/Sent/11-03-2022 - FRIDAY - Cut Off 14.30pm","

[Expiscornovus]

Hi @sudosaurus,

Sorry, that still looks like a different folder. In your error screenshot it showed a subfolder within one of those days folders.

That example showed part of the name, which was Mr N P. However, the scrollbar in the screenshot also suggests that the subfolder name is probably a bit longer.

I expect that this specific subfolder should also be mentioned in the output as one of the items listed. For that specific item I am interested what the {Path} & {FullPath} values are.

We might need to update the filter array filter to make sure that they work with these type of items as well.

[sudosaurus]

@Expiscornovus 

I'm getting a little confused here..

This is how the Folder structure looks:

and using "Skypark Hub" as an example.

Each of the dated folders should be put into the "Sent" folder - these all contain files that have been scanned in on those days during the week.

[Expiscornovus]

Hi @sudosaurus,

Apologies that I made it a bit confusing. I understand that it should be ignoring items in the Sent folder. But based on your previous reply with the BadRequest error it is not doing that in certain cases.

That is what we are trying to figure out what is happening and that is why I am asking more details about that item which (incorrectly) is not ignored in the Filter Array action. 

Hopefully that makes sense? 

So, I am asking more details {Path} & {FullPath} about the subfolder from the error which the Move Folder action failed to move. That folder should be located within the 08-03-2022 - Tuesday folder which should be located in the Skypark Hub/Sent folder.

These details will help me to adjust the expression for the Filter Array action.

[sudosaurus]

@Expiscornovus 

Here's the error from yesterday's failed flow:

Failed to verify the existence of destination location at 'https://ondomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/Sent' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.
clientRequestId: 736a5151-565e-46ff-b6c6-5ca58c5298c9
serviceRequestId: 736a5151-565e-46ff-b6c6-5ca58c5298c9

This is the Output of the Move folder action although doesnt contain any path values:

{"statusCode":400,"headers":{"Vary":"Origin","X-SharePointHealthScore":"0","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"220","SPRequestGuid":"736a5151-565e-46ff-b6c6-5ca58c5298c9","request-id":"736a5151-565e-46ff-b6c6-5ca58c5298c9","MS-CV":"UVFqc15W/0a2xlyljFKYyQ.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com;","MicrosoftSharePointTeamServices":"16.0.0.22420","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"true","Cache-Control":"max-age=0, private","Date":"Sun, 08 May 2022 12:30:04 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Length":"435","Content-Type":"application/json","Expires":"Sat, 23 Apr 2022 12:30:04 GMT","Last-Modified":"Sun, 08 May 2022 12:30:04 GMT"},"body":{"status":400,"message":"Failed to verify the existence of destination location at 'https://ondomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/Sent' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.\r\nclientRequestId: 736a5151-565e-46ff-b6c6-5ca58c5298c9\r\nserviceRequestId: 736a5151-565e-46ff-b6c6-5ca58c5298c9"}}

This is a snippet from the Output of the Filter Array (I have renamed the data to protect customer sensitive information).

            "{Identifier}": "Post%252fSkypark%2bHub%252fSent%252f08-03-2022%2b-%2bTUESDAY%2b-%2bCut%2bOff%2b14.30pm%252fMr%2bG%2bGreen%2b%2b10%2bLake%2bAvenue%2bPL2%2bGHZ%2bMX%2bpack",
            "{IsFolder}": true,
            "{Thumbnail}": {
                "Large": null,
                "Medium": null,
                "Small": null
            },
            "{Link}": "https://ondomain.sharepoint.com/sites/SPS-NeighbourhoodHubs/Post/Skypark%20Hub/Sent/08-03-2022%20-%20TUESDAY%20-%20Cut%20Off%2014.30pm/Mr%15N%15Green%20%2010%20GreenLake%15Avenue%PL2GHZ%204NT%20MX%20pack",
            "{Name}": "Mr G Smith 15 Greenlake Avenue PL2 GHZ MX pack",
            "{FilenameWithExtension}": "Mr G Smith 15 Greenlake Avenue PL2 GHZ MX pack",
            "{Path}": "Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/",
            "{FullPath}": "Post/Skypark Hub/Sent/08-03-2022 - TUESDAY - Cut Off 14.30pm/Mr G Smith 15 Greenlake Avenue PL2 GHZ MX pack",
            "{IsCheckedOut}": false,
            "{VersionNumber}": "1.0"
        },

Does this help?

[Expiscornovus]

Hi @sudosaurus,

Thanks for your patience. Yes, that really helps. I will share a filter array expression later this evening.

Short explanation, the expression should look for Path starts not with Post/SkyparkHub/Sent instead of equals. That is why those subfolders are not ignored. Those have a different Path value. 

[Expiscornovus]

Hi @sudosaurus.

Can you try this expression in the filter array?

@and(and(and(and(and(not(startsWith(item()?['{Path}'], 'Post/Skypark Hub/Sent/')),equals(item()?['{IsFolder}'], true)), not(equals(item()?['{Name}'], 'Sent'))), not(equals(item()?['{Path}'], 'Post/'))),not(startsWith(item()?['{Path}'], 'Post/Tolvaddon Hub/Sent/'))),not(startsWith(item()?['{Path}'], 'Post/Worle Hub/Sent/')))

I have swapped the equals functions for the startsWith in all the {Path} checks where we are checking if it is a subfolder from the Sent items folder.

[sudosaurus]

Hi @Expiscornovus ,

I tried that but the Move folder action appears to have been skipped.

Is this maybe because last weeks folders and this week folders are in the same folder or should that not matter?

[Expiscornovus]

Hi @sudosaurus,

Which items did you expect to be moved? And are they listed in the Get Files action outputs?

It is very likely that is skipping the move folder because the Filter array items does not have any items left after filtering. Does the outputs section of that action show [] ?

[sudosaurus]

Hi @Expiscornovus ,

Yes, the output is only showing [].

[Expiscornovus]

Hi @sudosaurus,

Ok, thanks for checking. In that case it makes sense it skips the move folder. It does not have any items to loop through with the apply to each.

It is possible that the folders we want to move are even missing in the Get Files and that the Filter Array is not causing this. How are you sorting and filtering in your Get Files action at the moment?

If it helps for troubleshooting, I was using the configuration below to test it in my dev environment. I was only looking at recently created items.

Filter Query

Created ge '@{addDays(utcNow(),-7)}'

Order By

Created desc

[sudosaurus]

@Expiscornovus 

No filters or sorting at the moment: