cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerardoHdz
New Member

Read-Only Property Error when Updating SharePoint Lookup Field

Hi, all!

So, I have a "new item" SharePoint trigger in my flow.

Then I compose a couple of fields to update in the same item that triggered the flow.

SharePoint "Update Item" gives error:

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/Platforms_x0020__x0026__x0020_Mo[0]/Value'. This parameter is read only.

Field is not read-only, some similar issues are caused by parallel processes writing to the same record but doesn't seem to be my case (been looking in other posts).

Flow steps:

GerardoHdz_3-1634703465912.png

Error is in 'Platforms' field which is required so even if it's not changing it must be filled out.

So I take the same field as it comes out of the trigger:

GerardoHdz_2-1634703331700.png

Raw input, highlighting failing field (in array form, as expected to come from trigger itself):

GerardoHdz_4-1634704132144.png

Any help would be appreciated.

Thanks!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @GerardoHdz 

You need to parse the multi-select column, add just the value elements to an array variable and use that variable in your lookup column field.

I set up a flow, please take a try with the screenshots below.

This is my test list.

vLilyWmsft_6-1634888063213.png

Flow in details:

vLilyWmsft_0-1634887742520.png

vLilyWmsft_1-1634887751593.png

vLilyWmsft_2-1634887789846.png

Schema in ParseJSON action:

{
    "type""object",
    "properties": {
        "@@odata.type": {
            "type""string"
        },
        "Id": {
            "type""integer"
        },
        "Value": {
            "type""string"
        }
    }
}

vLilyWmsft_4-1634887876679.png
vLilyWmsft_5-1634887918440.png
After flow runs, it can update completed.
vLilyWmsft_7-1634888603529.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-LilyW-msft
Community Support
Community Support

Hi @GerardoHdz 

You also can refer to this article.

https://lodesharepoint.com/power-automate-input-parameters-error-id-readonly

Hope the content above may help you.

Best Regards

v-LilyW-msft
Community Support
Community Support

Hi @GerardoHdz 

You need to parse the multi-select column, add just the value elements to an array variable and use that variable in your lookup column field.

I set up a flow, please take a try with the screenshots below.

This is my test list.

vLilyWmsft_6-1634888063213.png

Flow in details:

vLilyWmsft_0-1634887742520.png

vLilyWmsft_1-1634887751593.png

vLilyWmsft_2-1634887789846.png

Schema in ParseJSON action:

{
    "type""object",
    "properties": {
        "@@odata.type": {
            "type""string"
        },
        "Id": {
            "type""integer"
        },
        "Value": {
            "type""string"
        }
    }
}

vLilyWmsft_4-1634887876679.png
vLilyWmsft_5-1634887918440.png
After flow runs, it can update completed.
vLilyWmsft_7-1634888603529.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,037)