When I add (modify) an item on a SP list, add the attachment into a folder in the library any time

[CarlesMartin]

Hi guys,

So i have created a flow that when I create an item, creates a folder for each one (they will have multiple versions of the document, so I created a library like an archive) and attaches the file every time. 

The flow is: When item created -> Create new folder -> Update file properties -> Get attachment -> Aply to each (Get attachment content -> Create file)

So I would be eliminating one attachment and adding a new one but I want those in the library to stay, even the obsolete. 

Would it be worth it to create it in a new flow or could it be possible to add what I am asking in the same one?

Thanks

[v-mengmli-msft]

Hi @CarlesMartin ,

Do you want to save newly added attachments to specific folder? I recommend you create another flow and use "When an item or a file is modified" as trigger.

How do you create the folder? It determines how to get the folder path. Assuming that you use Item's ID as folder name, please try this.

Best regards,

Rimmon

[CarlesMartin]

Hi @v-mengmli-msft ,

The way I create the folder is this one. The folder path is the "title" of the File. I get an error because copy file its only for libraries, not lists.

I also would want to update the file properties, as this will be a new revision of the file. How should it look then?

[v-mengmli-msft]

Hi @CarlesMartin ,

That will not make too much difference.

You just need to keep the dynamic folder path in the new flow.

If you also want to update file properties, you can add "Update file properties" action after the "Copy file" inside the "Apply to each".😀

Best regards,

Rimmon

[CarlesMartin]

So i am getting this error:

It seems "Copy file" its only meant to copy between libraries and not lists to library. Should I use another action?

[CarlesMartin]

hey @v-mengmli-msft !

New update, I used this:

Seems it work, but i get the same error in the update file properties as it "could not find list item". Don't know why exactly i am getting that.

[v-mengmli-msft]

Hi @CarlesMartin ,

Could you please show the details of "Update file properties"?

Best regards,

Rimmon

[CarlesMartin]

Yes @v-mengmli-msft ! It looks like this:

The thing is I want the folder with what new revision, but also that the new file in the folder has the new revision (updated from the item). 

I think I should add another action but getting this error I am kind of lost now.

[v-mengmli-msft]

Hi @CarlesMartin ,

It seems you are using Item's ID instead of file id to update file properties, please try use 'ItemId'.

Best regards,

Rimmon

[CarlesMartin]

hI @v-mengmli-msft ,

It works changing the "ID" to "ItemId". The thing is I also want to have the last revision in the folder as well as it is in the file inside. How should i add that?

[v-mengmli-msft]

Hi @CarlesMartin ,

Do you mean create another file with same content?

You can try use Copy file action inside Apply to each.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

If you have another question, please post it in new post.😀

Best regards,

Rimmon

[CarlesMartin]

No, when I modify the list, the item I get it goes to the folder in the library and the new revision is updated but in the file inside the folder. I want the folder also with the rev of the last revision (the same as the last file added)

[v-mengmli-msft]

Hi @CarlesMartin ,

I recommend you replace Create file with Copy file. The Copy file can save file with another file name if there is same file in folder already. Then, the new revision and the last revision are all kept.

Best regards,

Rimmon

[CarlesMartin]

The thing is I am getting right the file in am attaching in the list (when modify) + revisions. 

But then when I go to the folders, the folder Prueba 1 is not modified and it modifies a the folder Prueba 5

I cant create copy file because its not from library to library. 

Thats the last thing I need to solve. 🙂

I don't really know why that is happening. The folder nº5 is getting the modified when the item i am modifying is the nº1. The attachment but, goes to nº1.