A bit of an odd one, but here it goes.
I am 90% of the way finished with this flow, I am just running into one hiccup that I can't figure out.
Here's the gist of it.
We have two SharePoint Lists that serve as file cabinets. (Yes, I know, that's what document libraries are for; but we needed the ability to update many columns for tracking purposes. So a list with Attachments it is.)
We have these sort of master template documents on one list, and I am building a flow to populate the secondary list with the copies of the template based upon a column which lists applicable locations.
I.E.
SP List 1
SP List 2
A file cabinet where applicable documents for each location are sorted.
_________________________________________________________________
When I run the flow, it grabs the related item, pulls the attachment information, creates the appropriate item with tracking info in List 2.
Everything is going great, it creates the new item and even pulls the attachments properly.
Where I am running into issues is adding the attachment to the appropriate folder (associated with the new Item on the second list).
Here is the error I keep getting.
Here is how the action is formatted.
The
Folder Path uses the
List Item ID as the path to the folder where the file should be stored within the database to show up as an attachment on the item.
I have tried it with and without the extra "/" at the end.
The
file name is just the file name being carried over from the previous action where it got the attachment contents; which works.
(Technically, it is a compose action using this code.)
items('For_each_3')?['DisplayName']
The
File Content is another portion of code using
{
"contentBytes": {
"$content-type": "@{body('Get_attachment_content')?['$content-type']}",
"$content": "@{body('Get_attachment_content')?['$content']}"
}
}
This appears to be working as well (I have used it in the past for a similar flow and was able to attach the Files to an email).
The whole issue comes in when I try to add the file to the newly created item. It keeps giving the error, claiming that it cannot create a folder.
I'm at a loss here.
Please help; how can
"Create" a new file in the appropriate place with the file contents of the original?
