Answered

How to fix the following error?

(0) Share

Report

Posted on by suelahmed

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.

Categories:

Process mining

All responses (5)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
suelahmed 17 on at

Like
a
(0)

Report
Copy link

Link copied!

It gives the text but not the hyperlink.
manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

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
suelahmed 17 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Thanks for the help thoughs

Regards,
suel
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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