Update Properties step in a FLOW gives an error for a SPO library.

[SueA]

Hi:

I have the following Scenario:

1. I have a Master List containing Site URLs, respective Library Names and few other columns.
2. I have created a Recurrence FLOW for this Master list that goes thru this Master List, access each library using variables for the Site URL and the Library name.
3. Compares a Date value in the Library with a calculated date value (using a value from the Master List for this record).
4. If condition matched, updates a record in the library with a "Yes" for a "Record Review" library column.
5. I am able to access all the libraries (and respective data) listed in the Master List using the variables.
6. However, Update File Properties gives me an error below:

Error

Action 'Update file properties' failed

Documentation

https://docs.microsoft.com/en-us/connectors/sharepointonline/#known-issues-and-limitations

How to fix

If this error was temporary, you can try resubmitting the run and the issue may have been resolved.

I tried resubmitting many times, but the same error occurs after the FLOW hangs for at least half an hour for each Master List record.

See attached.

Also, all the input for this failed step seem correct. Output for Update Properties gives an error.

Thank you,
Sue

[tom_riha]

Hello @SueA ,

based on the error message you're trying to update the value 'True' to some column that doesn't want such value. Check which column it is, what type of column it is, and update it accordingly.

[SueA]

Hi Tom:

Thank you for your time to review this issue.

Per your suggestion, I changed the column type from "Yes/No" to a "Single line of text" data type. Set its variable to "Yes" and tried again.

And, I got the following error:

Error

Action 'Update_file_properties' failed

Documentation

https://docs.microsoft.com/en-us/connectors/sharepointonline/#known-issues-and-limitations

How to fix

If this error was temporary, you can try resubmitting the run and the issue may have been resolved.

When I looked at the Update File Properties Step, I see the following:

INPUT:

{

    "host": {

        "connectionReferenceName": "shared_sharepointonline",

        "operationId": "PatchFileItem"

    },

    "parameters": {

        "dataset": "https://pagov.sharepoint.com/sites/gg-dcsandbox3/SueTestSite/",

        "table": "https://pagov.sharepoint.com/sites/gg-dcsandbox3/SueTestSite/OBLIb1",

        "id": 1,

        "item": "Yes"

    }

}

OUPUT:

{

  "error": {

    "code": 502,

    "source": "power-apis-usgov001-public.azure-apihub.us",

    "clientRequestId": "3849e967-9c22-4fef-aca6-f1da8248caa6",

    "message": "BadGateway",

    "innerError": {

      "status": 500,

      "message": "Unexpected character encountered while parsing value: Y. Path '', line 0, position 0.\r\nclientRequestId: 3849e967-9c22-4fef-aca6-f1da8248caa6\r\nserviceRequestId: 3849e967-9c22-4fef-aca6-f1da8248caa6"

    }

  }

}

 Then, I changed the column type to Numeric, variable to Integer and set the variable to value to 1. 

Composed the variable.

Used OUTPUT of the Compose for the ITM value in the Update properties Step:

I then changed the Records Review column to "Numeric" Dat type.

With Variable to Numeric 

and set the variable to Number 1.

Then I ran the FLOW again. Errored out.

The Update Properties step showed the following as an output:

{

  "error": {

    "code": 502,

    "source": "power-apis-usgov001-public.azure-apihub.us",

    "clientRequestId": "6702f26d-51fd-4124-b497-928f90cc5f39",

    "message": "BadGateway",

    "innerError": {

      "status": 500,

      "message": "Error converting value 1 to type 'System.Collections.Generic.IDictionary`2[System.String,System.Object]'. Path '', line 1, position 1.\r\nclientRequestId: 6702f26d-51fd-4124-b497-928f90cc5f39\r\nserviceRequestId: 6702f26d-51fd-4124-b497-928f90cc5f39"

    }

  }

}

May be Microsoft needs to fix this part? or, I am doing something wrong and not know what it is to be able to fix it...

Thank you,
SueA.

[tom_riha · Accepted solution]

Hello @SueA ,

it's not clear what you use in the 'Item' field, but that must have a specific format:

{
"Column": "Value"
}

[SueA]

Hi Tom:

That worked! 🙂

Here are my steps:

• I used the RecordsReview column of data type Boolean (Yes/No).  (I also tried if the column was of datatype Single line of text and that worked as well!)
• Then Initiated a variable type Object with value in the format you suggested above and
• Then used the Compose step for the above variable.
• And finally, used the Compose output for the "Item:" field value in the Update Properties.
• And, it WORKED!

Wow! This is really amazing! I would not have been able to figure this on my own. Thank you for the valuable tip.

Deeply appreciate your kind support.

Regards,
SueA