cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
suelahmed
Frequent Visitor

How to fix the following error?

Hi All,

I am currently getting an error while executing a flow.

The error is in one column particular. The excel sheet has a column that contains the hyperlink. These hyperlink needs to be copied to sharepoint list. But the flow is throwing the following error:

 

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

 

The sharepoint column type is string with rich text (hyperlink) enabled. I have also tried the column type as hyperlink.

1 ACCEPTED SOLUTION

Accepted Solutions

@suelahmed As excel connector does not return hyperlink attached with text. You need to create one more column in excel sheet and add Text hyperlink in that column then you can use it.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

View solution in original post

5 REPLIES 5
Hardesh15
Super User
Super User

@suelahmed  Pls use one compose action and pass your Excel column which has link. Share output of compose action.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

It gives the text but not the hyperlink.

manuelstgomes
Community Champion
Community Champion

Hi @suelahmed 

 

Just to complement @Hardesh15 good reply, notice that the value that is being provided in the "Update Item" step is "BPIA-00018" and that's not an URL. That's the error that you're getting. Please check if that column you have this value where an URL should be.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Hi,
This BPIA-0018 contains the hyperlink but in the flow I am getting only the text.

 

Thanks for the help thoughs

 

Regards,

suel

@suelahmed As excel connector does not return hyperlink attached with text. You need to create one more column in excel sheet and add Text hyperlink in that column then you can use it.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Kudoed Authors
Users online (3,922)