Answered

Flow to copy elements from one list to another with the attached files in SharePoint

(0) Share

Report

Posted on by TonRigat

Hi,

We are trying to create a list from an existing list in another site in our SharePoint. Everything seems to work fine until we have to move the attached files too, to do this I created a flow, but it's showing me an error and I don't know how to solve it.

This is the flow that i'm working on.

And the error:

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report

It looks like the Item Id is not being filled in correctly. In the Items() part of the expression it is being filled with "A02" which is not an item number. Within Items() should be the list ID for the item so like items(1) would be the first item created in the list and items(10) would be the tenth item created in the list.

I don't know how or why that expression is being filled like that, but I think you need to check the outputs of the values for "Id" or "ID" or "ItemId" and see if that is causing the error.

I know file properties aren't always labeled like we expect for example if you run the power automate step Get File Metadata for a file in a document library the results will show "ItemId" as the item number from the list and the "Id" will be a encoded path to the document.

So check what values are being used as an Id or maybe use the Peek Code option for the step and see if that helps show where the value is coming from.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (2)

Report

For Get content from attachments you should be using the Identifier field from Get attachments, and for Add attachments you should be using the Identifier field from Create item. At the moment, you're using ID for both of them which is causing the issue.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
TonRigat 8 on at

Like (1)

Report

It kind of worked, with some other errors, but I got out of the loop.
I was trying to use an item I created inside the same list, because the ID it would not follow the order I intended, but it seems that this does not matter and works properly. Changing it to the ID was the solution.
I have some error now in the second loop where it has to attach the files, I'll try to solve it my self for now.
Thank you very much

Was this reply helpful? Yes No