Action 'Add_attachment' failed

[KurtH1994]

Hi,

I am creating a flow so that when an attachment is added to a sharepoint list it archives the item and attachment to another sharepoint list and then deletes the original item. Unfortunately when the flow is running i am seeing an error:

See my flow below:

It is failing on add attachment step:

TIA,

Kurt

[ekarim2020]

Hi @KurtH1994 ,

Please check

(1) the Add attachment action is using the SharePoint ID from the Create Item Action:

(2) Confirm that SharePoint List contains an item with ID = 30

Add the ID column to your SharePoint view if needed:

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[KurtH1994]

Hi Ellis,

Thank you for your response, that is correct and the ID 30 does exist.

TIA

[ekarim2020]

Hi @KurtH1994 

I see there are nested Apply to Each loops in the flow.

(1) Where in the flow does the Add attachment action appear?

(2) Id field - Please confirm which action are you getting the ID from? 

 

The sequence of actions probably needs to be Create Item followed by Add Attachment?

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[KurtH1994]

Hi,

The ID is coming from the 'Get Item' action.

I have managed to get the flow to complete, however the new item is not being created within the "completed" sharepoint list. See flow order below:

TIA

[ekarim2020]

If I have understood correctly, after the Create Item action you want to then add file attachments to the newly created item? In that case the ID for the Add Attachment action should come from the Create Item action and not the Get Item action.

You may need to post some sample SharePoint data in order to understand how your flow works with the data.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[KurtH1994]

Hi,

That no longer returns an error, my only issue now is that the item is not being created in the new list. All actions in the 'create item' function come from the 'get item' function. See below flow:

TIA

[ekarim2020]

Please post some sample SharePoint data in order to understand how your flow works with the data with an explanation of how the data is read, used and then saved.

 
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[KurtH1994]

Hi Ellis,

Multiple people - yes

Multiple travel types - yes

Body = 'Get Attachments' action.

Thank you for your time and perseverance on this.

TIA

[ekarim2020]

Please supply some sample data and the SharePoint column names and data types:

For example, sample data:

And SharePoint Column types:

Ellis

[KurtH1994]

Hi Ellis,

Sample data:

Column Types:

TIA

[ekarim2020]

Hi @KurtH1994 ,

Thanks for the info. 

(1) If I understand correctly, this is what the flow is trying to achieve, more or less:

The actions in the archive process copy the item to another list and then delete the original item.

(2) How do you plan to handle instances when a user has saved a new item but now hen needs to edit the item due to missing or incorrect information that was added? If the user added an new item along with an attachment, the current flow would archive it and they wont be able to find the item to edit?

 

 

(3) The SharePoint connectors in Power Automate does not have a way to detect if a list item attachment was modified (i.e an additional file added to the list item, or the file was replaced with a new file.

Ellis

[KurtH1994]

Hi Ellis,

That is correct, i am going to tag an approval within the flow once i get it working so that the user confirms they want it to be archived. Additionally, the archive list will be accessible to users if they require to alter anything.

TIA

[ekarim2020]

Hi @KurtH1994 ,

Here are a few actions to try out, including a way to simplify the flow:

 

We can use a Select action to collect together the People travelling and the Travel types. This will avoid the multiple apply to each loops  that will create one a new item for each Person and Travel types:

Here is some sample data showing the outputs the Select actions :

 

In the Create item action we use the outputs from the Select action for the People Travelling and Travel Type columns. Remember to "Switch input to entire array":

Get the item's attachments:

Iterate through each attachment, and add the attachment to the newly created item in the Archive list:

 

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up. 

 

 

[KurtH1994]

Hi Ellis,

Thank you for that, it works well! However i am still experiencing issues with the people travelling column. See below error i am getting:

I had to alter your flow slightly to accommodate for apply each functions but it still is ok. See flow, i have set the parameters to the ones you discussed.

Thank you for your help on this, it is greatly appreciated!!!!