Unanswered

Read-Only Error when updating Microsoft Lists Multi-Choice Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've seen a couple of posts with similar issues but the work arounds haven't worked for me.

I have two Microsoft Lists involved. One tracks individual people while the other tracks engagements (Meetings, Interviews, etc.). The flow initiates when a new item is created in the engagements list. The aim is for it to get information on the individuals who are part of the engagement and then update the recently created item. In this case, the flow adds the organisation individuals are part of to and array and then attempts to update the new entry's column named "Organisations Involved".

The Flow:

Value of variable is set to the "Organisations Involved" just in case it is not empty

Get items used to get rows of stakeholders involved in engagement

For each of the items gotten previously: First check if the Organisation is already in the Organisations involved array. If it isnt, then it is appended.

Finally, the recently created item has the "Organisations Involved" column (Multi Choice Picker) updated with the Array of Organisations Involved.

On this last step is where I get the error. Everything is being run on my personal sharepoint site and the column is not set to read-only anywhere I can see

This is the error in its entirety:

The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/OrganisationsInvolved[0]/Id'. This parameter is read only.

Any help would be amazing. thank you in advance!

Categories:

Building flows

I have the same question (2)

All responses (5)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@nictherm1029 what is the data type of the column, is it multivalued choice column or multivalued lookup column?
If its multivalued choice column, in the append to array action, you need to provide the value in following format:
{ "<value select from dynamic content>": }

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the help!
The Column's data type is Multivalued choice.

I've made the change as seen below:

While I do not get the same error when I attempt a test, the last event in the flow "Update Item" doesnt ever finalise.
I haven't made any other changes.

Any help would be amazing, thank you for taking the time.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nictherm1029 i think i provided you incorrect format, can you please try below format in Append to array variable

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Anna,

It is now giving me this error

The closest I've managed to get it working is using the select function. For the append to array variable I left the formatting how I did originally and then used the select function to map Value to Item.

While this does not throw up any errors, as you can see in the picture below it is not ideal.
It seems to be that the output of "Get Item" and therefore input to append to array variable is:

{
  "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
  "Id": 1,
  "Value": "National Grid ESO"
}

When using the select function, the input to "Update Item" is:

[
  {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": -1,
    "Value":  {\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference\",\"Id\":1,\"Value\":\"National Grid ESO\"}"
  },
  {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": -1,
    "Value":  {\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference\",\"Id\":0,\"Value\":\"Arup\"}"
  }
]

Thank you so much for all the help, I really have no clue what to do.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nictherm1029 it looks like your column data type is not multi choice but multi lookup value, the solution that i provide to you was for multi choice column. To update value of multi valued lookup column do following:

1. You will need Id values of the values you want to update in lookup column, example you have organization values to be updated in column, that organization values must be coming from a source list, where each organization value has associated item id value, you need to get those item id value
2. Your append to array variable action should be in following format. Here Id value 4, in your case will be the Item Id value of organization value you want to update
3. Rest of the steps will be same

Was this reply helpful? Yes No