Add link from excel to sharepoint list

[ansanglan]

Hi everyone,

I built a flow that copies excel rows to a SharePoint list, but I can't get the 'link-item' to work. It should both have a description, and a link, but I don't know how to do that.

My excel file has two columns: [Link description] & [Link], and the Flow function 'create item' asks for a 'String/uri' format. My best try was to fill in the field like this: [link description]/[link] but that still gives me the following error message:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Link' is required to be of type 'String/uri'. The runtime value '"Google/https://www.google.com"' to be converted doesn't have the expected format 'String/uri'.

Thanks for the help!

[tom_riha · Accepted solution]

Hello @ansanglan ,

I don't think you can update [Link description] via Power Automate, the error message doesn't tell you that it'll accept format [Link description]/[Link], but that the data should be string in form of a uri. If you put in the field just the [Link] part it should work fine (without the Link description).

If you want to define also the [Link description], I'd use 'Multiple lines of text' column with 'Rich text' formatting instead of 'Hyperlink' column. That way you can input the HTML code for a link incl. description.

<a href="[Link]">[Link description]</a>

Note:
[..] are placeholders for the dynamic content from the Excel file

[ansanglan]

Thanks so much! The first option, using just the link didn't, had tried that also. But the second suggestion did the trick! Didn't know about the rich text option there, so that's good to know in other ways too!