OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

(0) Share

Report

Posted on by sudosaurus

1,597 Super User 2024 Season 1

Hello,

In the below flow, I have it set that when an item is created, the item is updated with a custom Contract Reference.

The next action, grabs that reference and creates a folder in a document library with the same name.

The next action is supposed to go back to the item and write the folder location URL path to the "Document Folder" column.

CSR_Flow3.1.png

CSR_Flow3.2.png

However, when the flow is run, it fails on the second "Update item" action and results in the following error.
* Note, the custom reference number is written to the list item and the folder is correctly created in the document library.

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DocumentFolder' is required to be of type 'String/uri'. The runtime value '"Contract Documents/"' to be converted doesn't have the expected format 'String/uri'.

All responses (6)

Answers (0)

kat on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

Refer to this article : Setting and Updating SharePoint Hyperlink fields in Flow and Logic Apps - Collab365
URLs are basically special objects and you should use a REST API call to update url fields.
Hope this helps, let me know if you need more help
Clint Woods 9 on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

Did you ever solve this? Please post the fix if so
sudosaurus 1,597 Super User 2024 Season 1 on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

Hello,

I am using the hyperlink type so that the URL is clickable..
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

Hi @sudosaurus

Thanks for the update.

Are you only updating Folder Path in your second Update Item? What's the column data type (text)?

Thanks
sudosaurus 1,597 Super User 2024 Season 1 on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

So, the "Contract Ref" column gets auto populated with this custom reference:
LWCM-DATE-ID

LWCM-@{formatDateTime(triggerOutputs()?['body/Contract_x0020_Start_x0020_Date'],'dd-MM-yyyy')}-@{triggerOutputs()?['body/ID']}

On the "Create folder in document library" action, a folder created and named the same as the custom reference number.

Then I have the second Update Item action where I choose Folder Path and place it in the "Document Folder" column which is of the type: URL or Picture
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: OpenApiOperationParameterTypeConversionFailed on Update Item - copying folder path from document library to list column

Hi @sudosaurus

What's the Date Type of Document Folder? Is this a string? Also check the runtime and see what value is returned for Folder Path?

A screenshot will be helpful.

Thanks