Triggered Actions - The list item could not be added (Item Id: 0)

Kilgore ServiceAccount

• Created March 14, 2023 19:13

Greetings,

Today is my first day interacting with Triggered Actions, and I have hit a wall.

I am attempting to setup an Action that :

1. executes when a Status = "Submitted" & a sub-status ="No". (both exist in List 1)

2. Add List Item (in List 2)

3. Updates List 1, sub-status to 'Yes' [I figured this was necessary to prevent duplicate items being created in List 2] 

 

I continually receive this error message: Failed to execute action 'Condition'. Details: The list item could not be added (Item Id: 0). This can happen if some column value is invalid.

Screenshots below...

Error Message

Overall Actions

 

Add List Item Action - Adding a new item to a different list - (I've tried it with =[[column]] & [[column]], if it matters)

 

Update Item Action (Not sure if Update behavior has anything to do with this, but I've tried it both way)

Update Item - with the only column being updated

 

Hopefully I provided enough information for someone to clearly see the mistake(s) I am making.

Thanks for your time,

Taylor

0

• 

  Matthias_Walter

  • March 14, 2023 20:01

  Hi Taylor Ram,

  can you please tell me the field types of those column in the source list (List 1), but as well in the target list (List 2) if they are different.

  In SharePoint you have to set each field a little different e.g. text and choice fields can simply be set as template or assignment expression whereas most other fields have to be set as assignment or function expression to have a strict type.

  User Picker fields and Lookups are special, because you have to set them with an ID (integer). The user picker can also be set using the email address.

  Let's try to use =[[ReportOwner.Id]] in the "Delay reported by" column and if CrewType is a lookup, then try like this =[[CrewType.Key]]

   

  Kind regards

  Matthias

  0
• 

  Kilgore ServiceAccount

  • March 15, 2023 17:22

  Matthias,

  Much appreciated! Using ".Id" after a People Picker field did the trick. 

  This might be a limitation, as I feel I've tried to accomplish this with Power Automate in the past, and I couldn't find any related forum posts...

  Is it possible to "copy" Image type columns using the Add List Item action?

  0
• 

  Matthias_Walter

  • March 15, 2023 21:29

  Hi Taylor Ram,

  you're welcome and great to hear that it works like this.

  The "new" image columns in SharePoint are kind of special as well how they store the value/image and therefore how you have to set it.

  To set such an image column and copy it over from another item's image column, you have to use an assignment expression as well using the following structure, where ImageColumn should be replaced with the internal field name of the image column to copy from:

  

  '{"type":"thumbnail","fileName":"[[ImageColumn.FileName]]","serverRelativeUrl":"[[ImageColumn.URL]]"}'

  0

Please sign in to leave a comment.