cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Misa
Kudo Commander
Kudo Commander

Creating dynamic URL in an HTML table

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.

 

JobOpp.PNGJob1.PNGJob3.PNG

 

 

 

2 REPLIES 2
SandyU
MVP

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 🙂 

 

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Misa
Kudo Commander
Kudo Commander

@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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,538)