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

Notifications

Announcements

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,865 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,865 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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard