Answered

Link to Sharepoint file in a HTML table- replace expression doesn't work

(0) Share

Report

Posted on by Idan

Hello,

I am trying to build a flow that sends a table with selected columns that comprises a list of files based on a condition (a column that has either a yes or no input).

It all works as intended but the only thing that I can't figure out is the link to the file in SharePoint comes out too long. I am trying to use the Concat and replace expression to "clean" it up but it doesn't seem to work:

the entire flow:

and here are the select expressions:

the concat formula:

concat('<a href="', item()?['{Link}'], '">', item()?['Title'], '</a>')

The compose step:

Compose Formula

replace(replace(replace(replace(replace(body('CreateTable'), '<', '<'), '>', '>'), '&amp', '&'), ''', '"'), '"', '"')

This is the output I am getting:

Please let me know what I am doing wrong.

Thanks!

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft on at

Like (1)

Report
Re: Link to Sharepoint file in a HTML table- replace expression doesn't work

Hi @Idan ,

I've made a test for your reference:

1\My flow

concat('<a href="', 'https://www.bing.com', '">', 'Click Me', '</a>')
replace(replace(replace(body('Create_HTML_table'),'<','<'),'"','"'),'>','>')

2\Result

Best Regards,

Bof

Was this reply helpful? Yes No
Idan on at

Like (0)

Report

Re: Link to Sharepoint file in a HTML table- replace expression doesn't work

Thanks Bof- it helped steer me in the right direction, however I am still missing one part.
If I write 'Click me' then it does indeed provide the link, however I want instead of "Click me" appearing, for the link to have the name of the file- for some reason when I have the following expression I get empty cells in the table:

concat('<a href="',item()?['{Link}'], '">', item()?['Title'], '</a>')

Any idea why?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Link to Sharepoint file in a HTML table- replace expression doesn't work

Hi @Idan ,

Based on your description, the value of item()?['Title'] is empty. Please check the output of the filter array.

Best Regards,

Bof

Was this reply helpful? Yes No
Idan on at

Like (0)

Report

Re: Link to Sharepoint file in a HTML table- replace expression doesn't work

It works! Thank you so much for your help, I have been scratching my head for the last 2 days!

Was this reply helpful? Yes No