web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / OpenApiOperationParame...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 1,599 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_Flow1.png

CSR_Flow2.png

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'.

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,998 Most Valuable Professional on at

    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

  • sudosaurus Profile Picture
    1,599 Super User 2024 Season 1 on at

    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']}

    contract-ref.png

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

     

    folders.png

     

    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

     

    doc folder.png

  • abm abm Profile Picture
    32,998 Most Valuable Professional on at

    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 Profile Picture
    1,599 Super User 2024 Season 1 on at

    Hello,

     

    I am using the hyperlink type so that the URL is clickable..

  • Clint Woods Profile Picture
    9 on at

    Did you ever solve this? Please post the fix if so

  • kat Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 312 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 154 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 143 Super User 2026 Season 2

Last 30 days Overall leaderboard