Hi everyone.
I have a MS Forms that allows to users upload various files (0 to 10). In my PA flow I have a set that parse JSON from this field to collect name of the file(s), link etc.
One of my step is creat a HTML file on my Sharepoint that basically is a 'resume' of the MS Forms response. Now, I want to bring every link of these files that has been uploaded on MS Forms.
The problem is: if has a two or more files I can't list these links on my next step.
Solved! Go to Solution.
Hi @LeandroCampacci ,
I have made a simple test for your reference.
concat('<a href="', item()?['link'], '">Link</a>')
replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')
<!DOCTYPE html>
<html>
<head>
<style>
table {
border: 1px solid #1C6EA4;
text-align: left;
border-collapse: collapse;
background-color: #00FFFF;
}
td, th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
width: 25%;
}
</style>
</head>
<body>
<p> </p>
@{replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')}
</body>
</html>
Result Screenshots:
In addition, here is a link for your reference.
https://tomriha.com/how-to-add-hyperlink-in-the-create-html-table-power-automate-action/
Best Regards,
Charlie Choi
Hi @LeandroCampacci ,
I have made a simple test for your reference.
concat('<a href="', item()?['link'], '">Link</a>')
replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')
<!DOCTYPE html>
<html>
<head>
<style>
table {
border: 1px solid #1C6EA4;
text-align: left;
border-collapse: collapse;
background-color: #00FFFF;
}
td, th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
width: 25%;
}
</style>
</head>
<body>
<p> </p>
@{replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')}
</body>
</html>
Result Screenshots:
In addition, here is a link for your reference.
https://tomriha.com/how-to-add-hyperlink-in-the-create-html-table-power-automate-action/
Best Regards,
Charlie Choi
Thanks! That's works perfectly.
I will test in other scenarios, but this already helps me a lot. Thank you again!
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |
User | Count |
---|---|
49 | |
29 | |
24 | |
24 | |
20 |