Hello,
I have a sharepoint list where I want to enter multiple URLs for every row of the list. I want a power automate flow to enter the values into the list. For a single link I am able to do this using hyperlink column - but this works only for a single link. Then I tried out using multiple lines of text column and json formatting for the column
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "='@currentField' + @currentField"
}
}
This combines the multiple links into a single link
Eg: If the two links are www.google.com and www.gmail.com, the above json formatting makes it into a single link which is not useful for me. Basically, this json solution was working if there is a long link that does not fit in the hyperlink column. But now I have multiple links. I also tried out multiple lines of text columns with rich text-enabled. But when I edit in grid view and enter the links as an HTML tag <a href='www.google.com'> google </a>. But it comes as it is without any formatting like the below image:

I know when I type the links myself manually and click enter it comes as links. But I want to do this from power automate. So please let me know how to do this efficiently.
Thanks in advance
Pranathi B S