Creating dynamic URL in an HTML table

(0) Share

Report

Posted on by Misa

248

Hello and happy Thursday.

I have a flow that will recur everyday. It will check the list for new jobs and it will send out a sort of newsletter. The jobs are tags with 1 of 5 departments. I created a Compose to filter out based off of department chosen. What i would like to do is create a custom hyperlink using a link name composed of 5 different columns.

For the Compose Expression Inputs: equals(items('Apply_to_each')?['accountFSO'], 'Analytics')

I created a variable (called linkFSO) that would concat the hyperlink name using the below formula:

Concat(triggerBody()?['projectTitle'],' // ' ,triggerBody()?['TheLevel'], '// ',triggerBody()?['Clearance'],' // ',triggerBody()?['LocationCity'],', ',triggerBody()?['LocationState'],' // ',triggerBody()?['Remote'])

In the Select HTML table value i use

Concat(<a href="(triggerBody()?['ReqUrl']">Outputs('linkFSO')</a>

What i would like to happen is that it will pull all of the items listed by department, group them and create hyperlinks using information from 5 columns.

ex:

Cyber Department

Title of Job / Job Level / Clearance / Location / Work from home <-- would link using a column value that contains a hyperlink
Title of Job / Job Level / Clearance / Location / Work from home
Title of Job / Job Level / Clearance / Location / Work from home

Analytics Department

Title of Job / Job Level / Clearance / Location / Work from home
Title of Job / Job Level / Clearance / Location / Work from home

and so and so on.

Hopefully this makes sense.

Thank you for your time.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

SandyU 225 on at

Like (0)

Report

Re: Creating dynamic URL in an HTML table

Hi @Misa

What result are you getting instead of what you are expecting...? Or are you getting an error at some point? I'm unsure what your question is 🙂

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

Re: Creating dynamic URL in an HTML table

@SandyU

Hi Sandy, when i try to update the equation it says that it's not valid. I got the idea from John Liu's youtube video on creating a Complex HTML table with Hyperlinks and it didn't work.

I have a Sharepoint list where employers list job openings. They submit to the list on a daily basis. At the moment, the job listings are manually added to an email newsletter and sent out to a distro list. The job listings are grouped by 5 departments. The hyperlinks are created by taking the values of 5 columns and merging them together. So it would look like Column 1 // Column 2 // Column 3 // Column 4 // Column 5. The links would use a URL supplied in another column of the same item.

I used the following formula to create the hyperlink:
Concat(<a href=\"(triggerBody()?['ReqUrl']">Outputs('linkFSO')</a>
linkFSO = Column 1 // Column 2 // Column 3 // Column 4 // Column 5 using the Compose Action

Ultimately they would like to automate it this process.

Was this reply helpful? Yes No